summaryrefslogtreecommitdiff
path: root/db/post_migrate/20170425121605_migrate_trigger_schedules_to_pipeline_schedules.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/post_migrate/20170425121605_migrate_trigger_schedules_to_pipeline_schedules.rb')
-rw-r--r--db/post_migrate/20170425121605_migrate_trigger_schedules_to_pipeline_schedules.rb48
1 files changed, 0 insertions, 48 deletions
diff --git a/db/post_migrate/20170425121605_migrate_trigger_schedules_to_pipeline_schedules.rb b/db/post_migrate/20170425121605_migrate_trigger_schedules_to_pipeline_schedules.rb
deleted file mode 100644
index 99ded277277..00000000000
--- a/db/post_migrate/20170425121605_migrate_trigger_schedules_to_pipeline_schedules.rb
+++ /dev/null
@@ -1,48 +0,0 @@
-class MigrateTriggerSchedulesToPipelineSchedules < ActiveRecord::Migration[4.2]
- include Gitlab::Database::MigrationHelpers
-
- DOWNTIME = false
-
- def up
- connection.execute <<~SQL
- DELETE FROM ci_trigger_schedules WHERE NOT EXISTS
- (SELECT true FROM projects
- WHERE ci_trigger_schedules.project_id = projects.id
- )
- SQL
-
- connection.execute <<-SQL
- INSERT INTO ci_pipeline_schedules (
- project_id,
- created_at,
- updated_at,
- deleted_at,
- cron,
- cron_timezone,
- next_run_at,
- ref,
- active,
- owner_id,
- description
- )
- SELECT
- ci_trigger_schedules.project_id,
- ci_trigger_schedules.created_at,
- ci_trigger_schedules.updated_at,
- ci_trigger_schedules.deleted_at,
- ci_trigger_schedules.cron,
- ci_trigger_schedules.cron_timezone,
- ci_trigger_schedules.next_run_at,
- ci_trigger_schedules.ref,
- ci_trigger_schedules.active,
- ci_triggers.owner_id,
- ci_triggers.description
- FROM ci_trigger_schedules
- INNER JOIN ci_triggers ON ci_trigger_schedules.trigger_id=ci_triggers.id;
- SQL
- end
-
- def down
- # no op as the data has been removed
- end
-end