Python drop_tables示例

示例#1

文件： 032_clusters.py 项目： Hopebaytech/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine

    datastore_versions = Table('datastore_versions', meta, autoload=True)
    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='clusters',
        columns=['datastore_version_id'],
        ref_table='datastore_versions',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names,
        columns=[clusters.c.datastore_version_id],
        ref_columns=[datastore_versions.c.id])

    instances = Table('instances', meta, autoload=True)
    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='instances',
        columns=['cluster_id'],
        ref_table='clusters',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names,
        columns=[instances.c.cluster_id],
        ref_columns=[clusters.c.id])

    instances.drop_column('cluster_id')
    instances.drop_column('shard_id')
    instances.drop_column('type')

    drop_tables([clusters])

示例#2

文件： 028_recreate_agent_heartbeat.py 项目： Tesora/tesora-trove

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])

示例#3

文件： 028_recreate_agent_heartbeat.py 项目： 2020human/trove-new

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])

示例#4

文件： 032_clusters.py 项目： zn-share/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine

    datastore_versions = Table('datastore_versions', meta, autoload=True)
    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='clusters',
        columns=['datastore_version_id'],
        ref_table='datastore_versions',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names,
        columns=[clusters.c.datastore_version_id],
        ref_columns=[datastore_versions.c.id])

    instances = Table('instances', meta, autoload=True)
    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='instances',
        columns=['cluster_id'],
        ref_table='clusters',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(constraint_names=constraint_names,
                                          columns=[instances.c.cluster_id],
                                          ref_columns=[clusters.c.id])

    instances.drop_column('cluster_id')
    instances.drop_column('shard_id')
    instances.drop_column('type')

    drop_tables([clusters])

示例#5

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([datastores, datastore_versions])
    instances = Table('instances', meta, autoload=True)
    instances.drop_column('datastore_version_id')
    service_type = Column('service_type', String(36))
    instances.create_column(service_type)
    instances.update().values({'service_type': 'mysql'}).execute()

示例#6

文件： 016_add_by_ksc.py 项目： zhujzhuo/trove-1.0.10.4

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    # modify column:
    backups = Table('backups', meta, autoload=True)
    backups.drop_column("group_id")
    backups.drop_column("type")
    backups.drop_column("expire_at")
    backups.drop_column("service_image_id")
    
    instances = Table('instances', meta, autoload=True)
    instances.drop_column('group_id')
    
    drop_tables([InstanceGroup,InstanceGroupItem,InstanceVip,Vips,Autobackup,
                 security_group_group_associations])

示例#7

文件： 020_configurations.py 项目： cretta/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    instances = Table('instances', meta, autoload=True)
    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='instances',
        columns=['configuration_id'],
        ref_table='configurations',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names,
        columns=[instances.c.configuration_id],
        ref_columns=[configurations.c.id])
    instances.drop_column('configuration_id')
    drop_tables([configuration_parameters, configurations])

示例#8

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    instances = Table('instances', meta, autoload=True)
    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='instances',
        columns=['configuration_id'],
        ref_table='configurations',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names,
        columns=[instances.c.configuration_id],
        ref_columns=[configurations.c.id])
    instances.drop_column('configuration_id')
    drop_tables([configuration_parameters, configurations])

示例#9

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    instances = Table('instances', meta, autoload=True)
    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='instances',
        columns=['datastore_version_id'],
        ref_table='datastore_versions',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names,
        columns=[instances.c.datastore_version_id],
        ref_columns=[datastore_versions.c.id])
    instances.drop_column('datastore_version_id')
    service_type = Column('service_type', String(36))
    instances.create_column(service_type)
    instances.update().values({'service_type': 'mysql'}).execute()
    drop_tables([datastore_versions, datastores])

示例#10

文件： 016_add_datastore_type.py 项目： AlexeyDeyneko/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    instances = Table('instances', meta, autoload=True)
    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='instances',
        columns=['datastore_version_id'],
        ref_table='datastore_versions',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names,
        columns=[instances.c.datastore_version_id],
        ref_columns=[datastore_versions.c.id])
    instances.drop_column('datastore_version_id')
    service_type = Column('service_type', String(36))
    instances.create_column(service_type)
    instances.update().values({'service_type': 'mysql'}).execute()
    drop_tables([datastore_versions, datastores])

示例#11

文件： 006_dns_records.py 项目： AlexeyDeyneko/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([dns_records])

示例#12

文件： 006_dns_records.py 项目： mlowery/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([dns_records])

示例#13

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([service_statuses])

示例#14

文件： 002_service_images.py 项目： AlexeyDeyneko/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([service_images])

示例#15

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([instances])

示例#16

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([
        security_group_instance_associations, security_group_rules,
        security_groups
    ])

示例#17

文件： 021_conductor_last_seen.py 项目： neetugrewal/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([conductor_lastseen])

示例#18

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([root_enabled_history])

示例#19

文件： 011_quota.py 项目： AlexeyDeyneko/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([quotas, quota_usages, reservations])

示例#20

文件： 011_quota.py 项目： vdialani/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([quotas, quota_usages, reservations])

示例#21

文件： 010_add_usage.py 项目： CiscoSystems/openstack-trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([usage_events])

示例#22

文件： 010_add_usage.py 项目： luccacabra/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([usage_events])

示例#23

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([datastore_version_metadata])

示例#24

文件： 028_ksc_private_net.py 项目： zhujzhuo/trove-1.0.10.4

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([private_net])

示例#25

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([backups, ])

示例#26

文件： 004_root_enabled.py 项目： abansal/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([root_enabled_history])

示例#27

文件： 026_add_scheduled_tasks.py 项目： wrongfan/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([scheduled_task_types, scheduled_tasks])

示例#28

文件： 005_heartbeat.py 项目： AlexeyDeyneko/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([agent_heartbeats])

示例#29

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([datastore_configuration_parameters])

示例#30

文件： 036_add_datastore_version_metadata.py 项目： Hopebaytech/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([datastore_version_metadata])

示例#31

文件： 027_add_datastore_capabilities.py 项目： stanleykao72/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([capability_overrides, capabilities])

示例#32

文件： 027_add_datastore_capabilities.py 项目： B-Rich/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([capabilities, capability_overrides])

示例#33

文件： 013_add_security_group_artifacts.py 项目： AlexeyDeyneko/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([security_group_instance_associations,
                 security_group_rules, security_groups])

示例#34

文件： 021_conductor_last_seen.py 项目： vdialani/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([conductor_lastseen])

示例#35

文件： 001_base_schema.py 项目： abansal/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([instances])

示例#36

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([agent_heartbeats])

示例#37

文件： 033_datastore_parameters.py 项目： AlexeyDeyneko/trove

def downgrade(migrate_engine):
    meta.bind = migrate_engine
    drop_tables([datastore_configuration_parameters])