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

17 Nov 2014

      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');

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