845 self.qexecute("INSERT Tag Y: Y name 'toto'") |
845 self.qexecute("INSERT Tag Y: Y name 'toto'") |
846 rset = self.qexecute("Any D WHERE X name in ('bidule', 'toto') , X creation_date D") |
846 rset = self.qexecute("Any D WHERE X name in ('bidule', 'toto') , X creation_date D") |
847 self.assertIsInstance(rset.rows[0][0], datetime) |
847 self.assertIsInstance(rset.rows[0][0], datetime) |
848 rset = self.qexecute('Tag X WHERE X creation_date TODAY') |
848 rset = self.qexecute('Tag X WHERE X creation_date TODAY') |
849 self.assertEqual(len(rset.rows), 2) |
849 self.assertEqual(len(rset.rows), 2) |
850 rset = self.qexecute('Any MAX(D) WHERE X is Tag, X creation_date D') |
850 |
|
851 def test_sqlite_patch(self): |
|
852 """this test monkey patch done by sqlutils._install_sqlite_querier_patch""" |
|
853 self.qexecute("INSERT Personne X: X nom 'bidule', X datenaiss NOW, X tzdatenaiss NOW") |
|
854 rset = self.qexecute('Any MAX(D) WHERE X is Personne, X datenaiss D') |
|
855 self.assertIsInstance(rset[0][0], datetime) |
|
856 rset = self.qexecute('Any MAX(D) WHERE X is Personne, X tzdatenaiss D') |
851 self.assertIsInstance(rset[0][0], datetime) |
857 self.assertIsInstance(rset[0][0], datetime) |
852 |
858 |
853 def test_today(self): |
859 def test_today(self): |
854 self.qexecute("INSERT Tag X: X name 'bidule', X creation_date TODAY") |
860 self.qexecute("INSERT Tag X: X name 'bidule', X creation_date TODAY") |
855 self.qexecute("INSERT Tag Y: Y name 'toto'") |
861 self.qexecute("INSERT Tag Y: Y name 'toto'") |