fix migration failing

1 files changed, 15 insertions, 1 deletions

diff --git a/db/migrate/20150204001035_build_missing_services.rb b/db/migrate/20150204001035_build_missing_services.rb
index 5e9b365..437ad07 100644
--- a/db/migrate/20150204001035_build_missing_services.rb
+++ b/db/migrate/20150204001035_build_missing_services.rb
@@ -1,7 +1,21 @@
 class BuildMissingServices < ActiveRecord::Migration
   def up
     Project.find_each do |project|
-      project.build_missing_services if project.respond_to?(:build_missing_services)
+      # 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