本文整理汇总了Python中sqlalchemy.dialects.postgresql.TSVECTOR属性的典型用法代码示例。如果您正苦于以下问题：Python postgresql.TSVECTOR属性的具体用法？Python postgresql.TSVECTOR怎么用？Python postgresql.TSVECTOR使用的例子？那么, 这里精选的属性代码示例或许可以为您提供帮助。您也可以进一步了解该属性所在类sqlalchemy.dialects.postgresql的用法示例。
在下文中一共展示了postgresql.TSVECTOR属性的6个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: visit_TSVECTOR
# 需要导入模块: from sqlalchemy.dialects import postgresql [as 别名]
# 或者: from sqlalchemy.dialects.postgresql import TSVECTOR [as 别名]
def visit_TSVECTOR(self, type, **kw):
return "TSVECTOR" 示例2: downgrade
# 需要导入模块: from sqlalchemy.dialects import postgresql [as 别名]
# 或者: from sqlalchemy.dialects.postgresql import TSVECTOR [as 别名]
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('web_pages', sa.Column('previous_release', sa.INTEGER(), autoincrement=False, nullable=True))
op.create_foreign_key('web_pages_previous_release_fkey', 'web_pages', 'web_page_history', ['previous_release'], ['id'])
op.create_table('web_page_history',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('errno', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('url', sa.TEXT(), autoincrement=False, nullable=False),
sa.Column('file', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('distance', sa.INTEGER(), autoincrement=False, nullable=False),
sa.Column('is_text', sa.BOOLEAN(), autoincrement=False, nullable=True),
sa.Column('title', citext.CIText(), autoincrement=False, nullable=True),
sa.Column('mimetype', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('content', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('fetchtime', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('addtime', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('tsv_content', postgresql.TSVECTOR(), autoincrement=False, nullable=True),
sa.Column('root_rel', sa.INTEGER(), autoincrement=False, nullable=False),
sa.Column('newer_rel', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('older_rel', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('contenthash', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('is_diff', sa.BOOLEAN(), autoincrement=False, nullable=True),
sa.ForeignKeyConstraint(['file'], ['web_files.id'], name='web_page_history_file_fkey'),
sa.ForeignKeyConstraint(['newer_rel'], ['web_page_history.id'], name='web_page_history_newer_rel_fkey'),
sa.ForeignKeyConstraint(['older_rel'], ['web_page_history.id'], name='web_page_history_older_rel_fkey'),
sa.ForeignKeyConstraint(['root_rel'], ['web_pages.id'], name='web_page_history_root_rel_fkey'),
sa.PrimaryKeyConstraint('id', name='web_page_history_pkey')
)
### end Alembic commands ### 示例3: visit_TSVECTOR
# 需要导入模块: from sqlalchemy.dialects import postgresql [as 别名]
# 或者: from sqlalchemy.dialects.postgresql import TSVECTOR [as 别名]
def visit_TSVECTOR(self, type):
return "TSVECTOR" 示例4: visit_TSVECTOR
# 需要导入模块: from sqlalchemy.dialects import postgresql [as 别名]
# 或者: from sqlalchemy.dialects.postgresql import TSVECTOR [as 别名]
def visit_TSVECTOR(self, type_, **kw):
return "TSVECTOR" 示例5: special_types_table
# 需要导入模块: from sqlalchemy.dialects import postgresql [as 别名]
# 或者: from sqlalchemy.dialects.postgresql import TSVECTOR [as 别名]
def special_types_table(self, metadata):
# create these types so that we can issue
# special SQL92 INTERVAL syntax
class y2m(types.UserDefinedType, postgresql.INTERVAL):
def get_col_spec(self):
return "INTERVAL YEAR TO MONTH"
class d2s(types.UserDefinedType, postgresql.INTERVAL):
def get_col_spec(self):
return "INTERVAL DAY TO SECOND"
table = Table(
"sometable",
metadata,
Column("id", postgresql.UUID, primary_key=True),
Column("flag", postgresql.BIT),
Column("bitstring", postgresql.BIT(4)),
Column("addr", postgresql.INET),
Column("addr2", postgresql.MACADDR),
Column("price", postgresql.MONEY),
Column("addr3", postgresql.CIDR),
Column("doubleprec", postgresql.DOUBLE_PRECISION),
Column("plain_interval", postgresql.INTERVAL),
Column("year_interval", y2m()),
Column("month_interval", d2s()),
Column("precision_interval", postgresql.INTERVAL(precision=3)),
Column("tsvector_document", postgresql.TSVECTOR),
)
return table 示例6: test_tsvector_round_trip
# 需要导入模块: from sqlalchemy.dialects import postgresql [as 别名]
# 或者: from sqlalchemy.dialects.postgresql import TSVECTOR [as 别名]
def test_tsvector_round_trip(self, connection):
t = Table("t1", self.metadata, Column("data", postgresql.TSVECTOR))
t.create()
connection.execute(t.insert(), data="a fat cat sat")
eq_(connection.scalar(select([t.c.data])), "'a' 'cat' 'fat' 'sat'")
connection.execute(t.update(), data="'a' 'cat' 'fat' 'mat' 'sat'")
eq_(
connection.scalar(select([t.c.data])),
"'a' 'cat' 'fat' 'mat' 'sat'",
)