Yaniv Dary has uploaded a new change for review. Change subject: history: added utility fuction to update enum values (#918075) ......................................................................
history: added utility fuction to update enum values (#918075) Bug-Url: https://bugzilla.redhat.com/918075 Change-Id: I5921a20165466cba5f5ab7870dafb3d53cda8b8d Signed-off-by: Yaniv Dary <[email protected]> --- A data-warehouse/historydbscripts_postgres/upgrade/03_02_0050_add_function_to_update_enum_table.sql 1 file changed, 14 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/29/12929/1 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 new file mode 100644 index 0000000..ef5e323 --- /dev/null +++ b/data-warehouse/historydbscripts_postgres/upgrade/03_02_0050_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/12929 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I5921a20165466cba5f5ab7870dafb3d53cda8b8d 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
