diff options
Diffstat (limited to 'db/post_migrate/20201216185336_add_devops_adoption_snapshot_not_null.rb')
-rw-r--r-- | db/post_migrate/20201216185336_add_devops_adoption_snapshot_not_null.rb | 31 |
1 files changed, 0 insertions, 31 deletions
diff --git a/db/post_migrate/20201216185336_add_devops_adoption_snapshot_not_null.rb b/db/post_migrate/20201216185336_add_devops_adoption_snapshot_not_null.rb deleted file mode 100644 index 1bb3c57f3cd..00000000000 --- a/db/post_migrate/20201216185336_add_devops_adoption_snapshot_not_null.rb +++ /dev/null @@ -1,31 +0,0 @@ -# frozen_string_literal: true - -class AddDevopsAdoptionSnapshotNotNull < ActiveRecord::Migration[6.0] - include Gitlab::Database::MigrationHelpers - - DOWNTIME = false - - disable_ddl_transaction! - - def up - with_lock_retries do - execute( - <<~SQL - LOCK TABLE analytics_devops_adoption_snapshots IN ACCESS EXCLUSIVE MODE; - - UPDATE analytics_devops_adoption_snapshots SET end_time = date_trunc('month', recorded_at) - interval '1 millisecond'; - - ALTER TABLE analytics_devops_adoption_snapshots ALTER COLUMN end_time SET NOT NULL; - SQL - ) - end - end - - def down - with_lock_retries do - execute(<<~SQL) - ALTER TABLE analytics_devops_adoption_snapshots ALTER COLUMN end_time DROP NOT NULL; - SQL - end - end -end |