projects
/
arvados.git
/ blobdiff
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge branch '19141-nokogiri-update'. Closes #19141
[arvados.git]
/
services
/
api
/
db
/
migrate
/
20140817035914_add_unique_name_constraints.rb
diff --git
a/services/api/db/migrate/20140817035914_add_unique_name_constraints.rb
b/services/api/db/migrate/20140817035914_add_unique_name_constraints.rb
index f84c6352e0963188826c7bf562c1e904ffdb4e5e..8acae9f20345977611a1000d75c63f08099ac5ef 100644
(file)
--- a/
services/api/db/migrate/20140817035914_add_unique_name_constraints.rb
+++ b/
services/api/db/migrate/20140817035914_add_unique_name_constraints.rb
@@
-1,7
+1,11
@@
-class AddUniqueNameConstraints < ActiveRecord::Migration
+# Copyright (C) The Arvados Authors. All rights reserved.
+#
+# SPDX-License-Identifier: AGPL-3.0
+
+class AddUniqueNameConstraints < ActiveRecord::Migration[4.2]
def change
# Ensure uniqueness before adding constraints.
def change
# Ensure uniqueness before adding constraints.
- ["collections", "pipeline_templates", "
pipeline_instances", "jobs", "
groups"].each do |table|
+ ["collections", "pipeline_templates", "groups"].each do |table|
rows = ActiveRecord::Base.connection.select_all %{
select uuid, owner_uuid, name from #{table} order by owner_uuid, name
}
rows = ActiveRecord::Base.connection.select_all %{
select uuid, owner_uuid, name from #{table} order by owner_uuid, name
}
@@
-24,10
+28,6
@@
update #{table} set name='#{r["name"]} #{n}' where uuid='#{r["uuid"]}'
name: 'collection_owner_uuid_name_unique')
add_index(:pipeline_templates, [:owner_uuid, :name], unique: true,
name: 'pipeline_template_owner_uuid_name_unique')
name: 'collection_owner_uuid_name_unique')
add_index(:pipeline_templates, [:owner_uuid, :name], unique: true,
name: 'pipeline_template_owner_uuid_name_unique')
- add_index(:pipeline_instances, [:owner_uuid, :name], unique: true,
- name: 'pipeline_instance_owner_uuid_name_unique')
- add_index(:jobs, [:owner_uuid, :name], unique: true,
- name: 'jobs_owner_uuid_name_unique')
add_index(:groups, [:owner_uuid, :name], unique: true,
name: 'groups_owner_uuid_name_unique')
end
add_index(:groups, [:owner_uuid, :name], unique: true,
name: 'groups_owner_uuid_name_unique')
end