[airavata] branch master updated: AIRAVATA-3268 Null out INPUT_VALUE for inputs using OVERRIDE_FILENAME

[ma...@apache.org]

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 213efb6  AIRAVATA-3268 Null out INPUT_VALUE for inputs using OVERRIDE_FILENAME
213efb6 is described below

commit 213efb65b84bbfd9e9e96a2724032c43c0ab1a8d
Author: Marcus Christie <ma...@iu.edu>
AuthorDate: Wed Dec 16 17:08:24 2020 -0500

    AIRAVATA-3268 Null out INPUT_VALUE for inputs using OVERRIDE_FILENAME
---
 .../0.18-0.19/DeltaScripts/appCatalog_schema_delta.sql                   | 1 +
 1 file changed, 1 insertion(+)

diff --git a/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/appCatalog_schema_delta.sql b/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/appCatalog_schema_delta.sql
index 1548106..846109a 100644
--- a/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/appCatalog_schema_delta.sql
+++ b/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/appCatalog_schema_delta.sql
@@ -482,6 +482,7 @@ ALTER TABLE `APPLICATION_OUTPUT` ADD COLUMN IF NOT EXISTS METADATA VARCHAR(4096)
 -- AIRAVATA-3268: add overrideFilename to APPLICATION_INPUT
 ALTER TABLE APPLICATION_INPUT ADD COLUMN IF NOT EXISTS OVERRIDE_FILENAME VARCHAR(255);
 update APPLICATION_INPUT set OVERRIDE_FILENAME = INPUT_VALUE where OVERRIDE_FILENAME is null and DATA_TYPE = 'URI' and INPUT_VALUE is not null and INPUT_VALUE != '';
+update APPLICATION_INPUT set INPUT_VALUE = NULL where OVERRIDE_FILENAME is not null and OVERRIDE_FILENAME != '' and DATA_TYPE = 'URI' and (INPUT_VALUE is not null or INPUT_VALUE = '');
 
 -- AIRAVATA-3126
 CREATE TABLE IF NOT EXISTS COMPUTE_RESOURCE_RESERVATION -- ComputeResourceReservationEntity