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
