You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by ma...@apache.org on 2019/10/31 21:43:14 UTC
[airavata] branch master updated: Copy oauth details from
profile_service
This is an automated email from the ASF dual-hosted git repository.
machristie pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/airavata.git
The following commit(s) were added to refs/heads/master by this push:
new deaa9a2 Copy oauth details from profile_service
deaa9a2 is described below
commit deaa9a29b67e9f659ab9579ce557f75f25161b3c
Author: Marcus Christie <ma...@iu.edu>
AuthorDate: Thu Oct 31 17:42:58 2019 -0400
Copy oauth details from profile_service
---
.../0.18-0.19/DeltaScripts/experimentCatalog_schema_delta.sql | 10 ++++++++++
1 file changed, 10 insertions(+)
diff --git a/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/experimentCatalog_schema_delta.sql b/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/experimentCatalog_schema_delta.sql
index baae923..5823d9c 100644
--- a/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/experimentCatalog_schema_delta.sql
+++ b/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/experimentCatalog_schema_delta.sql
@@ -104,3 +104,13 @@ ALTER TABLE `PROCESS_OUTPUT` ADD COLUMN IF NOT EXISTS METADATA VARCHAR(4096);
ALTER TABLE `PROCESS` ADD COLUMN IF NOT EXISTS `GROUP_RESOURCE_PROFILE_ID` varchar(255) DEFAULT NULL;
ALTER TABLE `USER_CONFIGURATION_DATA` ADD IF NOT EXISTS `GROUP_RESOURCE_PROFILE_ID` varchar(255) DEFAULT NULL;
+
+-- Copy OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET from profile_service.GATEWAY
+update GATEWAY g
+inner join profile_service.GATEWAY pg
+on pg.GATEWAY_ID = g.GATEWAY_ID
+set g.OAUTH_CLIENT_ID = pg.OAUTH_CLIENT_ID,
+ g.OAUTH_CLIENT_SECRET = pg.OAUTH_CLIENT_SECRET
+where
+ g.OAUTH_CLIENT_ID is null
+ or g.OAUTH_CLIENT_SECRET is null;