X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/eeef002557bc361a10483d1924c49e35e8a23fde..eb8307817db46d208c5c3517dbeafbc5b02a6f5f:/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 79259f91d8..6597798b27 100644 --- 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)'