diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2024-01-10 23:04:38 +0300 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2024-01-10 23:04:38 +0300 |
commit | 2965e48337030c75e342b72d3420b7ff69e11f08 (patch) | |
tree | fe43088fcf0c6bb1f0aff8ff4465c22dfa71e8ce /spec/migrations/db | |
parent | 13d4026d4e234cc26b7dd68508d2e3afe86338e6 (diff) |
Add latest changes from gitlab-org/security/gitlab@16-7-stable-ee
Diffstat (limited to 'spec/migrations/db')
-rw-r--r-- | spec/migrations/db/post_migrate/20231004091113_swap_columns_for_ci_sources_pipelines_pipeline_id_bigint_spec.rb | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/spec/migrations/db/post_migrate/20231004091113_swap_columns_for_ci_sources_pipelines_pipeline_id_bigint_spec.rb b/spec/migrations/db/post_migrate/20231004091113_swap_columns_for_ci_sources_pipelines_pipeline_id_bigint_spec.rb new file mode 100644 index 00000000000..3d1a4176833 --- /dev/null +++ b/spec/migrations/db/post_migrate/20231004091113_swap_columns_for_ci_sources_pipelines_pipeline_id_bigint_spec.rb @@ -0,0 +1,38 @@ +# frozen_string_literal: true + +require 'spec_helper' +require_migration! + +RSpec.describe SwapColumnsForCiSourcesPipelinesPipelineIdBigint, feature_category: :continuous_integration do + let(:connection) { active_record_base.connection } + + before do + connection.execute('ALTER TABLE ci_sources_pipelines ALTER COLUMN pipeline_id TYPE integer') + connection.execute('ALTER TABLE ci_sources_pipelines ALTER COLUMN pipeline_id_convert_to_bigint TYPE bigint') + end + + it_behaves_like( + 'swap conversion columns', + table_name: :ci_sources_pipelines, + from: :pipeline_id, + to: :pipeline_id_convert_to_bigint + ) + + context 'when indexes are missing' do + before do + connection.remove_index( + :ci_sources_pipelines, name: :index_ci_sources_pipelines_on_pipeline_id, if_exists: true + ) + connection.remove_index( + :ci_sources_pipelines, name: :index_ci_sources_pipelines_on_source_pipeline_id, if_exists: true + ) + end + + it_behaves_like( + 'swap conversion columns', + table_name: :ci_sources_pipelines, + from: :pipeline_id, + to: :pipeline_id_convert_to_bigint + ) + end +end |