Python drop_tables Beispiele

Beispiel #1

Datei: 036_modify_template_field_type.py Projekt: zhouronghua/daisycloud-core

def downgrade(migrate_engine):
    print("036 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine

    tables = [define_component_config_table(meta)]
    drop_tables(tables)

Beispiel #2

Datei: 033_add_neutron_backend_table.py Projekt: zhouronghua/daisycloud-core

def downgrade(migrate_engine):
    print("033 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine

    tables = [define_neutron_backend_table(meta)]
    drop_tables(tables)

Beispiel #3

def upgrade(migrate_engine):
    print("038 upgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    tables = [define_tasks_table(meta), define_task_infos_table(meta)]
    drop_tables(tables)
    create_tables(tables)

Beispiel #4

Datei: 042_alter_config_template.py Projekt: zhouronghua/daisycloud-core

def downgrade(migrate_engine):
    print("042 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine

    tables = [define_template_config_roles_table(meta)]
    drop_tables(tables)

    configs = Table('configs', meta, autoload=True)
    template_config_id_reserve = getattr(configs.c, 'template_config_id')
    template_config_id_reserve.alter(type=String(36))

    template_config = Table('template_config', meta, autoload=True)
    id_reserve = getattr(template_config.c, 'id')
    id_reserve.alter(type=String(36))
    name_reserve = getattr(template_config.c, 'name')
    name_reserve.alter(type=String(50))

    template_func = Table('template_func', meta, autoload=True)
    id_reserve = getattr(template_func.c, 'id')
    id_reserve.alter(type=String(36))
    name_reserve = getattr(template_func.c, 'name')
    name_reserve.alter(type=String(36))

    template_func_configs = Table('template_func_configs', meta, autoload=True)
    id_reserve = getattr(template_func_configs.c, 'func_id')
    id_reserve.alter(type=String(36))
    name_reserve = getattr(template_func_configs.c, 'config_id')
    name_reserve.alter(type=String(36))

    config_service = Table('config_service', meta, autoload=True)
    config_id_reserve = getattr(config_service.c, 'config_id')
    config_id_reserve.alter(type=String(36))

Beispiel #5

Datei: 042_alter_config_template.py Projekt: openstack/daisycloud-core

def downgrade(migrate_engine):
    print("042 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine

    tables = [define_template_config_roles_table(meta)]
    drop_tables(tables)

    configs = Table('configs', meta, autoload=True)
    template_config_id_reserve = getattr(configs.c, 'template_config_id')
    template_config_id_reserve.alter(type=String(36))

    template_config = Table('template_config', meta, autoload=True)
    id_reserve = getattr(template_config.c, 'id')
    id_reserve.alter(type=String(36))
    name_reserve = getattr(template_config.c, 'name')
    name_reserve.alter(type=String(50))

    template_func = Table('template_func', meta, autoload=True)
    id_reserve = getattr(template_func.c, 'id')
    id_reserve.alter(type=String(36))
    name_reserve = getattr(template_func.c, 'name')
    name_reserve.alter(type=String(36))

    template_func_configs = Table('template_func_configs', meta, autoload=True)
    id_reserve = getattr(template_func_configs.c, 'func_id')
    id_reserve.alter(type=String(36))
    name_reserve = getattr(template_func_configs.c, 'config_id')
    name_reserve.alter(type=String(36))

    config_service = Table('config_service', meta, autoload=True)
    config_id_reserve = getattr(config_service.c, 'config_id')
    config_id_reserve.alter(type=String(36))

Beispiel #6

Datei: 033_add_neutron_backend_table.py Projekt: openstack/daisycloud-core

def downgrade(migrate_engine):
    print("033 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine

    tables = [define_neutron_backend_table(meta)]
    drop_tables(tables)

Beispiel #7

Datei: 038_add_task_table.py Projekt: openstack/daisycloud-core

def upgrade(migrate_engine):
    print("038 upgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    tables = [define_tasks_table(meta),
              define_task_infos_table(meta)]
    drop_tables(tables)
    create_tables(tables)

Beispiel #8

def downgrade(migrate_engine):
    print("044 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    tasks = Table('tasks', meta, autoload=True)
    tasks.drop_column(targets)
    tasks.drop_column(status)
    tables = [define_task_host_table(meta)]
    drop_tables(tables)

Beispiel #9

Datei: 037_add_targets_relation.py Projekt: openstack/daisycloud-core

def downgrade(migrate_engine):
    print("037 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    versions = Table('versions', meta, autoload=True)
    targets = Table('targets', meta, autoload=True)
    params = {'columns': [versions.c['target_id']],
              'refcolumns': [targets.c['id']],
              'name': 'versions_ibfk_1'}
    foreign = ForeignKeyConstraint(**params)
    foreign.drop()
    versions.drop_column(target_id)

    tables = [define_target_status_table(meta),
              define_targets_table(meta),
              define_host_versions_table(meta)]
    drop_tables(tables)

Beispiel #10

def downgrade(migrate_engine):
    print("037 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    versions = Table('versions', meta, autoload=True)
    targets = Table('targets', meta, autoload=True)
    params = {
        'columns': [versions.c['target_id']],
        'refcolumns': [targets.c['id']],
        'name': 'versions_ibfk_1'
    }
    foreign = ForeignKeyConstraint(**params)
    foreign.drop()
    versions.drop_column(target_id)

    tables = [
        define_target_status_table(meta),
        define_targets_table(meta),
        define_host_versions_table(meta)
    ]
    drop_tables(tables)

Beispiel #11

Datei: 039_add_lv_table.py Projekt: openstack/daisycloud-core

def downgrade(migrate_engine):
    print("039 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    tables = [define_logical_volume_table(meta)]
    drop_tables(tables)

Beispiel #12

def downgrade(migrate_engine):
    print("035 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    tables = [define_host_patch_history_table(meta)]
    drop_tables(tables)

Beispiel #13

def downgrade(migrate_engine):
    print("040 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    tables = [define_cluster_versions_table(meta)]
    drop_tables(tables)

Beispiel #14

Datei: 039_add_lv_table.py Projekt: zhouronghua/daisycloud-core

def downgrade(migrate_engine):
    print("039 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    tables = [define_logical_volume_table(meta)]
    drop_tables(tables)

Beispiel #15

Datei: 040_add_cluster_version.py Projekt: openstack/daisycloud-core

def downgrade(migrate_engine):
    print("040 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    tables = [define_cluster_versions_table(meta)]
    drop_tables(tables)

Beispiel #16

Datei: 035_add_host_patch_history.py Projekt: openstack/daisycloud-core

def downgrade(migrate_engine):
    print("035 downgrade")
    meta = MetaData()
    meta.bind = migrate_engine
    tables = [define_host_patch_history_table(meta)]
    drop_tables(tables)