def test_should_add_trigger_to_db(self):
store = LightsSqliteStore(self.temp_file.name)
store.add_trigger(self.trigger)
conn = sqlite3.connect(self.temp_file.name)
conn.row_factory = sqlite3.Row
cursor = conn.cursor()
rows = cursor.execute("SELECT * FROM triggers").fetchall()
assert_that(rows, has_length(1))
actual = rows[0]
assert_that(actual["job_id"], is_(self.trigger.job_id))
assert_that(actual["state"], is_(self.trigger.state))
assert_that(actual["hour"], is_(self.trigger.hour))
assert_that(actual["minute"], is_(self.trigger.minute))
assert_that(actual["repeat_weekday"], is_(self.trigger.repeat_weekday))
assert_that(actual["repeat_weekend"], is_(self.trigger.repeat_weekend))
conn.close()
