cur.executescript("""
INSERT INTO users VALUES('1111','tester');
INSERT INTO users VALUES('2222','newer');
+INSERT INTO users VALUES('3333','clone');
INSERT INTO coffees (id, flavor, time) VALUES
('1111', 'espresso lungo', datetime('now', 'localtime', '-99 seconds')),
('1111', 'Club-Mate 0,5 l', datetime('now', 'localtime', '-99 seconds')),
('2222', 'espresso lungo', datetime('now', 'localtime', '-99 seconds')),
('2222', 'Club-Mate 0,33 l', datetime('now', 'localtime', '-99 seconds')),
('2222', 'espresso lungo', datetime('now', 'localtime', '-95 second')),
-('2222', 'Club-Mate 0,33 l', datetime('now', 'localtime', '-95 second'));
+('2222', 'Club-Mate 0,33 l', datetime('now', 'localtime', '-95 second')),
+('3333', 'espresso lungo', datetime('now', 'localtime', '-99 seconds')),
+('3333', 'Club-Mate 0,33 l', datetime('now', 'localtime', '-99 seconds')),
+('3333', 'espresso lungo', datetime('now', 'localtime', '-95 second')),
+('3333', 'Club-Mate 0,33 l', datetime('now', 'localtime', '-95 second'));
""")
con.close()
top,
[
("tester", 4*0.5 + 4*0.33),
- ("newer", 2*0.33)
+ ("newer", 2*0.33),
+ ("clone", 2*0.33),
]
)
finally:
db = Db(TESTDB_FILENAME)
top = db.getTopMateDrinkers()
self.assertIsNotNone(top)
- self.assertEqual(len(top), 2)
+ self.assertEqual(len(top), 3)
finally:
delete_test_db(TESTDB_FILENAME)