在不带to_tsvector的ts_vector列上进行SQLAlchemy搜索

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class MyTable(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    ts_vector_column = Column(String)

# 创建数据库连接
engine = create_engine('postgresql://username:password@localhost/mydatabase')
Session = sessionmaker(bind=engine)
session = Session()

# 执行搜索
query = 'keyword'
results = session.query(MyTable).filter(MyTable.ts_vector_column.op('@@')(query)).all()

from sqlalchemy import create_engine, Column, Integer, String, func
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class MyTable(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    ts_vector_column = Column(String)

# 创建数据库连接
engine = create_engine('postgresql://username:password@localhost/mydatabase')
Session = sessionmaker(bind=engine)
session = Session()

# 执行搜索
query = 'keyword'
results = session.query(MyTable).filter(func.ts_match(query, MyTable.ts_vector_column)).all()