keystone.common.sql.migrate_repo.versions package

Submodules

keystone.common.sql.migrate_repo.versions.001_add_initial_tables module

keystone.common.sql.migrate_repo.versions.001_add_initial_tables.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.001_add_initial_tables.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.002_token_id_hash module

keystone.common.sql.migrate_repo.versions.002_token_id_hash.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.002_token_id_hash.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.003_token_valid module

keystone.common.sql.migrate_repo.versions.003_token_valid.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.003_token_valid.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.004_undo_token_id_hash module

keystone.common.sql.migrate_repo.versions.004_undo_token_id_hash.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.004_undo_token_id_hash.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.005_set_utf8_character_set module

keystone.common.sql.migrate_repo.versions.005_set_utf8_character_set.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.005_set_utf8_character_set.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.006_add_policy_table module

keystone.common.sql.migrate_repo.versions.006_add_policy_table.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.006_add_policy_table.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.007_add_domain_tables module

keystone.common.sql.migrate_repo.versions.007_add_domain_tables.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.007_add_domain_tables.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.008_create_default_domain module

keystone.common.sql.migrate_repo.versions.008_create_default_domain.downgrade(migrate_engine)[source]

Delete the default domain.

keystone.common.sql.migrate_repo.versions.008_create_default_domain.upgrade(migrate_engine)[source]

Creates the default domain.

keystone.common.sql.migrate_repo.versions.009_normalize_identity module

keystone.common.sql.migrate_repo.versions.009_normalize_identity.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.009_normalize_identity.downgrade_tenant_table_with_column_drop(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.009_normalize_identity.downgrade_tenant_table_with_copy(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.009_normalize_identity.downgrade_user_table_with_column_drop(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.009_normalize_identity.downgrade_user_table_with_copy(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.009_normalize_identity.upgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.009_normalize_identity.upgrade_tenant_table(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.009_normalize_identity.upgrade_user_table(meta, migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.010_normalize_identity_migration module

keystone.common.sql.migrate_repo.versions.010_normalize_identity_migration.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.010_normalize_identity_migration.downgrade_tenant_table(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.010_normalize_identity_migration.downgrade_user_table(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.010_normalize_identity_migration.is_enabled(enabled)[source]
keystone.common.sql.migrate_repo.versions.010_normalize_identity_migration.upgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.010_normalize_identity_migration.upgrade_tenant_table(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.010_normalize_identity_migration.upgrade_user_table(meta, migrate_engine, session)[source]

keystone.common.sql.migrate_repo.versions.011_endpoints_v3 module

keystone.common.sql.migrate_repo.versions.011_endpoints_v3.downgrade(migrate_engine)[source]

Replace API-version specific endpoint tables with one based on v2.

keystone.common.sql.migrate_repo.versions.011_endpoints_v3.upgrade(migrate_engine)[source]

Create API-version specific endpoint tables.

keystone.common.sql.migrate_repo.versions.012_populate_endpoint_type module

keystone.common.sql.migrate_repo.versions.012_populate_endpoint_type.downgrade(migrate_engine)[source]

Re-create the v2 endpoints table based on v3 endpoints.

keystone.common.sql.migrate_repo.versions.012_populate_endpoint_type.upgrade(migrate_engine)[source]

Split each legacy endpoint into separate records for each interface.

keystone.common.sql.migrate_repo.versions.013_drop_legacy_endpoints module

keystone.common.sql.migrate_repo.versions.013_drop_legacy_endpoints.downgrade(migrate_engine)[source]

Create API-version specific endpoint tables.

keystone.common.sql.migrate_repo.versions.013_drop_legacy_endpoints.upgrade(migrate_engine)[source]

Replace API-version specific endpoint tables with one based on v3.

keystone.common.sql.migrate_repo.versions.014_add_group_tables module

keystone.common.sql.migrate_repo.versions.014_add_group_tables.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.014_add_group_tables.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.015_tenant_to_project module

keystone.common.sql.migrate_repo.versions.015_tenant_to_project.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.015_tenant_to_project.downgrade_with_copy(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.015_tenant_to_project.downgrade_with_rename(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.015_tenant_to_project.rename_with_constraints(meta, legacy_project_table_name, new_project_table_name, legacy_user_project_membership_table_name, new_user_project_membership_table_name)[source]
keystone.common.sql.migrate_repo.versions.015_tenant_to_project.upgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.015_tenant_to_project.upgrade_with_copy(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.015_tenant_to_project.upgrade_with_rename(meta, migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids module

Normalize for domain_id, i.e. ensure User and Project entities have the domain_id as a first class attribute.

Both User and Project (as well as Group) entities are owned by a domain, which is implemented as each having a domain_id foreign key in their sql representation that points back to the respective domain in the domain table. This domain_id attribute should also be required (i.e. not nullable)

Adding a non_nullable foreign key attribute to a table with existing data causes a few problems since not all DB engines support the ability to either control the triggering of integrity constraints or the ability to modify columns after they are created.

To get round the above inconsistencies, two versions of the upgrade/downgrade functions are supplied, one for those engines that support dropping columns, and one for those that don’t. For the latter we are forced to do table copy AND control the triggering of integrity constraints.

keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.downgrade_project_table_with_col_drop(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.downgrade_project_table_with_copy(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.downgrade_user_table_with_col_drop(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.downgrade_user_table_with_copy(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.upgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.upgrade_project_table_with_col_create(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.upgrade_project_table_with_copy(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.upgrade_user_table_with_col_create(meta, migrate_engine, session)[source]
keystone.common.sql.migrate_repo.versions.016_normalize_domain_ids.upgrade_user_table_with_copy(meta, migrate_engine, session)[source]

keystone.common.sql.migrate_repo.versions.017_membership_role module

keystone.common.sql.migrate_repo.versions.017_membership_role.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.017_membership_role.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.018_add_trust_tables module

keystone.common.sql.migrate_repo.versions.018_add_trust_tables.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.018_add_trust_tables.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.019_fixup_role module

keystone.common.sql.migrate_repo.versions.019_fixup_role.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.019_fixup_role.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.020_migrate_metadata_table_roles module

keystone.common.sql.migrate_repo.versions.020_migrate_metadata_table_roles.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.020_migrate_metadata_table_roles.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.021_add_trust_to_token module

keystone.common.sql.migrate_repo.versions.021_add_trust_to_token.create_column_forgiving(migrate_engine, table, column)[source]
keystone.common.sql.migrate_repo.versions.021_add_trust_to_token.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.021_add_trust_to_token.downgrade_token_table_with_column_drop(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.021_add_trust_to_token.upgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.021_add_trust_to_token.upgrade_token_table(meta, migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.022_move_legacy_endpoint_id module

keystone.common.sql.migrate_repo.versions.022_move_legacy_endpoint_id.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.022_move_legacy_endpoint_id.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.023_drop_credential_constraints module

keystone.common.sql.migrate_repo.versions.023_drop_credential_constraints.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.023_drop_credential_constraints.list_constraints(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.023_drop_credential_constraints.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.024_add_index_to_expires module

keystone.common.sql.migrate_repo.versions.024_add_index_to_expires.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.024_add_index_to_expires.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.025_add_index_to_valid module

keystone.common.sql.migrate_repo.versions.025_add_index_to_valid.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.025_add_index_to_valid.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.026_drop_user_group_constraints module

keystone.common.sql.migrate_repo.versions.026_drop_user_group_constraints.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.026_drop_user_group_constraints.list_constraints(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.026_drop_user_group_constraints.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.027_set_engine_mysql_innodb module

keystone.common.sql.migrate_repo.versions.027_set_engine_mysql_innodb.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.027_set_engine_mysql_innodb.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.028_fixup_group_metadata module

keystone.common.sql.migrate_repo.versions.028_fixup_group_metadata.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.028_fixup_group_metadata.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.029_update_assignment_metadata module

keystone.common.sql.migrate_repo.versions.029_update_assignment_metadata.build_update(table_name, upgrade_table, row, values)[source]
keystone.common.sql.migrate_repo.versions.029_update_assignment_metadata.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.029_update_assignment_metadata.downgrade_grant_table(meta, migrate_engine, session, table_name)[source]
keystone.common.sql.migrate_repo.versions.029_update_assignment_metadata.upgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.029_update_assignment_metadata.upgrade_grant_table(meta, migrate_engine, session, table_name)[source]

keystone.common.sql.migrate_repo.versions.030_drop_credential_constraint_sqlite module

keystone.common.sql.migrate_repo.versions.030_drop_credential_constraint_sqlite.add_credential_table_foreign_key_constraints_for_sqlite(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.030_drop_credential_constraint_sqlite.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.030_drop_credential_constraint_sqlite.drop_credential_table_foreign_key_constraints_for_sqlite(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.030_drop_credential_constraint_sqlite.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.031_drop_credential_indexes module

keystone.common.sql.migrate_repo.versions.031_drop_credential_indexes.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.031_drop_credential_indexes.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.032_username_length module

keystone.common.sql.migrate_repo.versions.032_username_length.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.032_username_length.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.033_migrate_ec2credentials_table_credentials module

keystone.common.sql.migrate_repo.versions.033_migrate_ec2credentials_table_credentials.check_credential_exists(ec2credential, credential_table, session)[source]
keystone.common.sql.migrate_repo.versions.033_migrate_ec2credentials_table_credentials.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.033_migrate_ec2credentials_table_credentials.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.034_add_default_project_id_column_to_user module

keystone.common.sql.migrate_repo.versions.034_add_default_project_id_column_to_user.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.034_add_default_project_id_column_to_user.migrate_default_project_from_extra_json(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.034_add_default_project_id_column_to_user.migrate_default_project_to_extra_json(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.034_add_default_project_id_column_to_user.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.035_add_compound_revoked_token_index module

keystone.common.sql.migrate_repo.versions.035_add_compound_revoked_token_index.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.035_add_compound_revoked_token_index.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.036_token_drop_valid_index module

keystone.common.sql.migrate_repo.versions.036_token_drop_valid_index.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.036_token_drop_valid_index.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.037_add_region_table module

keystone.common.sql.migrate_repo.versions.037_add_region_table.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.037_add_region_table.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.038_add_assignment_table module

keystone.common.sql.migrate_repo.versions.038_add_assignment_table.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.038_add_assignment_table.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.039_grant_to_assignment module

keystone.common.sql.migrate_repo.versions.039_grant_to_assignment.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.039_grant_to_assignment.downgrade_assignment_table(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.039_grant_to_assignment.migrate_grant_table(meta, migrate_engine, session, table_name)[source]
keystone.common.sql.migrate_repo.versions.039_grant_to_assignment.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.040_drop_grant_tables module

keystone.common.sql.migrate_repo.versions.040_drop_grant_tables.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.040_drop_grant_tables.recreate_grant_tables(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.040_drop_grant_tables.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.041_add_remaining_uses_count_to_trusts module

keystone.common.sql.migrate_repo.versions.041_add_remaining_uses_count_to_trusts.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.041_add_remaining_uses_count_to_trusts.downgrade_trust_table_with_column_drop(meta, migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.041_add_remaining_uses_count_to_trusts.upgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.041_add_remaining_uses_count_to_trusts.upgrade_trust_table(meta, migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.042_endpoint_enabled module

Adds an enabled column to the endpoint table.

The enabled value for the endpoint table was stored in the extra column as part of a JSON string.

To upgrade, the enabled column is added with a default value of true, then we check all the extra JSON for disabled and set the value to false for those.

Downgrade is essentially the opposite – we update the JSON with "enabled": false for any endpoints that are disabled and drop the enabled column.

keystone.common.sql.migrate_repo.versions.042_endpoint_enabled.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.042_endpoint_enabled.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.043_fixup_region_description module

Relax the uniqueness of description column in region table.

The region table has a dedicated column for the region description. This column originally was not nullable and had to be unique. So if a user wanted to create a region without sending a description in the request, they would experience an SQL error because the description column can’t be null for a region. This means that every region had to have a unique description.

To upgrade, we are going to transfer all the data from the existing region table to a temporary table, drop the original region table, and then finally rename the temporary table to the correct name.

There is no downgrade path as the original migration has been fixed to not include the unique constraint on description column.

keystone.common.sql.migrate_repo.versions.043_fixup_region_description.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.043_fixup_region_description.upgrade(migrate_engine)[source]

keystone.common.sql.migrate_repo.versions.044_service_enabled module

Adds an enabled column to the service table.

The enabled value for the service table was stored in the extra column as part of a JSON string.

To upgrade, the enabled column is added with a default value of true, then we check all the extra JSON for disabled and set the value to false for those.

Downgrade is essentially the opposite – we update the JSON with "enabled": false for any services that are disabled and drop the enabled column.

keystone.common.sql.migrate_repo.versions.044_service_enabled.downgrade(migrate_engine)[source]
keystone.common.sql.migrate_repo.versions.044_service_enabled.upgrade(migrate_engine)[source]

Module contents

Table Of Contents

Previous topic

keystone.common.sql.migrate_repo package

Next topic

keystone.contrib package

This Page