Python Table.drop_column方法代碼示例

本文整理匯總了Python中trove.db.sqlalchemy.migrate_repo.schema.Table.drop_column方法的典型用法代碼示例。如果您正苦於以下問題：Python Table.drop_column方法的具體用法？Python Table.drop_column怎麽用？Python Table.drop_column使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類trove.db.sqlalchemy.migrate_repo.schema.Table的用法示例。

在下文中一共展示了Table.drop_column方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Python代碼示例。

示例1: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
def downgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine

    # drop column:
    backups = Table('backups', meta, autoload=True)
    backups.drop_column('parent_id')

開發者ID:AlexeyDeyneko，項目名稱:trove，代碼行數:9，代碼來源:022_add_backup_parent_id.py

示例2: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
def downgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine
    modules = Table('modules', meta, autoload=True)
    modules.drop_column(COLUMN_NAME_1)
    modules.drop_column(COLUMN_NAME_2)
    modules.drop_column(COLUMN_NAME_3)

開發者ID:Tesora-Release，項目名稱:tesora-trove，代碼行數:9，代碼來源:040_module_priority.py

示例3: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
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()

開發者ID:B-Rich，項目名稱:trove，代碼行數:10，代碼來源:016_add_datastore_type.py

示例4: upgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
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')

開發者ID:AlexeyDeyneko，項目名稱:trove，代碼行數:10，代碼來源:016_add_datastore_type.py

示例5: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
def downgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine

    # drop column:
    instances = Table('instances', meta, autoload=True)
    instances.drop_column('deleted')
    instances.drop_column('deleted_at')

開發者ID:AlexeyDeyneko，項目名稱:trove，代碼行數:10，代碼來源:009_add_deleted_flag_to_instances.py

示例6: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
def downgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine

    # drop column:
    backups = Table('backups', meta, autoload=True)
    migrate_engine.execute('DROP INDEX backups_parent_id_idx ON backups')
    migrate_engine.execute('DROP INDEX backups_deleted_idx ON backups')
    backups.drop_column('parent_id')

開發者ID:zhujzhuo，項目名稱:trove-1.0.10.4，代碼行數:11，代碼來源:027_add_by_ksc_add_backups_parent_id.py

示例7: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
def downgrade(migrate_engine):
    meta = MetaData()
    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=[COLUMN_NAME], ref_table="instances", ref_columns=["id"]
    )
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names, columns=[instances.c.slave_of_id], ref_columns=[instances.c.id]
    )
    instances.drop_column(COLUMN_NAME)

開發者ID:pombredanne，項目名稱:RDS，代碼行數:13，代碼來源:030_add_master_slave.py

示例8: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
def downgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine

    datastores = Table('datastores', meta, autoload=True)
    datastore_versions = Table('datastore_versions', meta, autoload=True)

    # drop column from datastore_versions
    datastore_versions.drop_column('manager')

    # add column to datastores
    manager = Column('manager', String(255))
    datastores.create_column(manager)

開發者ID:AlexeyDeyneko，項目名稱:trove，代碼行數:15，代碼來源:017_update_datastores.py

示例9: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
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])

開發者ID:zhujzhuo，項目名稱:trove-1.0.10.4，代碼行數:16，代碼來源:016_add_by_ksc.py

示例10: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
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])

開發者ID:cretta，項目名稱:trove，代碼行數:17，代碼來源:020_configurations.py

示例11: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
def downgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine
    backups = Table('backups', meta, autoload=True)
    datastore_versions = Table('datastore_versions', meta, autoload=True)
    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='backups',
        columns=['datastore_version_id'],
        ref_table='datastore_versions',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names,
        columns=[backups.c.datastore_version_id],
        ref_columns=[datastore_versions.c.id])
    backups.drop_column('datastore_version_id')

開發者ID:AlexeyDeyneko，項目名稱:trove，代碼行數:18，代碼來源:029_add_backup_datastore.py

示例12: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
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])

開發者ID:AlexeyDeyneko，項目名稱:trove，代碼行數:20，代碼來源:016_add_datastore_type.py

示例13: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
def downgrade(migrate_engine):
    meta.bind = migrate_engine
    clusters = Table('clusters', meta, autoload=True)
    configurations = Table('configurations', meta, autoload=True,
                           autoload_with=migrate_engine)

    constraint_names = db_utils.get_foreign_key_constraint_names(
        engine=migrate_engine,
        table='clusters',
        columns=['configuration_id'],
        ref_table='configurations',
        ref_columns=['id'])
    db_utils.drop_foreign_key_constraints(
        constraint_names=constraint_names,
        columns=[clusters.c.configuration_id],
        ref_columns=[configurations.c.id])

    clusters.drop_column('configuration_id')

開發者ID:Tesora，項目名稱:tesora-trove，代碼行數:20，代碼來源:041_add_cluster_configuration_id.py

示例14: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
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])

開發者ID:Hopebaytech，項目名稱:trove，代碼行數:34，代碼來源:032_clusters.py

示例15: downgrade

# 需要導入模塊: from trove.db.sqlalchemy.migrate_repo.schema import Table [as 別名]
# 或者: from trove.db.sqlalchemy.migrate_repo.schema.Table import drop_column [as 別名]
def downgrade(migrate_engine):
    meta = MetaData()
    meta.bind = migrate_engine
    # modify column:
    instances = Table('instances', meta, autoload=True)
    instances.drop_column('service_type')

開發者ID:AlexeyDeyneko，項目名稱:trove，代碼行數:8，代碼來源:015_add_service_type.py

注：本文中的trove.db.sqlalchemy.migrate_repo.schema.Table.drop_column方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。