def set_schema_value(self, schema_id, value):
verify_multibase_schema(value)
curs = self._db.cursor()
curs.execute(
'UPDATE schemata SET value = ? WHERE schema_id = ?',
(jdumps(value), schema_id))
self._db.commit()
def add_schema(self, name, value):
verify_multibase_schema(value)
curs = self._db.cursor()
curs.execute(
'INSERT INTO schemata (name, value) VALUES (?, ?)',
(name, jdumps(value)))
self._db.commit()
def set_config(self, site, name, value):
split_name = name.split('.')
if len(split_name) > 1:
try:
base_value = self.get_config(site, split_name[0])
except ValueError:
base_value = {}
nested_set(base_value, split_name[1:], value)
name, new_value = split_name[0], base_value
else:
new_value = value
curs = self._db.cursor()
curs.execute(
'DELETE FROM config_values WHERE site_name IS ? AND name = ?',
(site, name,))
if new_value is not None:
curs.execute(
'INSERT INTO config_values (site_name, name, value) VALUES (?, ?, ?)',
(site, name, jdumps(new_value)))
self._db.commit()
def set_config(self, site, name, value):
split_name = name.split('.')
if len(split_name) > 1:
try:
base_value = self.get_config(site, split_name[0])
except ValueError:
base_value = {}
nested_set(base_value, split_name[1:], value)
name, new_value = split_name[0], base_value
else:
new_value = value
curs = self._db.cursor()
curs.execute(
'DELETE FROM config_values WHERE site_name IS ? AND name = ?', (
site,
name,
))
if new_value is not None:
curs.execute(
'INSERT INTO config_values (site_name, name, value) VALUES (?, ?, ?)',
(site, name, jdumps(new_value)))
self._db.commit()
def set_schema_value(self, schema_id, value):
verify_multibase_schema(value)
curs = self._db.cursor()
curs.execute('UPDATE schemata SET value = ? WHERE schema_id = ?',
(jdumps(value), schema_id))
self._db.commit()
def add_schema(self, name, value):
verify_multibase_schema(value)
curs = self._db.cursor()
curs.execute('INSERT INTO schemata (name, value) VALUES (?, ?)',
(name, jdumps(value)))
self._db.commit()
