def save_event(event, update): db_event = { "uuid": event["uuid"], "foreground_image_uuid": event["foreground_image_uuid"], "display_text": event["display_text"], "event_start": event["event_start"], "event_end": event["event_end"], "override": event["override"] } with db.conn(s_settings['database']) as conn: if update: with db.commit(conn) as c: c.execute(update_event(db_event.keys()), db_event.values() + [db_event["uuid"]]) else: conn.execute(create_event(db_event.keys()), db_event.values())
def save_schedule_slot(slot, update): db_slot = { "uuid": slot["uuid"], "template_uuid": slot["template_uuid"], "foreground_image_uuid": slot["foreground_image_uuid"], "display_text": slot["display_text"], "time_format": slot["time_format"], "start_time": slot["start_time"], "weekday": slot["weekday"] } with db.conn(s_settings['database']) as conn: if update: with db.commit(conn) as c: c.execute(update_schedule(db_slot.keys()), db_slot.values() + [db_slot["uuid"]]) else: conn.execute(create_schedule(db_slot.keys()), db_slot.values())
def test_commit(self): db = self.db() db.connect() db.commit() self.assertTrue(db._conn.commit_kwargs is not None)
def setUp(self): self.assertEmpty = functools.partial(self.assertEqual, []) self.conn = db.conn(':memory:') with db.commit(self.conn) as cursor: cursor.execute(assets_helper.create_assets_table)
def setUp(self): self.old_db_path = settings.settings['database'] viewer.db_conn = db.conn(':memory:') with db.commit(viewer.db_conn) as cursor: cursor.execute(assets_helper.create_assets_table)
def init_db(): with closing(connect_db()) as db: with app.open_resource('schema.sql', mode='r') as f: db.cursor().executescript(f.read()) db.commit()