def test_save_event(tmpdir): db = tmpdir.mkdir("tmp").join("ae.db") events = Events(str(db)) events.save(name="party", start="2014-09-21 12:00:00", end="2014-09-21 22:00:00", note="foo") conn = sqlite3.connect(events.db) with conn: conn.row_factory = dict_factory cur = conn.cursor() cur.execute("SELECT * FROM events WHERE name=?", ("party",)) q = cur.fetchone() assert q["name"] == "party" assert q["start"] == "2014-09-21 12:00:00" assert q["end"] == "2014-09-21 22:00:00" assert q["note"] == "foo"
def test_query_between_date(tmpdir): db = tmpdir.mkdir("tmp").join("qbd.db") events = Events(str(db)) events.save("party", "2012-10-05 00:00:00") events.save("eat", "2012-10-01 00:00:00", "2012-11-01 00:00:00") events.save("concert", "2012-09-23 00:00:00") q = events._query_between_date("2012-10-05", "2012-10-06") assert len(q) == 2
def create_events(tmpdir): db = tmpdir.mkdir("tmp").join("{}.db".format(randint(1, 10000))) events = Events(str(db)) events.save("party", datetime.datetime.now()) events.save("eat", datetime.datetime.now() - datetime.timedelta(days=60)) return events