diff options
author | Shinya Maeda <shinya@gitlab.com> | 2019-01-10 11:47:40 +0300 |
---|---|---|
committer | Shinya Maeda <shinya@gitlab.com> | 2019-01-17 08:01:50 +0300 |
commit | ee79ee9473bad06adf1df3ec779b3d39b5e8a42f (patch) | |
tree | 33f97763d2be5c345a4acd36a646cff4980c8a3a /db/migrate/20190104182041_cleanup_legacy_artifact_migration.rb | |
parent | 7b4ca0c903a2094c929c640754b8b9e03108b98e (diff) |
Cleanup legacy artifact background migration
Add migration and spec
commit 3cc12e1268a6865f524d8fab1804f018312fdf5a
Author: Shinya Maeda <shinya@gitlab.com>
Date: Tue Jan 8 19:34:31 2019 +0900
Add changelog to this change
commit 5006fc96e38db514956a35f53ae8ee536548a2e9
Author: Shinya Maeda <shinya@gitlab.com>
Date: Tue Jan 8 19:32:56 2019 +0900
Remove partial index from ci_builds artifact_file
ok
Update schema
commit 3c956bdc02b195bc67d0327bf3748a631ea5466d
Author: Shinya Maeda <shinya@gitlab.com>
Date: Mon Jan 7 21:41:27 2019 +0900
Add frozen_string_literal: true
commit 8c827cd616890160e6e8908843403a6f20c03236
Author: Shinya Maeda <shinya@gitlab.com>
Date: Mon Jan 7 21:40:06 2019 +0900
Set batch size 100
commit aeee559777d3bdeadfd2b9bb61d460f2dc1fa8a6
Author: Shinya Maeda <shinya@gitlab.com>
Date: Fri Jan 4 18:33:05 2019 +0900
Cleanup legacy artifact background migration
Diffstat (limited to 'db/migrate/20190104182041_cleanup_legacy_artifact_migration.rb')
-rw-r--r-- | db/migrate/20190104182041_cleanup_legacy_artifact_migration.rb | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/db/migrate/20190104182041_cleanup_legacy_artifact_migration.rb b/db/migrate/20190104182041_cleanup_legacy_artifact_migration.rb new file mode 100644 index 00000000000..11659846a06 --- /dev/null +++ b/db/migrate/20190104182041_cleanup_legacy_artifact_migration.rb @@ -0,0 +1,34 @@ +# frozen_string_literal: true + +class CleanupLegacyArtifactMigration < ActiveRecord::Migration[5.0] + include Gitlab::Database::MigrationHelpers + + DOWNTIME = false + + disable_ddl_transaction! + + class Build < ActiveRecord::Base + include EachBatch + + self.table_name = 'ci_builds' + self.inheritance_column = :_type_disabled + + scope :with_legacy_artifacts, -> { where("artifacts_file <> ''") } + end + + def up + Gitlab::BackgroundMigration.steal('MigrateLegacyArtifacts') + + CleanupLegacyArtifactMigration::Build + .with_legacy_artifacts + .each_batch(of: 100) do |batch| + range = batch.pluck('MIN(id)', 'MAX(id)').first + + Gitlab::BackgroundMigration::MigrateLegacyArtifacts.new.perform(*range) + end + end + + def down + # no-op + end +end |