Exemplos de drop_tables em Python

Exemplo n.º 1

Arquivo: 032_clusters.py Projeto: 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])

Exemplo n.º 2

Arquivo: 028_recreate_agent_heartbeat.py Projeto: 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])

Exemplo n.º 3

Arquivo: 028_recreate_agent_heartbeat.py Projeto: 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])

Exemplo n.º 4

Arquivo: 032_clusters.py Projeto: 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])

Exemplo n.º 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()

Exemplo n.º 6

Arquivo: 016_add_by_ksc.py Projeto: 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])

Exemplo n.º 7

Arquivo: 020_configurations.py Projeto: 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])

Exemplo n.º 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])

Exemplo n.º 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])

Exemplo n.º 10

Arquivo: 016_add_datastore_type.py Projeto: 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])

Exemplo n.º 11

Arquivo: 006_dns_records.py Projeto: AlexeyDeyneko/trove

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

Exemplo n.º 12

Arquivo: 006_dns_records.py Projeto: mlowery/trove

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

Exemplo n.º 13

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

Exemplo n.º 14

Arquivo: 002_service_images.py Projeto: AlexeyDeyneko/trove

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

Exemplo n.º 15

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

Exemplo n.º 16

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

Exemplo n.º 17

Arquivo: 021_conductor_last_seen.py Projeto: neetugrewal/trove

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

Exemplo n.º 18

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

Exemplo n.º 19

Arquivo: 011_quota.py Projeto: AlexeyDeyneko/trove

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

Exemplo n.º 20

Arquivo: 011_quota.py Projeto: vdialani/trove

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

Exemplo n.º 21

Arquivo: 010_add_usage.py Projeto: CiscoSystems/openstack-trove

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

Exemplo n.º 22

Arquivo: 010_add_usage.py Projeto: luccacabra/trove

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

Exemplo n.º 23

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

Exemplo n.º 24

Arquivo: 028_ksc_private_net.py Projeto: zhujzhuo/trove-1.0.10.4

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

Exemplo n.º 25

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

Exemplo n.º 26

Arquivo: 004_root_enabled.py Projeto: abansal/trove

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

Exemplo n.º 27

Arquivo: 026_add_scheduled_tasks.py Projeto: wrongfan/trove

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

Exemplo n.º 28

Arquivo: 005_heartbeat.py Projeto: AlexeyDeyneko/trove

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

Exemplo n.º 29

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

Exemplo n.º 30

Arquivo: 036_add_datastore_version_metadata.py Projeto: Hopebaytech/trove

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

Exemplo n.º 31

Arquivo: 027_add_datastore_capabilities.py Projeto: stanleykao72/trove

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

Exemplo n.º 32

Arquivo: 027_add_datastore_capabilities.py Projeto: B-Rich/trove

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

Exemplo n.º 33

Arquivo: 013_add_security_group_artifacts.py Projeto: AlexeyDeyneko/trove

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

Exemplo n.º 34

Arquivo: 021_conductor_last_seen.py Projeto: vdialani/trove

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

Exemplo n.º 35

Arquivo: 001_base_schema.py Projeto: abansal/trove

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

Exemplo n.º 36

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

Exemplo n.º 37

Arquivo: 033_datastore_parameters.py Projeto: AlexeyDeyneko/trove

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