def downgrade():
op.drop_table('net_nic_assignments')
op.drop_table('net_bond_assignments')
op.drop_table('node_nic_interfaces')
op.drop_table('pending_node_roles')
op.drop_table('neutron_config')
op.drop_table('ip_addr_ranges')
op.drop_table('ip_addrs')
op.drop_table('node_bond_interfaces')
op.drop_table('notifications')
op.drop_table('node_attributes')
op.drop_table('cluster_changes')
op.drop_table('node_roles')
op.drop_table('nova_network_config')
op.drop_table('attributes')
op.drop_table('network_groups')
op.drop_table('networking_configs')
op.drop_table('tasks')
op.drop_table('nodes')
op.drop_table('roles')
op.drop_table('release_orchestrator_data')
op.drop_table('clusters')
op.drop_table('releases')
op.drop_table('capacity_log')
op.drop_table('red_hat_accounts')
for enum in ENUMS:
drop_enum(enum)
def downgrade_deployment_graph():
op.add_column(
'clusters',
sa.Column(
'deployment_tasks',
fields.JSON(),
nullable=False,
server_default='[]'
)
)
op.add_column(
'plugins',
sa.Column(
'deployment_tasks',
fields.JSON(),
nullable=False,
server_default='[]'
)
)
op.add_column(
'releases',
sa.Column(
'deployment_tasks',
fields.JSON(),
nullable=False,
server_default='[]'
)
)
op.drop_table('cluster_deployment_graphs')
op.drop_table('plugin_deployment_graphs')
op.drop_table('release_deployment_graphs')
op.drop_table('deployment_graph_tasks')
drop_enum('deployment_graph_tasks_type')
op.drop_table('deployment_graphs')
def downgrade():
op.drop_table('net_nic_assignments')
op.drop_table('net_bond_assignments')
op.drop_table('node_nic_interfaces')
op.drop_table('pending_node_roles')
op.drop_table('neutron_config')
op.drop_table('ip_addr_ranges')
op.drop_table('ip_addrs')
op.drop_table('node_bond_interfaces')
op.drop_table('notifications')
op.drop_table('node_attributes')
op.drop_table('cluster_changes')
op.drop_table('node_roles')
op.drop_table('nova_network_config')
op.drop_table('attributes')
op.drop_table('network_groups')
op.drop_table('networking_configs')
op.drop_table('tasks')
op.drop_table('nodes')
op.drop_table('roles')
op.drop_table('release_orchestrator_data')
op.drop_table('clusters')
op.drop_table('releases')
op.drop_table('capacity_log')
op.drop_table('red_hat_accounts')
for enum in ENUMS:
drop_enum(enum)
def downgrade():
task_statuses_downgrade()
downgrade_release_state()
op.drop_constraint('_name_cluster_uc', 'nodegroups',)
op.drop_table('release_components')
op.drop_table('components')
drop_enum('component_types')
def extend_ip_addrs_model_upgrade():
op.alter_column('ip_addrs',
'vip_type',
type_=sa.String(length=50),
existing_type=sa.Enum('haproxy',
'vrouter',
name='network_vip_types'))
drop_enum('network_vip_types')
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 network_groups_name_upgrade():
op.alter_column('network_groups',
'name',
type_=sa.String(length=50),
existing_type=sa.Enum(
'fuelweb_admin', 'storage',
'management', 'public',
'fixed', 'private',
name='network_group_name'))
drop_enum('network_group_name')
def downgrade():
downgrade_neutron_parameters()
add_node_discover_error_downgrade()
task_names_downgrade()
task_statuses_downgrade()
downgrade_release_state()
op.drop_constraint('_name_cluster_uc', 'nodegroups',)
op.drop_table('release_components')
op.drop_table('components')
drop_enum('component_types')
def network_groups_name_upgrade():
op.alter_column('network_groups',
'name',
type_=sa.String(length=50),
existing_type=sa.Enum('fuelweb_admin',
'storage',
'management',
'public',
'fixed',
'private',
name='network_group_name'))
drop_enum('network_group_name')
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 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_schema():
op.drop_column('releases', 'is_deployable')
op.drop_table('action_logs')
op.drop_table('master_node_settings')
for enum in ENUMS:
drop_enum(enum)
op.drop_table('cluster_plugins')
op.drop_table('plugins')
op.drop_column(u'nodes', 'group_id')
op.drop_column(u'network_groups', 'group_id')
op.add_column(
'network_groups',
sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('clusters.id')))
op.drop_column(u'releases', 'wizard_metadata')
op.drop_table('nodegroups')
op.drop_column('pending_node_roles', 'primary')
op.drop_column('node_roles', 'primary')
def downgrade_schema():
op.drop_column('releases', 'is_deployable')
op.drop_table('action_logs')
op.drop_table('master_node_settings')
for enum in ENUMS:
drop_enum(enum)
op.drop_table('cluster_plugins')
op.drop_table('plugins')
op.drop_column(u'nodes', 'group_id')
op.drop_column(u'network_groups', 'group_id')
op.add_column(
'network_groups',
sa.Column('cluster_id', sa.Integer(), sa.ForeignKey('clusters.id'))
)
op.drop_column(u'releases', 'wizard_metadata')
op.drop_table('nodegroups')
op.drop_column('pending_node_roles', 'primary')
op.drop_column('node_roles', 'primary')
def downgrade_node_tagging():
op.drop_table('node_tags')
op.drop_table('tags')
drop_enum('tag_owner_type')
op.drop_column('releases', 'tags_metadata')
def downgrade_node_tagging():
op.drop_table('node_tags')
op.drop_table('tags')
drop_enum('tag_owner_type')
op.drop_column('releases', 'tags_metadata')
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 downgrade_store_deployment_history():
op.drop_table('deployment_history')
drop_enum('history_task_statuses')
def downgrade_openstack_configs():
op.drop_table('openstack_configs')
drop_enum('openstack_config_types')
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_node_error_type():
op.alter_column('nodes', 'error_type', type_=sa.String(100))
drop_enum('node_error_type')
def extend_ip_addrs_model_upgrade():
op.alter_column('ip_addrs', 'vip_type',
type_=sa.String(length=50),
existing_type=sa.Enum('haproxy', 'vrouter',
name='network_vip_types'))
drop_enum('network_vip_types')
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_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")
def upgrade_node_error_type():
op.alter_column('nodes', 'error_type', type_=sa.String(100))
drop_enum('node_error_type')
def downgrade_openstack_configs():
op.drop_table('openstack_configs')
drop_enum('openstack_config_types')
