14819: Merge branch 'master' into 14819-arvados-jobs-on-stretch

[arvados.git] / services / api / db / migrate / 20140519205916_create_keep_services.rb

diff --git a/services/api/db/migrate/20140519205916_create_keep_services.rb b/services/api/db/migrate/20140519205916_create_keep_services.rb
index 71387374b0d27e4a6953dbbd8f8e63e24d792a7b..e6cb967538cbd3a5ed91c43812c81fa701951dff 100644 (file)
--- a/services/api/db/migrate/20140519205916_create_keep_services.rb
+++ b/services/api/db/migrate/20140519205916_create_keep_services.rb
@@ -1,18 +1,55 @@
+# Copyright (C) The Arvados Authors. All rights reserved.
+#
+# SPDX-License-Identifier: AGPL-3.0
+
 class CreateKeepServices < ActiveRecord::Migration
+  include CurrentApiClient
+
   def change
-    create_table :keep_services do |t|
-      t.string :uuid, :null => false
-      t.string :owner_uuid, :null => false
-      t.string :modified_by_client_uuid
-      t.string :modified_by_user_uuid
-      t.datetime :modified_at
-      t.string   :service_host
-      t.integer  :service_port
-      t.boolean  :service_ssl_flag
-      t.string   :service_type
-
-      t.timestamps
+    act_as_system_user do
+      create_table :keep_services do |t|
+        t.string :uuid, :null => false
+        t.string :owner_uuid, :null => false
+        t.string :modified_by_client_uuid
+        t.string :modified_by_user_uuid
+        t.datetime :modified_at
+        t.string   :service_host
+        t.integer  :service_port
+        t.boolean  :service_ssl_flag
+        t.string   :service_type
+
+        t.timestamps
+      end
+      add_index :keep_services, :uuid, :unique => true
+
+      add_column :keep_disks, :keep_service_uuid, :string
+
+      KeepDisk.reset_column_information
+
+      services = {}
+
+      KeepDisk.find_each do |k|
+        services["#{k[:service_host]}_#{k[:service_port]}_#{k[:service_ssl_flag]}"] = {
+          service_host: k[:service_host],
+          service_port: k[:service_port],
+          service_ssl_flag: k[:service_ssl_flag],
+          service_type: 'disk',
+          owner_uuid: k[:owner_uuid]
+        }
+      end
+
+      services.each do |k, v|
+        v['uuid'] = KeepService.create(v).uuid
+      end
+
+      KeepDisk.find_each do |k|
+        k.keep_service_uuid = services["#{k[:service_host]}_#{k[:service_port]}_#{k[:service_ssl_flag]}"]['uuid']
+        k.save
+      end
+
+      remove_column :keep_disks, :service_host
+      remove_column :keep_disks, :service_port
+      remove_column :keep_disks, :service_ssl_flag
     end
-    add_index :keep_services, :uuid, :unique => true
   end
 end