From 58af12227014f0881b94462f8dc0990fc46ab818 Mon Sep 17 00:00:00 2001 From: radhika Date: Tue, 9 Feb 2016 09:57:15 -0500 Subject: [PATCH] 8079: update the migration script to use the api_token as the seed --- .../20160208210629_add_uuid_to_api_client_authorization.rb | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/services/api/db/migrate/20160208210629_add_uuid_to_api_client_authorization.rb b/services/api/db/migrate/20160208210629_add_uuid_to_api_client_authorization.rb index 73b5fdfb9e..cc8600198e 100644 --- a/services/api/db/migrate/20160208210629_add_uuid_to_api_client_authorization.rb +++ b/services/api/db/migrate/20160208210629_add_uuid_to_api_client_authorization.rb @@ -11,7 +11,9 @@ class AddUuidToApiClientAuthorization < ActiveRecord::Migration Digest::MD5.hexdigest('ApiClientAuthorization'.to_s).to_i(16).to_s(36)[-5..-1] + '-' update_sql <<-EOS -update api_client_authorizations set uuid = (select concat('#{prefix}', substring(api_token, length(api_token)-4), array_to_string(ARRAY (SELECT substring('0123456789abcdefghijklmnopqrstuvwxyz' FROM (ceil(random()*36))::int FOR 1) FROM generate_series(1, 10)), ''))); +update api_client_authorizations set uuid = (select concat('#{prefix}', +array_to_string(ARRAY (SELECT substring(api_token FROM (ceil(random()*36))::int FOR 1) FROM generate_series(1, 15)), '') +)); EOS change_column_null :api_client_authorizations, :uuid, false -- 2.30.2