You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airavata.apache.org by ya...@apache.org on 2025/11/10 23:42:56 UTC
(airavata) 06/24: Rename storageId to inputStorageResourceId in Python SDK
This is an automated email from the ASF dual-hosted git repository.
yasith pushed a commit to branch resource-mgmt-rest-api
in repository https://gitbox.apache.org/repos/asf/airavata.git
commit e5ea7a85b89e9bafea51b1041f0e984ade68af95
Author: lahiruj <la...@gmail.com>
AuthorDate: Thu Oct 30 17:29:56 2025 -0400
Rename storageId to inputStorageResourceId in Python SDK
---
.../database_scripts/init/04-expcatalog-migrations.sql | 15 ++++++++++++++-
1 file changed, 14 insertions(+), 1 deletion(-)
diff --git a/.devcontainer/database_scripts/init/04-expcatalog-migrations.sql b/.devcontainer/database_scripts/init/04-expcatalog-migrations.sql
index 678d272869..bb32d3f438 100644
--- a/.devcontainer/database_scripts/init/04-expcatalog-migrations.sql
+++ b/.devcontainer/database_scripts/init/04-expcatalog-migrations.sql
@@ -38,4 +38,17 @@ ALTER TABLE PROCESS CHANGE COLUMN STORAGE_RESOURCE_ID INPUT_STORAGE_RESOURCE_ID
-- Add output storage resource ID columns
ALTER TABLE USER_CONFIGURATION_DATA ADD COLUMN IF NOT EXISTS OUTPUT_STORAGE_RESOURCE_ID VARCHAR(255) DEFAULT NULL;
-ALTER TABLE PROCESS ADD COLUMN IF NOT EXISTS OUTPUT_STORAGE_RESOURCE_ID VARCHAR(255) DEFAULT NULL;
\ No newline at end of file
+ALTER TABLE PROCESS ADD COLUMN IF NOT EXISTS OUTPUT_STORAGE_RESOURCE_ID VARCHAR(255) DEFAULT NULL;
+
+-- Update OUTPUT_STORAGE_RESOURCE_ID with INPUT_STORAGE_RESOURCE_ID when missing
+UPDATE USER_CONFIGURATION_DATA
+SET OUTPUT_STORAGE_RESOURCE_ID = INPUT_STORAGE_RESOURCE_ID
+WHERE (OUTPUT_STORAGE_RESOURCE_ID IS NULL OR OUTPUT_STORAGE_RESOURCE_ID = '')
+ AND INPUT_STORAGE_RESOURCE_ID IS NOT NULL
+ AND INPUT_STORAGE_RESOURCE_ID != '';
+
+UPDATE PROCESS
+SET OUTPUT_STORAGE_RESOURCE_ID = INPUT_STORAGE_RESOURCE_ID
+WHERE (OUTPUT_STORAGE_RESOURCE_ID IS NULL OR OUTPUT_STORAGE_RESOURCE_ID = '')
+ AND INPUT_STORAGE_RESOURCE_ID IS NOT NULL
+ AND INPUT_STORAGE_RESOURCE_ID != '';
\ No newline at end of file