本文整理汇总了Python中trove.db.sqlalchemy.migrate_repo.schema.create_tables函数的典型用法代码示例。如果您正苦于以下问题:Python create_tables函数的具体用法?Python create_tables怎么用?Python create_tables使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了create_tables函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: upgrade
def upgrade(migrate_engine):
meta = MetaData()
meta.bind = migrate_engine
# new table with desired columns, indexes, and constraints
new_agent_heartbeats = Table(
'agent_heartbeats', meta,
Column('id', String(36), primary_key=True, nullable=False),
Column('instance_id', String(36),
nullable=False, unique=True, index=True),
Column('guest_agent_version', String(255), index=True),
Column('deleted', Boolean(), index=True),
Column('deleted_at', DateTime()),
Column('updated_at', DateTime(), nullable=False))
# original table from migration 005_heartbeat.py
previous_agent_heartbeats = Table('agent_heartbeats', meta, autoload=True)
try:
drop_tables([previous_agent_heartbeats])
except OperationalError as e:
logger.warn("This table may have been dropped by some other means.")
logger.warn(e)
create_tables([new_agent_heartbeats])
示例2: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
create_tables([configurations])
create_tables([configuration_parameters])
instances = Table('instances', meta, autoload=True)
instances.create_column(Column('configuration_id', String(36),
ForeignKey("configurations.id")))
示例3: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
create_tables([datastores, datastore_versions])
instances = Table('instances', meta, autoload=True)
datastore_version_id = Column('datastore_version_id', String(36),
ForeignKey('datastore_versions.id'))
instances.create_column(datastore_version_id)
instances.drop_column('service_type')
示例4: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
Table(
'instances',
meta,
autoload=True,
)
create_tables([security_groups, security_group_rules,
security_group_instance_associations])
示例5: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
Table('datastores', meta, autoload=True)
Table('datastore_versions', meta, autoload=True)
instances = Table('instances', meta, autoload=True)
create_tables([clusters])
instances.create_column(Column('cluster_id', String(36),
ForeignKey("clusters.id")))
instances.create_column(Column('shard_id', String(36)))
instances.create_column(Column('type', String(64)))
cluster_id_idx = Index("instances_cluster_id", instances.c.cluster_id)
cluster_id_idx.create()
示例6: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
create_tables([datastores, datastore_versions])
# ----------------------------------------------------
# Fore. 2014/06/19 Not modify old schemas on Instance.
# ----------------------------------------------------
instances = Table('instances', meta, autoload=True)
# datastore_version_id = Column('datastore_version_id', String(36),
# ForeignKey('datastore_versions.id'))
datastore_version_id = Column('datastore_version_id', String(36), nullable = True)
instances.create_column(datastore_version_id)
示例7: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
# for some reason we have to load the table before we can FK to it
Table('instances', meta, autoload=True)
create_tables([scheduled_task_types, scheduled_tasks])
scheduled_task_types.insert().values(
type='backup',
enabled=True,
description="Back up the data store for a specific instance:\n"
"This will perform a full backup at the scheduled interval "
"and incremental backups at a reasonable frequency in between",
).execute()
示例8: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
# since the downgrade is a no-op, an upgrade after a downgrade will
# cause an exception because the tables already exist
# we will catch that case and log an info message
try:
create_tables([configurations])
create_tables([configuration_parameters])
instances = Table('instances', meta, autoload=True)
instances.create_column(Column('configuration_id', String(36),
ForeignKey("configurations.id")))
except OperationalError as e:
logger.info(e)
示例9: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
instance_group = Table('instance_group', meta, autoload=True)
backups = Table('backups', meta, autoload=True)
backups.create_column(Column('group_id', String(36)))
backups.create_column(Column('type', String(36)))
backups.create_column(Column('expire_at',Integer()))
backups.create_column(Column('service_image_id',String(36)))
instances = Table('instances', meta, autoload=True)
instances.create_column(Column('group_id',String(36)))
# drop_tables([security_group_instance_associations])
create_tables([InstanceGroup,InstanceGroupItem,InstanceVip,Vips,Autobackup,
security_group_group_associations])
示例10: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
Table('datastores', meta, autoload=True)
Table('datastore_versions', meta, autoload=True)
instances = Table('instances', meta, autoload=True)
# since the downgrade is a no-op, an upgrade after a downgrade will
# cause an exception because the tables already exist
# we will catch that case and log an info message
try:
create_tables([clusters])
instances.create_column(Column('cluster_id', String(36),
ForeignKey("clusters.id")))
instances.create_column(Column('shard_id', String(36)))
instances.create_column(Column('type', String(64)))
cluster_id_idx = Index("instances_cluster_id", instances.c.cluster_id)
cluster_id_idx.create()
except OperationalError as e:
logger.info(e)
示例11: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
create_tables([conductor_lastseen])
示例12: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
create_tables([agent_heartbeats])
示例13: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
create_tables([root_enabled_history])
示例14: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
create_tables([private_net])
示例15: upgrade
def upgrade(migrate_engine):
meta.bind = migrate_engine
create_tables([quotas, quota_usages, reservations])