| 210 | print "pattern.db.stdev()" |
| 211 | |
| 212 | def test_sqlite_functions(self): |
| 213 | # Assert year(), month(), day(), ..., first(), last() and group_concat() for SQLite. |
| 214 | v = "1707-04-15 01:02:03" |
| 215 | self.assertEqual(db.sqlite_year(v), 1707) |
| 216 | self.assertEqual(db.sqlite_month(v), 4) |
| 217 | self.assertEqual(db.sqlite_day(v), 15) |
| 218 | self.assertEqual(db.sqlite_hour(v), 1) |
| 219 | self.assertEqual(db.sqlite_minute(v), 2) |
| 220 | self.assertEqual(db.sqlite_second(v), 3) |
| 221 | # Aggregate functions. |
| 222 | for f, a, b in ( |
| 223 | (db.sqlite_first, [1,2,3], 1), |
| 224 | (db.sqlite_last, [1,2,3], 3), |
| 225 | (db.sqlite_group_concat, [1,2,3], "1,2,3")): |
| 226 | f = f() |
| 227 | for x in a: |
| 228 | f.step(x) |
| 229 | self.assertEqual(f.finalize(), b) |
| 230 | print "pattern.db.sqlite_year()" |
| 231 | print "pattern.db.sqlite_month()" |
| 232 | print "pattern.db.sqlite_day()" |
| 233 | print "pattern.db.sqlite_hour()" |
| 234 | print "pattern.db.sqlite_minute()" |
| 235 | print "pattern.db.sqlite_second()" |
| 236 | print "pattern.db.sqlite_first()" |
| 237 | print "pattern.db.sqlite_last()" |
| 238 | print "pattern.db.sqlite_group_concat()" |
| 239 | |
| 240 | #--------------------------------------------------------------------------------------------------- |
| 241 | |