server/test/unittest_querier.py
changeset 7907 08320697ca1a
parent 7791 31bb51ea5485
parent 7904 f41bb38dda7c
child 8002 822a8150f78d
equal deleted inserted replaced
7906:203d574c8a1d 7907:08320697ca1a
   441 
   441 
   442     def test_select_date_extraction(self):
   442     def test_select_date_extraction(self):
   443         self.execute("INSERT Personne X: X nom 'foo', X datenaiss %(d)s",
   443         self.execute("INSERT Personne X: X nom 'foo', X datenaiss %(d)s",
   444                      {'d': datetime(2001, 2,3, 12,13)})
   444                      {'d': datetime(2001, 2,3, 12,13)})
   445         test_data = [('YEAR', 2001), ('MONTH', 2), ('DAY', 3),
   445         test_data = [('YEAR', 2001), ('MONTH', 2), ('DAY', 3),
   446                      ('HOUR', 12), ('MINUTE', 13)]
   446                      ('HOUR', 12), ('MINUTE', 13), ('WEEKDAY', 6)]
   447         for funcname, result in test_data:
   447         for funcname, result in test_data:
   448             rset = self.execute('Any %s(D) WHERE X is Personne, X datenaiss D'
   448             rset = self.execute('Any %s(D) WHERE X is Personne, X datenaiss D'
   449                                 % funcname)
   449                                 % funcname)
   450             self.assertEqual(len(rset.rows), 1)
   450             self.assertEqual(len(rset.rows), 1)
   451             self.assertEqual(rset.rows[0][0], result)
   451             self.assertEqual(rset.rows[0][0], result)