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 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 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 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()
def test_commit(self):
db = self.db()
db.connect()
db.commit()
self.assertTrue(db._conn.commit_kwargs is not None)
