2 #include "sq3_settings_db.hpp"
24 return this->
execute(
"delete from settings" );
29 return this->
execute(
"delete from settings " + where );
33 static std::string SettingsDb_Set_SQL =
"insert into settings values(?,?)";
37 statement st( *
this, SettingsDb_Set_SQL );
45 statement st( *
this, SettingsDb_Set_SQL );
53 statement st( *
this, SettingsDb_Set_SQL );
55 st.
bind( 2, val ? 1 : 0 );
61 statement st( *
this, SettingsDb_Set_SQL );
69 statement st( *
this, SettingsDb_Set_SQL );
77 statement st( *
this, SettingsDb_Set_SQL );
79 st.
bind( 2, val ? val :
"" );
83 int settings_db::on_open()
85 int rc = this->
execute(
"create table if not exists settings(key PRIMARY KEY ON CONFLICT REPLACE,value)" );
86 this->
execute(
"PRAGMA temp_store = MEMORY" );
87 this->
pragma(
"synchronous = OFF" );
91 static std::string SettingsDb_Get_SQL =
"select value from settings where key = ?";
97 statement st( *
this, SettingsDb_Get_SQL );
112 statement st( *
this, SettingsDb_Get_SQL );
126 statement st( *
this, SettingsDb_Get_SQL );
132 val = ( foo ?
true :
false);
146 statement st( *
this, SettingsDb_Get_SQL );
160 statement st( *
this, SettingsDb_Get_SQL );