diff --git a/pepys_import/database/postgres_stored_procedures/Contacts_for.sql b/pepys_import/database/postgres_stored_procedures/Contacts_for.sql index 76895ae0..54189c8e 100644 --- a/pepys_import/database/postgres_stored_procedures/Contacts_for.sql +++ b/pepys_import/database/postgres_stored_procedures/Contacts_for.sql @@ -5,7 +5,7 @@ DROP FUNCTION IF EXISTS PEPYS.CONTACTS_FOR; CREATE FUNCTION PEPYS.CONTACTS_FOR( INP_START_TIME TEXT, INP_END_TIME TEXT, - INP_LOCATION TEXT, + INP_BOUNDS TEXT, INP_SENSOR_ID TEXT[], INP_SOURCE_ID TEXT[], INP_PLATFORM_ID TEXT[], @@ -31,7 +31,7 @@ $$ (select inp_start_time start_time, --Input should be same as for Phase 1 inp_end_time end_time, --Input should be same as for Phase 1 - inp_location "location", --Input should be same as for Phase 1 + inp_bounds "location", --Input should be same as for Phase 1 inp_sensor_id::text[] sensor_id, --Input from Phase 2 of import, can be set as null: null as sensor_id inp_source_id::text[] source_id, --Input from Phase 2 of import, can be set as null: null as source_id inp_platform_id::text[] platform_id, --Input from Phase 2 of import, can be set as null: null as platform_id diff --git a/pepys_import/database/postgres_stored_procedures/Datafiles_for.sql b/pepys_import/database/postgres_stored_procedures/Datafiles_for.sql index ee316821..3e54a53f 100644 --- a/pepys_import/database/postgres_stored_procedures/Datafiles_for.sql +++ b/pepys_import/database/postgres_stored_procedures/Datafiles_for.sql @@ -5,7 +5,7 @@ DROP FUNCTION IF EXISTS PEPYS.DATAFILES_FOR; CREATE FUNCTION PEPYS.DATAFILES_FOR( INP_START_TIME TEXT, INP_END_TIME TEXT, - INP_LOCATION TEXT, + INP_BOUNDS TEXT, INP_DATA_TYPES TEXT[], INP_COMMENT_SEARCH_STRING TEXT) RETURNS TABLE ( @@ -26,7 +26,7 @@ $$ (select INP_START_TIME START_TIME, INP_END_TIME END_TIME, - INP_LOCATION "location", + INP_BOUNDS "location", INP_DATA_TYPES::text[] DATA_TYPES, INP_COMMENT_SEARCH_STRING COMMENT_SEARCH_STRING ), diff --git a/pepys_import/database/postgres_stored_procedures/States_for.sql b/pepys_import/database/postgres_stored_procedures/States_for.sql index b0b7ea39..7dd6b7ec 100644 --- a/pepys_import/database/postgres_stored_procedures/States_for.sql +++ b/pepys_import/database/postgres_stored_procedures/States_for.sql @@ -5,7 +5,7 @@ DROP FUNCTION IF EXISTS PEPYS.STATES_FOR; CREATE FUNCTION PEPYS.STATES_FOR( INP_START_TIME TEXT, INP_END_TIME TEXT, - INP_LOCATION TEXT, + INP_BOUNDS TEXT, INP_SENSOR_ID TEXT[], INP_SOURCE_ID TEXT[], INP_PLATFORM_ID TEXT[], @@ -33,7 +33,7 @@ $$ (select inp_start_time start_time, --Input should be same as for Phase 1 inp_end_time end_time, --Input should be same as for Phase 1 - inp_location "location", --Input should be same as for Phase 1 + inp_bounds "location", --Input should be same as for Phase 1 inp_sensor_id::text[] sensor_id, --Input from Phase 2 of import, can be set as null: null as sensor_id inp_source_id::text[] source_id, --Input from Phase 2 of import, can be set as null: null as source_id inp_platform_id::text[] platform_id, --Input from Phase 2 of import, can be set as null: null as platform_id