services/api/db/migrate/20161115174218_add_output_and_log_uuids_to_container_request_search_index.rb

   1 # Copyright (C) The Arvados Authors. All rights reserved.
   2 #
   3 # SPDX-License-Identifier: AGPL-3.0
   4
   5 class AddOutputAndLogUuidsToContainerRequestSearchIndex < ActiveRecord::Migration
   6   def up
   7     begin
   8       remove_index :container_requests, :name => 'container_requests_search_index'
   9     rescue
  10     end
  11     add_index :container_requests,
  12               ["uuid", "owner_uuid", "modified_by_client_uuid", "modified_by_user_uuid", "name", "state", "requesting_container_uuid", "container_uuid", "container_image", "cwd", "output_path", "output_uuid", "log_uuid"],
  13               name: "container_requests_search_index"
  14   end
  15
  16   def down
  17     begin
  18       remove_index :container_requests, :name => 'container_requests_search_index'
  19     rescue
  20     end
  21           add_index :container_requests,
  22               ["uuid", "owner_uuid", "modified_by_client_uuid", "modified_by_user_uuid", "name", "state", "requesting_container_uuid", "container_uuid", "container_image", "cwd", "output_path"],
  23               name: "container_requests_search_index"
  24   end
  25 end