server/test/unittest_postgres.py
changeset 11034 75d752e6daf7
parent 10812 a747e211266b
--- a/server/test/unittest_postgres.py	Fri Dec 18 09:23:23 2015 +0100
+++ b/server/test/unittest_postgres.py	Tue Dec 22 15:35:10 2015 +0100
@@ -127,20 +127,22 @@
                                              'WHERE X has_text "cubicweb"').rows,
                                   [[c1.eid,], [c3.eid,], [c2.eid,]])
 
-
     def test_tz_datetime(self):
         with self.admin_access.repo_cnx() as cnx:
-            cnx.execute("INSERT Personne X: X nom 'bob', X tzdatenaiss %(date)s",
-                        {'date': datetime(1977, 6, 7, 2, 0, tzinfo=FixedOffset(1))})
+            bob = cnx.create_entity('Personne', nom=u'bob',
+                                   tzdatenaiss=datetime(1977, 6, 7, 2, 0, tzinfo=FixedOffset(1)))
             datenaiss = cnx.execute("Any XD WHERE X nom 'bob', X tzdatenaiss XD")[0][0]
-            self.assertEqual(datenaiss.tzinfo, None)
+            self.assertIsNotNone(datenaiss.tzinfo)
             self.assertEqual(datenaiss.utctimetuple()[:5], (1977, 6, 7, 1, 0))
             cnx.commit()
-            cnx.execute("INSERT Personne X: X nom 'boby', X tzdatenaiss %(date)s",
-                        {'date': datetime(1977, 6, 7, 2, 0)})
+            cnx.create_entity('Personne', nom=u'boby',
+                              tzdatenaiss=datetime(1977, 6, 7, 2, 0))
             datenaiss = cnx.execute("Any XD WHERE X nom 'boby', X tzdatenaiss XD")[0][0]
-            self.assertEqual(datenaiss.tzinfo, None)
+            self.assertIsNotNone(datenaiss.tzinfo)
             self.assertEqual(datenaiss.utctimetuple()[:5], (1977, 6, 7, 2, 0))
+            rset = cnx.execute("Any X WHERE X tzdatenaiss %(d)s",
+                               {'d': datetime(1977, 6, 7, 2, 0, tzinfo=FixedOffset(1))})
+            self.assertEqual(rset.rows, [[bob.eid]])
 
     def test_constraint_validationerror(self):
         with self.admin_access.repo_cnx() as cnx: