----- Original Message -----
From: "Eli Mesika" <emesika(a)redhat.com>
To: "engine-devel(a)ovirt.org" <devel(a)ovirt.org>
Sent: Monday, November 17, 2014 12:42:29 PM
Subject: Re: [ovirt-devel] [db] add config key with same value to multiple versions
----- Original Message -----
> From: "Eli Mesika" <emesika(a)redhat.com>
> To: "engine-devel(a)ovirt.org" <devel(a)ovirt.org>
> Sent: Monday, November 17, 2014 12:40:53 PM
> Subject: [ovirt-devel] [db] add config key with same value to multiple
> versions
>
> Hi
>
> Please note that I have added a common function to ease handling of
> configuration settings:
>
> signature : fn_db_add_config_value_for_versions_up_to(v_option_name, v_val
> ,
> v_version )
>
> so, for example, if you want to add a new feature F1 flag, which is true
> only
> for 3.6, to 0000_config.sql instead of :
>
> select fn_db_add_config_value('F1','false','3.0');
> select fn_db_add_config_value('F1','false','3.1');
> select fn_db_add_config_value('F1','false','3.2');
> select fn_db_add_config_value('F1','false','3.3');
> select fn_db_add_config_value('F1','false', '3.4');
> select fn_db_add_config_value('F1','true', '3.5');
sorry, this one is
select fn_db_add_config_value('F1','false', '3.5');
>
> All you have to do is :
>
> fn_db_add_config_value_for_versions_up_to('F1','true',
'3.5');
fn_db_add_config_value_for_versions_up_to('F1','false', '3.5');
>
> This is true also for other values, for example if you have a key K1 that
> has
> values 'a' for {3.0, 3.1} and 'b' for {3.2, 3.3, 3.4, 3.5)
>
> instead of
>
> select fn_db_add_config_value('K1','a','3.0');
> select fn_db_add_config_value('K1','a','3.1');
> select fn_db_add_config_value('K1','b','3.2');
> select fn_db_add_config_value('K1','b','3.3');
> select fn_db_add_config_value('K1','b', '3.4');
> select fn_db_add_config_value('K1','b', '3.5');
>
> simply write :
>
> fn_db_add_config_value_for_versions_up_to('K1','a', '3.1');
> fn_db_add_config_value_for_versions_up_to('K1','b', '3.5');
>
>
>
> Thanks
> Eli Mesika
>
> _______________________________________________
> Devel mailing list
> Devel(a)ovirt.org
>
http://lists.ovirt.org/mailman/listinfo/devel
>