def restore_legacy_patching(): op.add_column( 'releases', sa.Column( 'can_update_from_versions', fields.JSON(), nullable=False, server_default='[]' )) op.add_column( 'clusters', sa.Column( 'pending_release_id', sa.Integer(), nullable=True )) op.create_foreign_key( 'fk_pending_release_id', 'clusters', 'releases', ['pending_release_id'], ['id']) upgrade_enum( "clusters", # table "status", # column "cluster_status", # ENUM name cluster_statuses_new, # new options cluster_statuses_old, # old options )
def extend_segmentation_type_downgrade(): segmentation_type_old = ('vlan', 'gre') segmentation_type_new = ('vlan', 'gre', 'tun') upgrade_enum('neutron_config', 'segmentation_type', 'segmentation_type', segmentation_type_new, segmentation_type_old)
def downgrade_remove_vmware(): op.add_column( 'releases', sa.Column('vmware_attributes_metadata', fields.JSON(), nullable=True)) op.create_table('vmware_attributes', sa.Column('id', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer()), sa.Column('editable', fields.JSON()), sa.ForeignKeyConstraint( ['cluster_id'], ['clusters.id'], ), sa.PrimaryKeyConstraint('id')) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_new, # new options cluster_changes_old # old options ) op.drop_constraint('vmware_attributes_cluster_id_fkey', 'vmware_attributes', type_='foreignkey') op.create_foreign_key('vmware_attributes_cluster_id_fkey', 'vmware_attributes', 'clusters', ['cluster_id'], ['id'], ondelete='CASCADE')
def downgrade_release_state(): connection = op.get_bind() connection.execute(sa.sql.text("UPDATE releases SET state='available' WHERE state!='unavailable'")) op.add_column("releases", sa.Column("is_deployable", sa.Boolean(), nullable=False, server_default="true")) upgrade_enum("releases", "state", "release_state", release_states_new, release_states_old)
def upgrade_release_state(): connection = op.get_bind() op.drop_column("releases", "is_deployable") upgrade_enum("releases", "state", "release_state", release_states_old, release_states_new) connection.execute(sa.sql.text("UPDATE releases SET state='manageonly' WHERE state!='unavailable'"))
def downgrade_remove_vmware(): op.add_column( 'releases', sa.Column('vmware_attributes_metadata', fields.JSON(), nullable=True)) op.create_table( 'vmware_attributes', sa.Column('id', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer()), sa.Column('editable', fields.JSON()), sa.ForeignKeyConstraint(['cluster_id'], ['clusters.id'], ), sa.PrimaryKeyConstraint('id')) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_new, # new options cluster_changes_old # old options ) op.drop_constraint( 'vmware_attributes_cluster_id_fkey', 'vmware_attributes', type_='foreignkey' ) op.create_foreign_key( 'vmware_attributes_cluster_id_fkey', 'vmware_attributes', 'clusters', ['cluster_id'], ['id'], ondelete='CASCADE' )
def add_node_discover_error_downgrade(): upgrade_enum( "nodes", "error_type", "node_error_type", node_errors_new, node_errors_old )
def downgrade_orchestrator_task_types(): upgrade_enum( 'deployment_graph_tasks', 'type', 'deployment_graph_tasks_type', orchestrator_task_types_new, orchestrator_task_types_old )
def downgrade_neutron_l23_providers(): upgrade_enum( "neutron_config", # table "net_l23_provider", # column "net_l23_provider", # ENUM name neutron_l23_providers_new, # old options neutron_l23_providers_old # new options )
def downgrade_bond_modes(): upgrade_enum( 'node_bond_interfaces', # table 'mode', # column 'bond_mode', # ENUM name bond_modes_new, # old options bond_modes_old, # new options )
def downgrade_node_status_attributes(): upgrade_enum( "nodes", # table "status", # column "node_status", # ENUM name node_statuses_new, # old options node_statuses_old # new options )
def task_names_downgrade(): upgrade_enum( "tasks", "name", "task_name", task_names_new, task_names_old )
def downgrade_task_names(): upgrade_enum( "tasks", # table "name", # column "task_name", # ENUM name task_names_new, # old options task_names_old # new options )
def downgrade_node_stop_deployment_error_type(): upgrade_enum( "nodes", "error_type", "node_error_type", node_errors_new, node_errors_old )
def downgrade_transaction_names(): migration.upgrade_enum( 'tasks', 'name', 'task_name', TASK_NAMES_NEW, TASK_NAMES_OLD )
def downgrade_transaction_names(): upgrade_enum( 'tasks', 'name', 'task_name', transaction_names_new, transaction_names_old )
def task_names_upgrade(): upgrade_enum( "tasks", "name", "task_name", task_names_old, task_names_new )
def downgrade_schema(): # commands auto generated by Alembic - please adjust! ### op.drop_column('nodes', 'replaced_provisioning_info') op.drop_column('nodes', 'replaced_deployment_info') upgrade_enum( "neutron_config", # table "net_l23_provider", # column "net_l23_provider", # ENUM name neutron_l23_providers_new, # old options neutron_l23_providers_old # new options ) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_new, # new options cluster_changes_old, # old options ) upgrade_enum( "notifications", # table "topic", # column "notif_topic", # ENUM name notification_topics_new, # new options notification_topics_old, # old options ) upgrade_enum( "tasks", # table "name", # column "task_name", # ENUM name task_names_new, # old options task_names_old # new options ) upgrade_enum( "clusters", # table "status", # column "cluster_status", # ENUM name cluster_statuses_new, # old options cluster_statuses_old # new options ) op.drop_constraint('fk_pending_release_id', 'clusters', type_='foreignkey') op.drop_column('clusters', 'pending_release_id') op.drop_column('releases', 'can_update_from_versions') op.create_table( 'red_hat_accounts', sa.Column('id', sa.Integer(), nullable=False), sa.Column('username', sa.String(length=100), nullable=False), sa.Column('password', sa.String(length=100), nullable=False), sa.Column('license_type', sa.Enum('rhsm', 'rhn', name='license_type'), nullable=False), sa.Column('satellite', sa.String(length=250), nullable=False), sa.Column('activation_key', sa.String(length=300), nullable=False), sa.PrimaryKeyConstraint('id'))
def downgrade_schema(): ### commands auto generated by Alembic - please adjust! ### op.drop_column("nodes", "replaced_provisioning_info") op.drop_column("nodes", "replaced_deployment_info") upgrade_enum( "neutron_config", # table "net_l23_provider", # column "net_l23_provider", # ENUM name neutron_l23_providers_new, # old options neutron_l23_providers_old, # new options ) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_new, # new options cluster_changes_old, # old options ) upgrade_enum( "notifications", # table "topic", # column "notif_topic", # ENUM name notification_topics_new, # new options notification_topics_old, # old options ) upgrade_enum( "tasks", # table "name", # column "task_name", # ENUM name task_names_new, # old options task_names_old, # new options ) upgrade_enum( "clusters", # table "status", # column "cluster_status", # ENUM name cluster_statuses_new, # old options cluster_statuses_old, # new options ) op.drop_constraint("fk_pending_release_id", "clusters", type_="foreignkey") op.drop_column("clusters", "pending_release_id") op.drop_column("releases", "can_update_from_versions") op.create_table( "red_hat_accounts", sa.Column("id", sa.Integer(), nullable=False), sa.Column("username", sa.String(length=100), nullable=False), sa.Column("password", sa.String(length=100), nullable=False), sa.Column("license_type", sa.Enum("rhsm", "rhn", name="license_type"), nullable=False), sa.Column("satellite", sa.String(length=250), nullable=False), sa.Column("activation_key", sa.String(length=300), nullable=False), sa.PrimaryKeyConstraint("id"), )
def downgrade_schema(): # OpenStack workload statistics op.drop_table('oswl_stats') drop_enum('oswl_resource_type') upgrade_enum( 'releases', # table 'state', # column 'release_state', # ENUM name release_states_new, # new options release_states_old, # old options ) op.drop_column('clusters', 'deployment_tasks') op.drop_column('releases', 'deployment_tasks')
def drop_legacy_patching(): upgrade_enum( "clusters", # table "status", # column "cluster_status", # ENUM name cluster_statuses_old, # old options cluster_statuses_new, # new options ) op.drop_constraint( 'fk_pending_release_id', 'clusters', type_='foreignkey' ) op.drop_column('clusters', 'pending_release_id') op.drop_column('releases', 'can_update_from_versions')
def upgrade_release_state(): connection = op.get_bind() op.drop_column('releases', 'is_deployable') upgrade_enum( 'releases', 'state', 'release_state', release_states_old, release_states_new, ) connection.execute( sa.sql.text( "UPDATE releases SET state='manageonly' WHERE state!='unavailable'" ))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.add_column( 'releases', sa.Column( 'can_update_from_versions', JSON(), nullable=False, server_default='[]' ) ) op.add_column( 'clusters', sa.Column( 'pending_release_id', sa.Integer(), nullable=True ) ) op.create_foreign_key( 'fk_pending_release_id', 'clusters', 'releases', ['pending_release_id'], ['id'], ) upgrade_enum( "clusters", # table "status", # column "cluster_status", # ENUM name cluster_statuses_old, # old options cluster_statuses_new # new options ) upgrade_enum( "tasks", # table "name", # column "task_name", # ENUM name task_names_old, # old options task_names_new # new options ) upgrade_enum( "notifications", # table "topic", # column "notif_topic", # ENUM name old_notification_topics, # old options new_notification_topics, # new options ) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_old, # old options cluster_changes_new # new options ) op.drop_table('red_hat_accounts') drop_enum('license_type')
def upgrade_schema(): ### commands auto generated by Alembic - please adjust! ### op.add_column("releases", sa.Column("can_update_from_versions", JSON(), nullable=False, server_default="[]")) op.add_column("releases", sa.Column("wizard_metadata", JSON(), nullable=True)) op.add_column("clusters", sa.Column("pending_release_id", sa.Integer(), nullable=True)) op.create_foreign_key("fk_pending_release_id", "clusters", "releases", ["pending_release_id"], ["id"]) upgrade_enum( "clusters", # table "status", # column "cluster_status", # ENUM name cluster_statuses_old, # old options cluster_statuses_new, # new options ) upgrade_enum( "tasks", # table "name", # column "task_name", # ENUM name task_names_old, # old options task_names_new, # new options ) upgrade_enum( "notifications", # table "topic", # column "notif_topic", # ENUM name notification_topics_old, # old options notification_topics_new, # new options ) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_old, # old options cluster_changes_new, # new options ) upgrade_enum( "neutron_config", # table "net_l23_provider", # column "net_l23_provider", # ENUM name neutron_l23_providers_old, # old options neutron_l23_providers_new, # new options ) op.drop_table("red_hat_accounts") drop_enum("license_type") op.add_column("nodes", sa.Column("replaced_deployment_info", JSON(), nullable=True)) op.add_column("nodes", sa.Column("replaced_provisioning_info", JSON(), nullable=True))
def downgrade(): ### commands auto generated by Alembic - please adjust! ### upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_new, # new options cluster_changes_old, # old options ) upgrade_enum( "notifications", # table "topic", # column "notif_topic", # ENUM name new_notification_topics, # new options old_notification_topics, # old options ) upgrade_enum( "tasks", # table "name", # column "task_name", # ENUM name task_names_new, # old options task_names_old # new options ) upgrade_enum( "clusters", # table "status", # column "cluster_status", # ENUM name cluster_statuses_new, # old options cluster_statuses_old # new options ) op.drop_constraint( 'fk_pending_release_id', 'clusters', type_='foreignkey' ) op.drop_column('clusters', 'pending_release_id') op.drop_column('releases', 'can_update_from_versions') op.create_table('red_hat_accounts', sa.Column('id', sa.Integer(), nullable=False), sa.Column('username', sa.String(length=100), nullable=False), sa.Column('password', sa.String(length=100), nullable=False), sa.Column('license_type', sa.Enum('rhsm', 'rhn', name='license_type'), nullable=False), sa.Column('satellite', sa.String(length=250), nullable=False), sa.Column('activation_key', sa.String(length=300), nullable=False), sa.PrimaryKeyConstraint('id') )
def upgrade_remove_vmware(): connection = op.get_bind() op.drop_constraint('vmware_attributes_cluster_id_fkey', 'vmware_attributes', type_='foreignkey') op.drop_table('vmware_attributes') op.drop_column('releases', 'vmware_attributes_metadata') delete = sa.sql.text("""DELETE FROM cluster_changes WHERE name = 'vmware_attributes'""") connection.execute(delete) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_old, # old options cluster_changes_new # new options )
def upgrade_remove_vmware(): connection = op.get_bind() op.drop_constraint( 'vmware_attributes_cluster_id_fkey', 'vmware_attributes', type_='foreignkey' ) op.drop_table('vmware_attributes') op.drop_column('releases', 'vmware_attributes_metadata') delete = sa.sql.text( """DELETE FROM cluster_changes WHERE name = 'vmware_attributes'""") connection.execute(delete) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_old, # old options cluster_changes_new # new options )
def downgrade_release_state(): connection = op.get_bind() connection.execute( sa.sql.text( "UPDATE releases SET state='available' WHERE state!='unavailable'") ) op.add_column( 'releases', sa.Column( 'is_deployable', sa.Boolean(), nullable=False, server_default='true', )) upgrade_enum( 'releases', 'state', 'release_state', release_states_new, release_states_old, )
def upgrade_schema(): op.add_column('clusters', sa.Column('deployment_tasks', fields.JSON(), nullable=True)) op.add_column('releases', sa.Column('deployment_tasks', fields.JSON(), nullable=True)) upgrade_enum( 'releases', # table 'state', # column 'release_state', # ENUM name release_states_old, # old options release_states_new, # new options ) # OpenStack workload statistics op.create_table( 'oswl_stats', sa.Column('id', sa.Integer, nullable=False), sa.Column('cluster_id', sa.Integer, nullable=False, index=True), sa.Column('created_date', sa.Date, nullable=False, index=True), sa.Column('updated_time', sa.Time, nullable=False), sa.Column('resource_type', sa.Enum('vm', 'tenant', 'volume', 'security_group', 'keystone_user', 'flavor', 'cluster_stats', name='oswl_resource_type'), nullable=False, index=True), sa.Column('resource_data', fields.JSON(), nullable=True), sa.Column('resource_checksum', sa.Text, nullable=True), sa.Column('is_sent', sa.Boolean, nullable=False, default=False, index=True), sa.PrimaryKeyConstraint('id'))
def task_statuses_downgrade(): upgrade_enum("tasks", "status", "task_status", task_statuses_new, task_statuses_old)
def task_names_downgrade(): upgrade_enum("tasks", "name", "task_name", task_names_new, task_names_old)
def downgrade_schema(): # Add interface properties op.drop_column('node_bond_interfaces', 'interface_properties') op.drop_column('node_nic_interfaces', 'interface_properties') # Add bond properties op.drop_column('node_bond_interfaces', 'bond_properties') op.add_column('node_bond_interfaces', sa.Column('flags', fields.JSON(), nullable=True)) # Introduce linux bonds upgrade_enum( 'node_bond_interfaces', # table 'mode', # column 'bond_mode', # ENUM name bond_modes_new, # new options bond_modes_old, # old options ) # OpenStack workload statistics op.drop_table('oswl_stats') drop_enum('oswl_resource_type') upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_new, # new options cluster_changes_old, # old options ) upgrade_enum( 'releases', # table 'state', # column 'release_state', # ENUM name release_states_new, # new options release_states_old, # old options ) upgrade_enum( "nodes", # table "status", # column "node_status", # ENUM name node_statuses_new, # old options node_statuses_old # new options ) op.create_table( 'release_orchestrator_data', sa.Column('id', sa.Integer(), nullable=False), sa.Column('release_id', sa.Integer(), nullable=False), sa.Column('repo_metadata', fields.JSON(), nullable=False), sa.Column('puppet_manifests_source', sa.Text(), nullable=False), sa.Column('puppet_modules_source', sa.Text(), nullable=False), sa.ForeignKeyConstraint( ['release_id'], ['releases.id'], ), sa.PrimaryKeyConstraint('id')) op.drop_table('vmware_attributes') op.drop_column('releases', 'vmware_attributes_metadata') op.drop_column('clusters', 'deployment_tasks') op.drop_column('node_nic_interfaces', 'driver') op.drop_column('node_nic_interfaces', 'bus_info') op.drop_column('releases', 'deployment_tasks') op.drop_constraint('node_roles_node_fkey', 'node_roles') op.create_foreign_key('node_roles_node_fkey', 'node_roles', 'nodes', ['node'], ['id']) op.drop_constraint('pending_node_roles_node_fkey', 'pending_node_roles') op.create_foreign_key('pending_node_roles_node_fkey', 'pending_node_roles', 'nodes', ['node'], ['id']) op.drop_constraint('node_attributes_node_id_fkey', 'node_attributes') op.create_foreign_key('node_attributes_node_id_fkey', 'node_attributes', 'nodes', ['node_id'], ['id']) op.drop_column('ip_addrs', 'vip_type') drop_enum('network_vip_types') # Plugins table changes op.drop_column('plugins', 'groups') op.drop_column('plugins', 'authors') op.drop_column('plugins', 'licenses') op.drop_column('plugins', 'homepage')
def upgrade_schema(): connection = op.get_bind() vrouter_enum = sa.Enum('haproxy', 'vrouter', name='network_vip_types') vrouter_enum.create(op.get_bind(), checkfirst=False) op.add_column('ip_addrs', sa.Column('vip_type', vrouter_enum, nullable=True)) op.add_column('clusters', sa.Column('deployment_tasks', fields.JSON(), nullable=True)) op.add_column('node_nic_interfaces', sa.Column('driver', sa.Text(), nullable=True)) op.add_column('node_nic_interfaces', sa.Column('bus_info', sa.Text(), nullable=True)) op.add_column('releases', sa.Column('deployment_tasks', fields.JSON(), nullable=True)) op.add_column( 'releases', sa.Column('vmware_attributes_metadata', fields.JSON(), nullable=True)) op.create_table('vmware_attributes', sa.Column('id', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer()), sa.Column('editable', fields.JSON()), sa.ForeignKeyConstraint( ['cluster_id'], ['clusters.id'], ), sa.PrimaryKeyConstraint('id')) upgrade_enum( 'releases', # table 'state', # column 'release_state', # ENUM name release_states_old, # old options release_states_new, # new options ) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_old, # old options cluster_changes_new # new options ) upgrade_enum( "nodes", # table "status", # column "node_status", # ENUM name node_statuses_old, # old options node_statuses_new # new options ) # OpenStack workload statistics op.create_table( 'oswl_stats', sa.Column('id', sa.Integer, nullable=False), sa.Column('cluster_id', sa.Integer, nullable=False, index=True), sa.Column('created_date', sa.Date, nullable=False, index=True), sa.Column('updated_time', sa.Time, nullable=False), sa.Column('resource_type', sa.Enum('vm', 'tenant', 'volume', 'security_group', 'keystone_user', 'flavor', 'cluster_stats', 'image', name='oswl_resource_type'), nullable=False, index=True), sa.Column('resource_data', fields.JSON(), nullable=True), sa.Column('resource_checksum', sa.Text, nullable=True), sa.Column('is_sent', sa.Boolean, nullable=False, default=False, index=True), sa.PrimaryKeyConstraint('id')) op.drop_constraint('node_roles_node_fkey', 'node_roles') op.create_foreign_key('node_roles_node_fkey', 'node_roles', 'nodes', ['node'], ['id'], ondelete='CASCADE') op.drop_constraint('pending_node_roles_node_fkey', 'pending_node_roles') op.create_foreign_key('pending_node_roles_node_fkey', 'pending_node_roles', 'nodes', ['node'], ['id'], ondelete='CASCADE') op.drop_constraint('node_attributes_node_id_fkey', 'node_attributes') op.create_foreign_key('node_attributes_node_id_fkey', 'node_attributes', 'nodes', ['node_id'], ['id'], ondelete='CASCADE') # Introduce linux bonds upgrade_enum( 'node_bond_interfaces', # table 'mode', # column 'bond_mode', # ENUM name bond_modes_old, # old options bond_modes_new, # new options ) # Add bond properties op.drop_column('node_bond_interfaces', 'flags') op.add_column( 'node_bond_interfaces', sa.Column('bond_properties', fields.JSON(), nullable=False, server_default='{}')) # Add interface properties op.add_column( 'node_nic_interfaces', sa.Column('interface_properties', fields.JSON(), nullable=False, server_default='{}')) op.add_column( 'node_bond_interfaces', sa.Column('interface_properties', fields.JSON(), nullable=False, server_default='{}')) move_orchestrator_data_to_attributes(connection) op.drop_table('release_orchestrator_data') # Plugins migrations op.add_column( 'plugins', sa.Column('groups', fields.JSON(), nullable=False, server_default='[]')) op.add_column( 'plugins', sa.Column('authors', fields.JSON(), nullable=False, server_default='[]')) op.add_column( 'plugins', sa.Column('licenses', fields.JSON(), nullable=False, server_default='[]')) op.add_column('plugins', sa.Column('homepage', sa.Text(), nullable=True))
def upgrade_schema(): connection = op.get_bind() vrouter_enum = sa.Enum("haproxy", "vrouter", name="network_vip_types") vrouter_enum.create(op.get_bind(), checkfirst=False) op.add_column("ip_addrs", sa.Column("vip_type", vrouter_enum, nullable=True)) op.add_column("clusters", sa.Column("deployment_tasks", fields.JSON(), nullable=True)) op.add_column("node_nic_interfaces", sa.Column("driver", sa.Text(), nullable=True)) op.add_column("node_nic_interfaces", sa.Column("bus_info", sa.Text(), nullable=True)) op.add_column("releases", sa.Column("deployment_tasks", fields.JSON(), nullable=True)) op.add_column("releases", sa.Column("vmware_attributes_metadata", fields.JSON(), nullable=True)) op.add_column("releases", sa.Column("modes", fields.JSON(), nullable=True)) op.create_table( "vmware_attributes", sa.Column("id", sa.Integer(), nullable=False), sa.Column("cluster_id", sa.Integer()), sa.Column("editable", fields.JSON()), sa.ForeignKeyConstraint(["cluster_id"], ["clusters.id"]), sa.PrimaryKeyConstraint("id"), ) upgrade_enum( "releases", # table "state", # column "release_state", # ENUM name release_states_old, # old options release_states_new, # new options ) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_old, # old options cluster_changes_new, # new options ) upgrade_enum( "nodes", # table "status", # column "node_status", # ENUM name node_statuses_old, # old options node_statuses_new, # new options ) # OpenStack workload statistics op.create_table( "oswl_stats", sa.Column("id", sa.Integer, nullable=False), sa.Column("cluster_id", sa.Integer, nullable=False, index=True), sa.Column("created_date", sa.Date, nullable=False, index=True), sa.Column("updated_time", sa.Time, nullable=False), sa.Column( "resource_type", sa.Enum( "vm", "tenant", "volume", "security_group", "keystone_user", "flavor", "cluster_stats", "image", name="oswl_resource_type", ), nullable=False, index=True, ), sa.Column("resource_data", fields.JSON(), nullable=True), sa.Column("resource_checksum", sa.Text, nullable=True), sa.Column("is_sent", sa.Boolean, nullable=False, default=False, index=True), sa.PrimaryKeyConstraint("id"), ) op.drop_constraint("node_roles_node_fkey", "node_roles") op.create_foreign_key("node_roles_node_fkey", "node_roles", "nodes", ["node"], ["id"], ondelete="CASCADE") op.drop_constraint("pending_node_roles_node_fkey", "pending_node_roles") op.create_foreign_key( "pending_node_roles_node_fkey", "pending_node_roles", "nodes", ["node"], ["id"], ondelete="CASCADE" ) op.drop_constraint("node_attributes_node_id_fkey", "node_attributes") op.create_foreign_key( "node_attributes_node_id_fkey", "node_attributes", "nodes", ["node_id"], ["id"], ondelete="CASCADE" ) # Introduce linux bonds upgrade_enum( "node_bond_interfaces", # table "mode", # column "bond_mode", # ENUM name bond_modes_old, # old options bond_modes_new, # new options ) # Add bond properties op.drop_column("node_bond_interfaces", "flags") op.add_column( "node_bond_interfaces", sa.Column("bond_properties", fields.JSON(), nullable=False, server_default="{}") ) # Add interface properties op.add_column( "node_nic_interfaces", sa.Column("interface_properties", fields.JSON(), nullable=False, server_default="{}") ) op.add_column( "node_bond_interfaces", sa.Column("interface_properties", fields.JSON(), nullable=False, server_default="{}") ) move_orchestrator_data_to_attributes(connection) op.drop_table("release_orchestrator_data") # Plugins migrations op.add_column("plugins", sa.Column("groups", fields.JSON(), nullable=False, server_default="[]")) op.add_column("plugins", sa.Column("authors", fields.JSON(), nullable=False, server_default="[]")) op.add_column("plugins", sa.Column("licenses", fields.JSON(), nullable=False, server_default="[]")) op.add_column("plugins", sa.Column("homepage", sa.Text(), nullable=True)) upgrade_enum( "tasks", # table "name", # column "task_name", # ENUM name task_names_old, # old options task_names_new, # new options )
def task_statuses_upgrade(): upgrade_enum('tasks', 'status', 'task_status', task_statuses_old, task_statuses_new)
def upgrade_schema(): op.add_column( 'releases', sa.Column( 'is_deployable', sa.Boolean(), nullable=False, server_default='true', ) ) op.add_column( 'node_nic_interfaces', sa.Column('driver', sa.Text(), nullable=True)) op.add_column( 'node_nic_interfaces', sa.Column('bus_info', sa.Text(), nullable=True)) op.drop_column('node_bond_interfaces', 'flags') op.add_column( 'node_bond_interfaces', sa.Column('bond_properties', fields.JSON(), nullable=False, server_default='{}')) # Add interface properties op.add_column( 'node_nic_interfaces', sa.Column('interface_properties', fields.JSON(), nullable=False, server_default='{}')) op.add_column( 'node_bond_interfaces', sa.Column('interface_properties', fields.JSON(), nullable=False, server_default='{}')) op.create_table('action_logs', sa.Column('id', sa.Integer, nullable=False), sa.Column( 'actor_id', sa.String(length=64), nullable=True ), sa.Column( 'action_group', sa.String(length=64), nullable=False ), sa.Column( 'action_name', sa.String(length=64), nullable=False ), sa.Column( 'action_type', sa.Enum('http_request', 'nailgun_task', name='action_type'), nullable=False ), sa.Column( 'start_timestamp', sa.DateTime, nullable=False ), sa.Column( 'end_timestamp', sa.DateTime, nullable=True ), sa.Column( 'is_sent', sa.Boolean, default=False ), sa.Column( 'additional_info', JSON(), nullable=False ), sa.Column( 'cluster_id', sa.Integer, nullable=True ), sa.Column( 'task_uuid', sa.String(36), nullable=True ), sa.PrimaryKeyConstraint('id')) op.create_table('master_node_settings', sa.Column('id', sa.Integer, nullable=False), sa.Column( 'master_node_uid', sa.String(36), nullable=False ), sa.Column( 'settings', JSON(), default={} ), sa.PrimaryKeyConstraint('id')) op.create_table( 'plugins', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=100), nullable=False), sa.Column('title', sa.String(length=100), nullable=False), sa.Column('version', sa.String(length=32), nullable=False), sa.Column('description', sa.String(length=400), nullable=True), sa.Column('releases', JSON(), nullable=True), sa.Column('fuel_version', JSON(), nullable=True), sa.Column('package_version', sa.String(length=32), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name', 'version', name='_name_version_unique') ) op.create_table( 'cluster_plugins', sa.Column('id', sa.Integer(), nullable=False), sa.Column('plugin_id', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['cluster_id'], ['clusters.id'], ), sa.ForeignKeyConstraint( ['plugin_id'], ['plugins.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id') ) op.create_table( 'nodegroups', sa.Column('id', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer(), nullable=True), sa.Column('name', sa.String(length=50), nullable=False), sa.ForeignKeyConstraint(['cluster_id'], ['clusters.id']), sa.PrimaryKeyConstraint('id') ) op.create_unique_constraint(None, 'clusters', ['name']) op.add_column( 'network_groups', sa.Column('group_id', sa.Integer(), nullable=True) ) op.add_column('nodes', sa.Column('group_id', sa.Integer(), nullable=True)) # We need this code here because the "upgrade_node_groups" function # relies on "cluster_id" column from "network_groups" table. connection = op.get_bind() upgrade_node_groups(connection) op.drop_column('network_groups', 'cluster_id') op.add_column( 'node_roles', sa.Column('primary', sa.Boolean(), nullable=False, server_default='false')) op.add_column( 'pending_node_roles', sa.Column('primary', sa.Boolean(), nullable=False, server_default='false')) upgrade_enum( 'node_bond_interfaces', # table 'mode', # column 'bond_mode', # ENUM name bond_modes_old, # old options bond_modes_new, # new options )
def downgrade_transaction_names(): upgrade_enum('tasks', 'name', 'task_name', transaction_names_new, transaction_names_old)
def upgrade_schema(): op.add_column( 'releases', sa.Column( 'is_deployable', sa.Boolean(), nullable=False, server_default='true', )) op.add_column('node_nic_interfaces', sa.Column('driver', sa.Text(), nullable=True)) op.add_column('node_nic_interfaces', sa.Column('bus_info', sa.Text(), nullable=True)) op.drop_column('node_bond_interfaces', 'flags') op.add_column( 'node_bond_interfaces', sa.Column('bond_properties', fields.JSON(), nullable=False, server_default='{}')) # Add interface properties op.add_column( 'node_nic_interfaces', sa.Column('interface_properties', fields.JSON(), nullable=False, server_default='{}')) op.add_column( 'node_bond_interfaces', sa.Column('interface_properties', fields.JSON(), nullable=False, server_default='{}')) op.create_table( 'action_logs', sa.Column('id', sa.Integer, nullable=False), sa.Column('actor_id', sa.String(length=64), nullable=True), sa.Column('action_group', sa.String(length=64), nullable=False), sa.Column('action_name', sa.String(length=64), nullable=False), sa.Column('action_type', sa.Enum('http_request', 'nailgun_task', name='action_type'), nullable=False), sa.Column('start_timestamp', sa.DateTime, nullable=False), sa.Column('end_timestamp', sa.DateTime, nullable=True), sa.Column('is_sent', sa.Boolean, default=False), sa.Column('additional_info', JSON(), nullable=False), sa.Column('cluster_id', sa.Integer, nullable=True), sa.Column('task_uuid', sa.String(36), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'master_node_settings', sa.Column('id', sa.Integer, nullable=False), sa.Column('master_node_uid', sa.String(36), nullable=False), sa.Column('settings', JSON(), default={}), sa.PrimaryKeyConstraint('id')) op.create_table( 'plugins', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=100), nullable=False), sa.Column('title', sa.String(length=100), nullable=False), sa.Column('version', sa.String(length=32), nullable=False), sa.Column('description', sa.String(length=400), nullable=True), sa.Column('releases', JSON(), nullable=True), sa.Column('fuel_version', JSON(), nullable=True), sa.Column('package_version', sa.String(length=32), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name', 'version', name='_name_version_unique')) op.create_table( 'cluster_plugins', sa.Column('id', sa.Integer(), nullable=False), sa.Column('plugin_id', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['cluster_id'], ['clusters.id'], ), sa.ForeignKeyConstraint(['plugin_id'], ['plugins.id'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id')) op.create_table('nodegroups', sa.Column('id', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer(), nullable=True), sa.Column('name', sa.String(length=50), nullable=False), sa.ForeignKeyConstraint(['cluster_id'], ['clusters.id']), sa.PrimaryKeyConstraint('id')) op.create_unique_constraint(None, 'clusters', ['name']) op.add_column('network_groups', sa.Column('group_id', sa.Integer(), nullable=True)) op.add_column('nodes', sa.Column('group_id', sa.Integer(), nullable=True)) # We need this code here because the "upgrade_node_groups" function # relies on "cluster_id" column from "network_groups" table. connection = op.get_bind() upgrade_node_groups(connection) op.drop_column('network_groups', 'cluster_id') op.add_column( 'node_roles', sa.Column('primary', sa.Boolean(), nullable=False, server_default='false')) op.add_column( 'pending_node_roles', sa.Column('primary', sa.Boolean(), nullable=False, server_default='false')) upgrade_enum( 'node_bond_interfaces', # table 'mode', # column 'bond_mode', # ENUM name bond_modes_old, # old options bond_modes_new, # new options )
def task_statuses_downgrade(): upgrade_enum('tasks', 'status', 'task_status', task_statuses_new, task_statuses_old)
def downgrade_schema(): # Add interface properties op.drop_column('node_bond_interfaces', 'interface_properties') op.drop_column('node_nic_interfaces', 'interface_properties') # Add bond properties op.drop_column('node_bond_interfaces', 'bond_properties') op.add_column( 'node_bond_interfaces', sa.Column('flags', fields.JSON(), nullable=True)) # Introduce linux bonds upgrade_enum( 'node_bond_interfaces', # table 'mode', # column 'bond_mode', # ENUM name bond_modes_new, # new options bond_modes_old, # old options ) # OpenStack workload statistics op.drop_table('oswl_stats') drop_enum('oswl_resource_type') upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_new, # new options cluster_changes_old, # old options ) upgrade_enum( 'releases', # table 'state', # column 'release_state', # ENUM name release_states_new, # new options release_states_old, # old options ) upgrade_enum( "nodes", # table "status", # column "node_status", # ENUM name node_statuses_new, # old options node_statuses_old # new options ) op.create_table( 'release_orchestrator_data', sa.Column('id', sa.Integer(), nullable=False), sa.Column('release_id', sa.Integer(), nullable=False), sa.Column('repo_metadata', fields.JSON(), nullable=False), sa.Column( 'puppet_manifests_source', sa.Text(), nullable=False), sa.Column( 'puppet_modules_source', sa.Text(), nullable=False), sa.ForeignKeyConstraint(['release_id'], ['releases.id'], ), sa.PrimaryKeyConstraint('id')) op.drop_table('vmware_attributes') op.drop_column('releases', 'vmware_attributes_metadata') op.drop_column('clusters', 'deployment_tasks') op.drop_column('node_nic_interfaces', 'driver') op.drop_column('node_nic_interfaces', 'bus_info') op.drop_column('releases', 'deployment_tasks') op.drop_constraint('node_roles_node_fkey', 'node_roles') op.create_foreign_key( 'node_roles_node_fkey', 'node_roles', 'nodes', ['node'], ['id']) op.drop_constraint('pending_node_roles_node_fkey', 'pending_node_roles') op.create_foreign_key( 'pending_node_roles_node_fkey', 'pending_node_roles', 'nodes', ['node'], ['id']) op.drop_constraint('node_attributes_node_id_fkey', 'node_attributes') op.create_foreign_key( 'node_attributes_node_id_fkey', 'node_attributes', 'nodes', ['node_id'], ['id']) op.drop_column('ip_addrs', 'vip_type') drop_enum('network_vip_types') # Plugins table changes op.drop_column('plugins', 'groups') op.drop_column('plugins', 'authors') op.drop_column('plugins', 'licenses') op.drop_column('plugins', 'homepage')
def upgrade_schema(): connection = op.get_bind() vrouter_enum = sa.Enum('haproxy', 'vrouter', name='network_vip_types') vrouter_enum.create(op.get_bind(), checkfirst=False) op.add_column( 'ip_addrs', sa.Column('vip_type', vrouter_enum, nullable=True) ) op.add_column( 'clusters', sa.Column('deployment_tasks', fields.JSON(), nullable=True)) op.add_column( 'node_nic_interfaces', sa.Column('driver', sa.Text(), nullable=True)) op.add_column( 'node_nic_interfaces', sa.Column('bus_info', sa.Text(), nullable=True)) op.add_column( 'releases', sa.Column('deployment_tasks', fields.JSON(), nullable=True)) op.add_column( 'releases', sa.Column('vmware_attributes_metadata', fields.JSON(), nullable=True)) op.create_table( 'vmware_attributes', sa.Column('id', sa.Integer(), nullable=False), sa.Column('cluster_id', sa.Integer()), sa.Column('editable', fields.JSON()), sa.ForeignKeyConstraint(['cluster_id'], ['clusters.id'], ), sa.PrimaryKeyConstraint('id')) upgrade_enum( 'releases', # table 'state', # column 'release_state', # ENUM name release_states_old, # old options release_states_new, # new options ) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_old, # old options cluster_changes_new # new options ) upgrade_enum( "nodes", # table "status", # column "node_status", # ENUM name node_statuses_old, # old options node_statuses_new # new options ) # OpenStack workload statistics op.create_table('oswl_stats', sa.Column('id', sa.Integer, nullable=False), sa.Column( 'cluster_id', sa.Integer, nullable=False, index=True ), sa.Column( 'created_date', sa.Date, nullable=False, index=True ), sa.Column( 'updated_time', sa.Time, nullable=False ), sa.Column( 'resource_type', sa.Enum('vm', 'tenant', 'volume', 'security_group', 'keystone_user', 'flavor', 'cluster_stats', 'image', name='oswl_resource_type'), nullable=False, index=True ), sa.Column( 'resource_data', fields.JSON(), nullable=True ), sa.Column( 'resource_checksum', sa.Text, nullable=True ), sa.Column( 'is_sent', sa.Boolean, nullable=False, default=False, index=True ), sa.PrimaryKeyConstraint('id')) op.drop_constraint('node_roles_node_fkey', 'node_roles') op.create_foreign_key( 'node_roles_node_fkey', 'node_roles', 'nodes', ['node'], ['id'], ondelete='CASCADE') op.drop_constraint('pending_node_roles_node_fkey', 'pending_node_roles') op.create_foreign_key( 'pending_node_roles_node_fkey', 'pending_node_roles', 'nodes', ['node'], ['id'], ondelete='CASCADE') op.drop_constraint('node_attributes_node_id_fkey', 'node_attributes') op.create_foreign_key( 'node_attributes_node_id_fkey', 'node_attributes', 'nodes', ['node_id'], ['id'], ondelete='CASCADE') # Introduce linux bonds upgrade_enum( 'node_bond_interfaces', # table 'mode', # column 'bond_mode', # ENUM name bond_modes_old, # old options bond_modes_new, # new options ) # Add bond properties op.drop_column('node_bond_interfaces', 'flags') op.add_column( 'node_bond_interfaces', sa.Column('bond_properties', fields.JSON(), nullable=False, server_default='{}')) # Add interface properties op.add_column( 'node_nic_interfaces', sa.Column('interface_properties', fields.JSON(), nullable=False, server_default='{}')) op.add_column( 'node_bond_interfaces', sa.Column('interface_properties', fields.JSON(), nullable=False, server_default='{}')) move_orchestrator_data_to_attributes(connection) op.drop_table('release_orchestrator_data') # Plugins migrations op.add_column( 'plugins', sa.Column( 'groups', fields.JSON(), nullable=False, server_default='[]')) op.add_column( 'plugins', sa.Column( 'authors', fields.JSON(), nullable=False, server_default='[]')) op.add_column( 'plugins', sa.Column( 'licenses', fields.JSON(), nullable=False, server_default='[]')) op.add_column( 'plugins', sa.Column('homepage', sa.Text(), nullable=True))
def task_names_upgrade(): upgrade_enum("tasks", "name", "task_name", task_names_old, task_names_new)
def downgrade_orchestrator_task_types(): upgrade_enum('deployment_graph_tasks', 'type', 'deployment_graph_tasks_type', orchestrator_task_types_new, orchestrator_task_types_old)
def upgrade_schema(): # commands auto generated by Alembic - please adjust! ### op.add_column( 'releases', sa.Column('can_update_from_versions', JSON(), nullable=False, server_default='[]')) op.add_column('releases', sa.Column('wizard_metadata', JSON(), nullable=True)) op.add_column('clusters', sa.Column('pending_release_id', sa.Integer(), nullable=True)) op.create_foreign_key( 'fk_pending_release_id', 'clusters', 'releases', ['pending_release_id'], ['id'], ) upgrade_enum( "clusters", # table "status", # column "cluster_status", # ENUM name cluster_statuses_old, # old options cluster_statuses_new # new options ) upgrade_enum( "tasks", # table "name", # column "task_name", # ENUM name task_names_old, # old options task_names_new # new options ) upgrade_enum( "notifications", # table "topic", # column "notif_topic", # ENUM name notification_topics_old, # old options notification_topics_new, # new options ) upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_old, # old options cluster_changes_new # new options ) upgrade_enum( "neutron_config", # table "net_l23_provider", # column "net_l23_provider", # ENUM name neutron_l23_providers_old, # old options neutron_l23_providers_new # new options ) op.drop_table('red_hat_accounts') drop_enum('license_type') op.add_column('nodes', sa.Column('replaced_deployment_info', JSON(), nullable=True)) op.add_column( 'nodes', sa.Column('replaced_provisioning_info', JSON(), nullable=True))
def add_node_discover_error_downgrade(): upgrade_enum("nodes", "error_type", "node_error_type", node_errors_new, node_errors_old)
def downgrade_transaction_names(): migration.upgrade_enum('tasks', 'name', 'task_name', TASK_NAMES_NEW, TASK_NAMES_OLD)
def downgrade_schema(): upgrade_enum( "tasks", # table "name", # column "task_name", # ENUM name task_names_new, # old options task_names_old, # new options ) # Add interface properties op.drop_column("node_bond_interfaces", "interface_properties") op.drop_column("node_nic_interfaces", "interface_properties") # Add bond properties op.drop_column("node_bond_interfaces", "bond_properties") op.add_column("node_bond_interfaces", sa.Column("flags", fields.JSON(), nullable=True)) # Introduce linux bonds upgrade_enum( "node_bond_interfaces", # table "mode", # column "bond_mode", # ENUM name bond_modes_new, # new options bond_modes_old, # old options ) # OpenStack workload statistics op.drop_table("oswl_stats") drop_enum("oswl_resource_type") upgrade_enum( "cluster_changes", # table "name", # column "possible_changes", # ENUM name cluster_changes_new, # new options cluster_changes_old, # old options ) upgrade_enum( "releases", # table "state", # column "release_state", # ENUM name release_states_new, # new options release_states_old, # old options ) upgrade_enum( "nodes", # table "status", # column "node_status", # ENUM name node_statuses_new, # old options node_statuses_old, # new options ) op.create_table( "release_orchestrator_data", sa.Column("id", sa.Integer(), nullable=False), sa.Column("release_id", sa.Integer(), nullable=False), sa.Column("repo_metadata", fields.JSON(), nullable=False), sa.Column("puppet_manifests_source", sa.Text(), nullable=False), sa.Column("puppet_modules_source", sa.Text(), nullable=False), sa.ForeignKeyConstraint(["release_id"], ["releases.id"]), sa.PrimaryKeyConstraint("id"), ) op.drop_table("vmware_attributes") op.drop_column("releases", "vmware_attributes_metadata") op.drop_column("clusters", "deployment_tasks") op.drop_column("node_nic_interfaces", "driver") op.drop_column("node_nic_interfaces", "bus_info") op.drop_column("releases", "deployment_tasks") op.drop_column("releases", "modes") op.drop_constraint("node_roles_node_fkey", "node_roles") op.create_foreign_key("node_roles_node_fkey", "node_roles", "nodes", ["node"], ["id"]) op.drop_constraint("pending_node_roles_node_fkey", "pending_node_roles") op.create_foreign_key("pending_node_roles_node_fkey", "pending_node_roles", "nodes", ["node"], ["id"]) op.drop_constraint("node_attributes_node_id_fkey", "node_attributes") op.create_foreign_key("node_attributes_node_id_fkey", "node_attributes", "nodes", ["node_id"], ["id"]) op.drop_column("ip_addrs", "vip_type") drop_enum("network_vip_types") # Plugins table changes op.drop_column("plugins", "groups") op.drop_column("plugins", "authors") op.drop_column("plugins", "licenses") op.drop_column("plugins", "homepage")