From 962eb5551fd7a789640f479bffef6ec39131d8cf Mon Sep 17 00:00:00 2001 From: Robert Speicher Date: Wed, 17 May 2017 22:23:19 +0000 Subject: Merge branch 'zj-fix-migration' into 'master' Fix data migration from trigger schedules See merge request !11460 --- ...170425121605_migrate_trigger_schedules_to_pipeline_schedules.rb | 7 +++++++ 1 file changed, 7 insertions(+) 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 index a44b399c4de..dae9750558f 100644 --- a/db/post_migrate/20170425121605_migrate_trigger_schedules_to_pipeline_schedules.rb +++ b/db/post_migrate/20170425121605_migrate_trigger_schedules_to_pipeline_schedules.rb @@ -4,6 +4,13 @@ class MigrateTriggerSchedulesToPipelineSchedules < ActiveRecord::Migration 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, -- cgit v1.2.1