Yaniv Dary has uploaded a new change for review. Change subject: history: change needed fuction location to pre-upgrade ......................................................................
history: change needed fuction location to pre-upgrade Change-Id: Id0e0bd79e75df17c6ff01b50ae8184cc910db66b Signed-off-by: Yaniv Dary <[email protected]> --- M data-warehouse/historydbscripts_postgres/create_sp.sql M data-warehouse/historydbscripts_postgres/upgrade/03_02_0050_add_function_to_update_enum_table.sql A data-warehouse/historydbscripts_postgres/upgrade/pre_upgrade/add_function_to_update_enum_table.sql 3 files changed, 15 insertions(+), 28 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/77/15677/1 diff --git a/data-warehouse/historydbscripts_postgres/create_sp.sql b/data-warehouse/historydbscripts_postgres/create_sp.sql index 767c55c..ccdc691 100644 --- a/data-warehouse/historydbscripts_postgres/create_sp.sql +++ b/data-warehouse/historydbscripts_postgres/create_sp.sql @@ -1,15 +1 @@ --This file is a place holder for the creation of stored procedures in the oVirt Engine History database. -CREATE OR REPLACE FUNCTION update_enum_translator(enum_type varchar(40), enum_key smallint, language_code varchar(40), value text) RETURNS void AS $$ -BEGIN - DELETE FROM enum_translator - WHERE enum_translator.enum_type = update_enum_translator.enum_type - AND enum_translator.enum_key = update_enum_translator.enum_key - AND enum_translator.language_code = update_enum_translator.language_code - AND EXISTS (SELECT 1 - FROM enum_translator as a - WHERE a.enum_type = update_enum_translator.enum_type - AND a.enum_key = update_enum_translator.enum_key - AND a.language_code = update_enum_translator.language_code); - INSERT INTO enum_translator VALUES (update_enum_translator.enum_type, update_enum_translator.enum_key, update_enum_translator.language_code, update_enum_translator.value); -END; -$$ LANGUAGE plpgsql; diff --git a/data-warehouse/historydbscripts_postgres/upgrade/03_02_0050_add_function_to_update_enum_table.sql b/data-warehouse/historydbscripts_postgres/upgrade/03_02_0050_add_function_to_update_enum_table.sql index ef5e323..e0ac49d 100644 --- a/data-warehouse/historydbscripts_postgres/upgrade/03_02_0050_add_function_to_update_enum_table.sql +++ b/data-warehouse/historydbscripts_postgres/upgrade/03_02_0050_add_function_to_update_enum_table.sql @@ -1,14 +1 @@ -CREATE OR REPLACE FUNCTION update_enum_translator(enum_type varchar(40), enum_key smallint, language_code varchar(40), value text) RETURNS void AS $$ -BEGIN - DELETE FROM enum_translator - WHERE enum_translator.enum_type = update_enum_translator.enum_type - AND enum_translator.enum_key = update_enum_translator.enum_key - AND enum_translator.language_code = update_enum_translator.language_code - AND EXISTS (SELECT 1 - FROM enum_translator as a - WHERE a.enum_type = update_enum_translator.enum_type - AND a.enum_key = update_enum_translator.enum_key - AND a.language_code = update_enum_translator.language_code); - INSERT INTO enum_translator VALUES (update_enum_translator.enum_type, update_enum_translator.enum_key, update_enum_translator.language_code, update_enum_translator.value); -END; -$$ LANGUAGE plpgsql; +SELECT 1; diff --git a/data-warehouse/historydbscripts_postgres/upgrade/pre_upgrade/add_function_to_update_enum_table.sql b/data-warehouse/historydbscripts_postgres/upgrade/pre_upgrade/add_function_to_update_enum_table.sql new file mode 100644 index 0000000..ef5e323 --- /dev/null +++ b/data-warehouse/historydbscripts_postgres/upgrade/pre_upgrade/add_function_to_update_enum_table.sql @@ -0,0 +1,14 @@ +CREATE OR REPLACE FUNCTION update_enum_translator(enum_type varchar(40), enum_key smallint, language_code varchar(40), value text) RETURNS void AS $$ +BEGIN + DELETE FROM enum_translator + WHERE enum_translator.enum_type = update_enum_translator.enum_type + AND enum_translator.enum_key = update_enum_translator.enum_key + AND enum_translator.language_code = update_enum_translator.language_code + AND EXISTS (SELECT 1 + FROM enum_translator as a + WHERE a.enum_type = update_enum_translator.enum_type + AND a.enum_key = update_enum_translator.enum_key + AND a.language_code = update_enum_translator.language_code); + INSERT INTO enum_translator VALUES (update_enum_translator.enum_type, update_enum_translator.enum_key, update_enum_translator.language_code, update_enum_translator.value); +END; +$$ LANGUAGE plpgsql; -- To view, visit http://gerrit.ovirt.org/15677 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Id0e0bd79e75df17c6ff01b50ae8184cc910db66b Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
