Groundwork for merging CI into CE

1 files changed, 21 insertions, 0 deletions

diff --git a/db/ci/migrate/20150204001035_build_missing_services.rb b/db/ci/migrate/20150204001035_build_missing_services.rb
new file mode 100644
index 00000000000..437ad072ead
--- /dev/null
+++ b/db/ci/migrate/20150204001035_build_missing_services.rb
@@ -0,0 +1,21 @@
+class BuildMissingServices < ActiveRecord::Migration
+  def up
+    Project.find_each do |project|
+      # Slack service creation
+      slack_service = select_one("SELECT id FROM services WHERE type='SlackService' AND project_id = #{project.id}")
+      
+      unless slack_service
+        execute("INSERT INTO services (type, project_id, active, properties, created_at, updated_at) \
+            VALUES ('SlackService', '#{project.id}', false, '{}', NOW(), NOW())")
+      end
+
+      # Mail service creation
+      mail_service = select_one("SELECT id FROM services WHERE type='MailService' AND project_id = #{project.id}")
+      
+      unless mail_service
+        execute("INSERT INTO services (type, project_id, active, properties, created_at, updated_at) \
+            VALUES ('MailService', '#{project.id}', true, '{}', NOW(), NOW())")
+      end
+    end
+  end
+end