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])
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 # 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])
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.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 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 Table( 'instances', meta, autoload=True, ) create_tables([security_groups, security_group_rules, security_group_instance_associations])
def upgrade(migrate_engine): meta.bind = migrate_engine Table( 'instances', meta, autoload=True, ) create_tables([ security_groups, security_group_rules, security_group_instance_associations ])
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 upgrade(migrate_engine): meta.bind = migrate_engine ds_config_param = trove_schema.Table('datastore_configuration_parameters', meta, autoload=True) # Remove records with deleted=1 if 'deleted' in ds_config_param.c: ds_config_param.delete(). \ where(ds_config_param.c.deleted == 1). \ execute() # Delete columns deleted and deleted_at if migrate_engine.name != "sqlite": ds_config_param.drop_column('deleted') ds_config_param.drop_column('deleted_at') else: # It is not possible to remove a column from a table in SQLite. # SQLite is just for testing, so we re-create the table. ds_config_param.drop() meta.clear() trove_schema.Table('datastore_versions', meta, autoload=True) new_table = trove_schema.Table( 'datastore_configuration_parameters', meta, schema.Column('id', trove_schema.String(36), primary_key=True, nullable=False), schema.Column('name', trove_schema.String(128), primary_key=True, nullable=False), schema.Column('datastore_version_id', trove_schema.String(36), sqlalchemy.ForeignKey("datastore_versions.id"), primary_key=True, nullable=False), schema.Column('restart_required', trove_schema.Boolean(), nullable=False, default=False), schema.Column('max_size', trove_schema.String(40)), schema.Column('min_size', trove_schema.String(40)), schema.Column('data_type', trove_schema.String(128), nullable=False), schema.UniqueConstraint( 'datastore_version_id', 'name', name=('UQ_datastore_configuration_parameters_datastore_' 'version_id_name'))) trove_schema.create_tables([new_table])
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.bind = migrate_engine # for some reason we have to load the table before we can FK to it Table('instances', meta, autoload=True) create_tables([scheduled_task_types, scheduled_tasks]) scheduled_task_types.insert().values( type='backup', enabled=True, description="Back up the data store for a specific instance:\n" "This will perform a full backup at the scheduled interval " "and incremental backups at a reasonable frequency in between", ).execute()
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.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.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 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 create_tables([root_enabled_history])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([root_enabled_history])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([private_net])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([dns_records])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([usage_events])
def upgrade(migrate_engine): meta.bind = migrate_engine Table('datastore_versions', meta, autoload=True) create_tables([datastore_configuration_parameters])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([service_images])
def upgrade(migrate_engine): meta.bind = migrate_engine Table('datastores', meta, autoload=True) Table('datastore_versions', meta, autoload=True) create_tables([capabilities, capability_overrides])
def upgrade(migrate_engine): meta.bind = migrate_engine Table('datastore_versions', meta, autoload=True) create_tables([datastore_configuration_parameters])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([instances])
def upgrade(migrate_engine): meta.bind = migrate_engine # Load the datastore_versions table into the session. # creates datastore_version_metadata table Table('datastore_versions', meta, autoload=True) create_tables([datastore_version_metadata])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([usage_events])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([agent_heartbeats])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([conductor_lastseen])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([conductor_lastseen])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([instances])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([quotas, quota_usages, reservations])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([dns_records])
def upgrade(migrate_engine): meta.bind = migrate_engine Table('instances', meta, autoload=True) create_tables([modules, instance_modules])
def upgrade(migrate_engine): meta.bind = migrate_engine # Load the datastore_versions table into the session. # creates datastore_version_metadata table Table('datastore_versions', meta, autoload=True) create_tables([datastore_version_metadata])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([backups, ])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([service_images])
def upgrade(migrate_engine): meta.bind = migrate_engine Table('datastores', meta, autoload=True) Table('datastore_versions', meta, autoload=True) create_tables([capabilities, capability_overrides])
def upgrade(migrate_engine): meta.bind = migrate_engine create_tables([agent_heartbeats])
def upgrade(migrate_engine): meta.bind = migrate_engine Table('instances', meta, autoload=True) create_tables([modules, instance_modules])