def upgrade(migrate_engine): meta.bind = migrate_engine # Load 'configurations' table to MetaData. Table('configurations', meta, autoload=True, autoload_with=migrate_engine) instances = Table('clusters', meta, autoload=True) instances.create_column(Column('configuration_id', String(36), ForeignKey("configurations.id")))
def upgrade(migrate_engine): meta = MetaData(bind=migrate_engine) configurations = Table('configurations', meta, autoload=True) created = Column('created', DateTime()) updated = Column('updated', DateTime()) configurations.create_column(created) configurations.create_column(updated)
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # add column: backups = Table('backups', meta, autoload=True) backups.create_column(Column('parent_id', String(36), nullable=True))
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")))
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) instances.create_column( Column(COLUMN_NAME, String(36), ForeignKey('instances.id')), nullable=True)
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")))
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) service_type = Column('service_type', String(36)) instances.create_column(service_type) instances.update().values({'service_type': 'mysql'}).execute()
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine ds_version = Table('datastore_versions', meta, autoload=True) ds_version.create_column(Column('image_tags', String(255), nullable=True)) ds_version.c.image_id.alter(nullable=True)
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) instances.create_column(Column(COLUMN_NAME, String(36), ForeignKey('instances.id')), nullable=True)
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # add column: instances = Table('instances', meta, autoload=True) instances.create_column(Column('tenant_id', String(36), nullable=True)) instances.create_column(Column('server_status', String(64)))
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()
def upgrade(migrate_engine): meta.bind = migrate_engine # Load 'configurations' table to MetaData. Table('configurations', meta, autoload=True, autoload_with=migrate_engine) instances = Table('clusters', meta, autoload=True) instances.create_column( Column('configuration_id', String(36), ForeignKey("configurations.id")))
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')
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # add column: instances = Table('instances', meta, autoload=True) instances.create_column(Column('deleted', Boolean())) instances.create_column(Column('deleted_at', DateTime()))
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine backups = Table('backups', meta, autoload=True) Table('datastore_versions', meta, autoload=True) datastore_version_id = Column('datastore_version_id', String(36), ForeignKey('datastore_versions.id')) backups.create_column(datastore_version_id)
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')
def upgrade(migrate_engine): meta.bind = migrate_engine instance_vip = Table('instance_vip', meta, autoload=True) instance_vip.create_column(Column('virtual_instance_id', String(36))) def update_instance_vips(): update(table = instance_vip, whereclause="deleted = 0", values=dict(virtual_instance_id = instance_vip.c.instance_id)).execute() update_instance_vips()
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # add column: instances = Table('instances', meta, autoload=True) volume_size = Column('volume_size', Integer()) flavor_id = Column('flavor_id', String(36)) instances.create_column(flavor_id) instances.create_column(volume_size)
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)
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)
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)
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # add column: backups = Table('backups', meta, autoload=True) try: parent_id = backups.c.parent_id except AttributeError as e: backups.create_column(Column('parent_id', String(36), nullable=True)) pass migrate_engine.execute('ALTER TABLE backups ADD INDEX backups_parent_id_idx (parent_id)') migrate_engine.execute('ALTER TABLE backups ADD INDEX backups_deleted_idx (deleted)')
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])
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)
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine ds_table = Table('datastores', meta, autoload=True) ds_version_table = Table('datastore_versions', meta, autoload=True) ds_version_table.create_column( Column('version', String(255), nullable=True)) ds_versions = select(columns=[text("id"), text("name")], from_obj=ds_version_table).execute() # Use 'name' value as init 'version' value for version in ds_versions: update(table=ds_version_table, whereclause=text("id='%s'" % version.id), values=dict(version=version.name)).execute() # Change unique constraint, need to drop the foreign key first and add back # later constraint_names = db_utils.get_foreign_key_constraint_names( engine=migrate_engine, table='datastore_versions', columns=['datastore_id'], ref_table='datastores', ref_columns=['id']) db_utils.drop_foreign_key_constraints( constraint_names=constraint_names, columns=[ds_version_table.c.datastore_id], ref_columns=[ds_table.c.id]) UniqueConstraint('datastore_id', 'name', name='ds_versions', table=ds_version_table).drop() UniqueConstraint('datastore_id', 'name', 'version', name='ds_versions', table=ds_version_table).create() db_utils.create_foreign_key_constraints( constraint_names=constraint_names, columns=[ds_version_table.c.datastore_id], ref_columns=[ds_table.c.id])
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])
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])
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()
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()
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine modules = Table('modules', meta, autoload=True) is_nullable = True if migrate_engine.name == "sqlite" else False column = Column(COLUMN_NAME_1, Boolean(), nullable=is_nullable, default=0) modules.create_column(column) column = Column(COLUMN_NAME_2, Integer(), nullable=is_nullable, default=5) modules.create_column(column) column = Column(COLUMN_NAME_3, Boolean(), nullable=is_nullable, default=0) modules.create_column(column) modules.c.contents.alter(Text(length=4294967295)) # mark all non-visible, auto-apply and all-tenant modules as is_admin update(table=modules, values=dict(is_admin=1), whereclause="visible=0 or auto_apply=1 or tenant_id is null" ).execute()
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine modules = Table('modules', meta, autoload=True) is_nullable = True if migrate_engine.name == "sqlite" else False column = Column(COLUMN_NAME_1, Boolean(), nullable=is_nullable, default=0) modules.create_column(column) column = Column(COLUMN_NAME_2, Integer(), nullable=is_nullable, default=5) modules.create_column(column) column = Column(COLUMN_NAME_3, Boolean(), nullable=is_nullable, default=0) modules.create_column(column) modules.c.contents.alter(Text(length=4294967295)) # mark all non-visible, auto-apply and all-tenant modules as is_admin update(table=modules, values=dict(is_admin=1), whereclause="visible=0 or auto_apply=1 or tenant_id is null" ).execute()
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)
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)
def upgrade(migrate_engine): meta.bind = migrate_engine backups = Table('backups', meta, autoload=True) backups.create_column(Column('extend',String(512)))
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # add column: datastore_versions = Table('datastore_versions', meta, autoload=True) datastore_versions.create_column(Column('default_configuration_id', String(36)))
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) instances.create_column(Column('access', Text(), nullable=True))
def upgrade(migrate_engine): meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) instances.create_column(Column('encrypted_key', String(255)))
def upgrade(migrate_engine): meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) instances.create_column(Column('region_id', String(255))) instances.update().values( region_id=CONF.service_credentials.region_name).execute()
def upgrade(migrate_engine): meta = MetaData() meta.bind = migrate_engine # add column: configurations = Table('configurations', meta, autoload=True) configurations.create_column(Column('config_type', String(1), default="1"))
def upgrade(migrate_engine): meta.bind = migrate_engine instances = Table('instances', meta, autoload=True) instances.create_column(Column('region_id', String(255))) instances.update().values(region_id=CONF.os_region_name).execute()