[ovirt-devel] [db] add config key with same value to multiple versions

[Eli Mesika]

----- Original Message -----
> From: "Eli Mesika" <emesika at redhat.com>
> To: "engine-devel at ovirt.org" <devel at 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');
> 
> 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 at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/devel
>