('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,5 l', 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),
+ ("clone", 0.5 + 2*0.33),
("newer", 2*0.33),
- ("clone", 2*0.33),
]
)
finally:
drunk = db.getDrunkSum("Club-Mate 0,5 l", self.lwstr, self.tdystr)
self.assertEqual(drunk, [
("tester", 4),
+ ("clone", 1),
])
finally:
delete_test_db(TESTDB_FILENAME)
db.getDrunkSum,
"espresso", "lungo", "2010-10-20", "2020-10-20"
)
+
+ def test_all_mate_sum(self):
+ create_test_db(TESTDB_FILENAME)
+ try:
+ db = Db(TESTDB_FILENAME)
+ drunk = db.getDrunkSum(
+ "Club-Mate 0,5 l;Club-Mate 0,33 l",
+ self.lwstr,
+ self.tdystr
+ )
+ self.assertEqual(drunk, [
+ ("tester", 8),
+ ("newer", 2),
+ ("clone", 3),
+ ])
+ finally:
+ delete_test_db(TESTDB_FILENAME)
+
+ def test_all_mate_list(self):
+ create_test_db(TESTDB_FILENAME)
+ try:
+ db = Db(TESTDB_FILENAME)
+ drunk = db.getDrunkList(
+ "Club-Mate 0,5 l;Club-Mate 0,33 l",
+ self.lwstr,
+ self.tdystr
+ )
+ self.assertEqual(drunk, {
+ "tester": [4, 4],
+ "newer": [0, 2],
+ "clone": [1, 2],
+ })
+ finally:
+ delete_test_db(TESTDB_FILENAME)