SELECT count(*), flavor
FROM coffees
- WHERE time BETWEEN
+ WHERE (coffees.time BETWEEN
datetime('now', 'localtime', '-7 days')
- AND datetime('now', 'localtime')
+ AND datetime('now', 'localtime'))
GROUP BY flavor
"""
LEFT JOIN identifiers on coffees.id = identifiers.userid
LEFT JOIN users on identifiers.userid = users.id
WHERE flavor = 'FOO'
- AND coffees.time BETWEEN
+ AND (coffees.time BETWEEN
datetime('now', 'localtime', '-7 days')
- AND datetime('now', 'localtime')
+ AND datetime('now', 'localtime'))
GROUP BY identifiers.userid
"""
LEFT JOIN identifiers on coffees.id = identifiers.userid
LEFT JOIN users on identifiers.userid = users.id
WHERE flavor = 'BAR'
- AND coffees.time BETWEEN
+ AND (coffees.time BETWEEN
datetime('FROM', 'localtime')
- AND datetime('TO', 'localtime')
+ AND datetime('TO', 'localtime'))
GROUP BY identifiers.userid
"""
SELECT count(*), users.name FROM coffees
LEFT JOIN identifiers on coffees.id = identifiers.userid
LEFT JOIN users on identifiers.userid = users.id
- WHERE flavor = 'FOO' OR flavor = 'BAR' OR flavor = 'B'
- AND coffees.time BETWEEN
+ WHERE (flavor = 'FOO' OR flavor = 'BAR' OR flavor = 'B')
+ AND (coffees.time BETWEEN
datetime('FROM', 'localtime')
- AND datetime('TO', 'localtime')
+ AND datetime('TO', 'localtime'))
GROUP BY identifiers.userid
"""
assert s == {"tester": [4, 4], "newer": [0, 2], "clone": [1, 2]}
def test_assert_error_raised_for_bad_number_of_arguments(self):
- self.assertRaises(AssertionError, self.db.get_drunk_sum)
- self.assertRaises(AssertionError, self.db.get_drunk_sum, "")
- self.assertRaises(AssertionError, self.db.get_drunk_sum, [])
- self.assertRaises(AssertionError, self.db.get_drunk_sum, "espresso")
+ self.assertRaises(TypeError, self.db.get_drunk_sum)
+ self.assertRaises(TypeError, self.db.get_drunk_sum, "")
+ self.assertRaises(TypeError, self.db.get_drunk_sum, [])
+ self.assertRaises(TypeError, self.db.get_drunk_sum, "espresso")
self.assertRaises(
- AssertionError,
+ TypeError,
self.db.get_drunk_sum,
"espresso",
"2010-10-20")
self.assertRaises(
- AssertionError,
+ TypeError,
self.db.get_drunk_sum,
"espresso",
"lungo",