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()