Eli Mesika has uploaded a new change for review. Change subject: db: add config key with same value to multiple versions ......................................................................
db: add config key with same value to multiple versions Adds a general function that can add a configuration key with same value to multiple versions Change-Id: I432038577c1e695d2821471a607ab842ea64c97b Signed-off-by: Eli Mesika <emes...@redhat.com> --- M packaging/dbscripts/common_sp.sql 1 file changed, 21 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/14/35114/1 diff --git a/packaging/dbscripts/common_sp.sql b/packaging/dbscripts/common_sp.sql index 18951ac..de2eb53 100644 --- a/packaging/dbscripts/common_sp.sql +++ b/packaging/dbscripts/common_sp.sql @@ -601,3 +601,24 @@ END; $procedure$ LANGUAGE plpgsql; +-- sets the v_val value for v_option_name in vdc_options for all versions before and up to v_version including v_version +create or replace FUNCTION fn_db_add_config_value_for_versions(v_option_name varchar(100), v_val varchar(4000), v_version varchar(40)) +returns void +AS $procedure$ +declare + m varchar; + arr varchar[] := array['3.0', '3.1', '3.2', '3.3', '3.4', '3.5', '3.6']; +begin + FOREACH m IN ARRAY arr + LOOP + IF m != v_version THEN + perform fn_db_add_config_value(v_option_name, v_val, m); + ELSE + perform fn_db_add_config_value(v_option_name, v_val, m); + EXIT; + END IF; + END LOOP; +END; $procedure$ +LANGUAGE plpgsql; + + -- To view, visit http://gerrit.ovirt.org/35114 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I432038577c1e695d2821471a607ab842ea64c97b Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <emes...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
