Merge branch 'master' into 15106-trgm-text-search

[arvados.git] / services / api / db / migrate / 20180806133039_index_all_filenames.rb

diff --git a/services/api/db/migrate/20180806133039_index_all_filenames.rb b/services/api/db/migrate/20180806133039_index_all_filenames.rb
index 79259f91d8cca89c8ec47e0011034acd8fddf4ab..6597798b27848eff3a66decd1018da4d4f7052cf 100644 (file)
--- a/services/api/db/migrate/20180806133039_index_all_filenames.rb
+++ b/services/api/db/migrate/20180806133039_index_all_filenames.rb
@@ -2,15 +2,9 @@
 #
 # SPDX-License-Identifier: AGPL-3.0
 
-class IndexAllFilenames < ActiveRecord::Migration
+class IndexAllFilenames < ActiveRecord::Migration[4.2]
   def up
     ActiveRecord::Base.connection.execute 'ALTER TABLE collections ALTER COLUMN file_names TYPE text'
-    Collection.find_each(batch_size: 20) do |c|
-      ActiveRecord::Base.connection.execute "UPDATE collections
-                    SET file_names = #{ActiveRecord::Base.connection.quote(c.manifest_files)}
-                    WHERE uuid = #{ActiveRecord::Base.connection.quote(c.uuid)}
-                    AND portable_data_hash = #{ActiveRecord::Base.connection.quote(c.portable_data_hash)}"
-    end
   end
   def down
     ActiveRecord::Base.connection.execute 'ALTER TABLE collections ALTER COLUMN file_names TYPE varchar(8192)'