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 <[email protected]> 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
