本文整理汇总了Python中sqlalchemy.schema.CreateSequence方法的典型用法代码示例。如果您正苦于以下问题:Python schema.CreateSequence方法的具体用法?Python schema.CreateSequence怎么用?Python schema.CreateSequence使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类sqlalchemy.schema
的用法示例。
在下文中一共展示了schema.CreateSequence方法的7个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: test_schema_translate_map_sequence
# 需要导入模块: from sqlalchemy import schema [as 别名]
# 或者: from sqlalchemy.schema import CreateSequence [as 别名]
def test_schema_translate_map_sequence(self):
s1 = schema.Sequence("s1")
s2 = schema.Sequence("s2", schema="foo")
s3 = schema.Sequence("s3", schema="bar")
schema_translate_map = {None: "z", "bar": None, "foo": "bat"}
self.assert_compile(
schema.CreateSequence(s1),
"CREATE SEQUENCE [SCHEMA__none].s1 START WITH 1",
schema_translate_map=schema_translate_map,
)
self.assert_compile(
schema.CreateSequence(s2),
"CREATE SEQUENCE [SCHEMA_foo].s2 START WITH 1",
schema_translate_map=schema_translate_map,
)
self.assert_compile(
schema.CreateSequence(s3),
"CREATE SEQUENCE [SCHEMA_bar].s3 START WITH 1",
schema_translate_map=schema_translate_map,
)
示例2: upgrade
# 需要导入模块: from sqlalchemy import schema [as 别名]
# 或者: from sqlalchemy.schema import CreateSequence [as 别名]
def upgrade():
op.execute(CreateSequence(Sequence("task_id_sequence")))
op.execute(CreateSequence(Sequence("taskset_id_sequence")))
示例3: upgrade
# 需要导入模块: from sqlalchemy import schema [as 别名]
# 或者: from sqlalchemy.schema import CreateSequence [as 别名]
def upgrade():
# Create an auto-increment sequence for cards.id
conn = alembic.context.get_context().bind
meta = sqlalchemy.MetaData(bind=conn)
meta.reflect()
cards = meta.tables['cards']
# This table already has a (not-previously-used) auto-increment sequence in
# the production DB, but new DBs created from scratch via the alembic setup
# won't have it, so check if it already exists and create if it's missing
# to bring everything back into sync
if not cards.c.id.server_default or 'cards_id_seq' not in cards.c.id.server_default.arg.text:
maxid, = conn.execute(sqlalchemy.select([sqlalchemy.func.max(cards.c.id)])).first()
if maxid is None:
maxid = 0
alembic.op.execute(CreateSequence(Sequence('cards_id_seq', start=maxid + 1)))
alembic.op.alter_column("cards", "id", nullable=False, server_default=sqlalchemy.text("nextval('cards_id_seq'::regclass)"))
# Add cards.game column
# create it with a default but then remove the default, to set the value on
# all existing rows, but have the column mandatory in the future
alembic.op.drop_index("cards_name_idx")
alembic.op.add_column('cards',
sqlalchemy.Column('game', sqlalchemy.Integer, nullable=False, server_default='1')
)
alembic.op.alter_column("cards", "game", server_default=None)
alembic.op.create_index("cards_name_idx", "cards", ["game", "filteredname"], unique=True)
示例4: create_seq
# 需要导入模块: from sqlalchemy import schema [as 别名]
# 或者: from sqlalchemy.schema import CreateSequence [as 别名]
def create_seq(seq):
if dialect_supports_sequences():
op.execute(CreateSequence(seq))
示例5: downgrade
# 需要导入模块: from sqlalchemy import schema [as 别名]
# 或者: from sqlalchemy.schema import CreateSequence [as 别名]
def downgrade():
# Create new column 'id' and autoincrement its value
op.execute(CreateSequence(Sequence("carbonmonoxide_id_seq")))
op.add_column('carbonmonoxide', sa.Column(
'id', sa.INTEGER(), nullable=False,
server_default=sa.text("nextval('carbonmonoxide_id_seq'::regclass)")))
# Use 'id' as the new primary key
op.create_primary_key('carbonmonoxide_pkey', 'carbonmonoxide', ['id'])
示例6: _assert_create
# 需要导入模块: from sqlalchemy import schema [as 别名]
# 或者: from sqlalchemy.schema import CreateSequence [as 别名]
def _assert_create(self, elements, generator, argument):
self._assert_ddl(
(schema.CreateTable, schema.CreateSequence, schema.CreateIndex),
elements,
generator,
argument,
)
示例7: _assert_create_w_alter
# 需要导入模块: from sqlalchemy import schema [as 别名]
# 或者: from sqlalchemy.schema import CreateSequence [as 别名]
def _assert_create_w_alter(self, elements, generator, argument):
self._assert_ddl(
(schema.CreateTable, schema.CreateSequence, schema.AddConstraint),
elements,
generator,
argument,
)