X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=tests%2Fdbtest_timestamps.py;fp=tests%2Fdbtest_timestamps.py;h=1a53ae8665da5c9241370165bc5136c5926533a8;hb=d95cba5badefe3dc554fbbdad729cc315aa33092;hp=98642c419624b3f25a923d0ed85c2c40a2db2775;hpb=48fc809473bac1a5fba47b03a62f37d1fe9b571e;p=dak.git

diff --git a/tests/dbtest_timestamps.py b/tests/dbtest_timestamps.py
index 98642c41..1a53ae86 100755
--- a/tests/dbtest_timestamps.py
+++ b/tests/dbtest_timestamps.py
@@ -4,6 +4,7 @@ from db_test import DBDakTestCase
 
 from daklib.dbconn import DBConn, Uid
 
+from sqlalchemy import func
 import time
 import unittest
 
@@ -16,10 +17,13 @@ class TimestampTestCase(DBDakTestCase):
     """
 
     def now(self):
+        "returns the current time at the db server"
+
+        # we fetch a fresh session each time to avoid caching
         local_session = DBConn().session()
-        query = local_session.query('now').from_statement('select now() as now')
+        current_time = local_session.query(func.now()).scalar()
         local_session.close()
-        return query.first().now
+        return current_time
 
     def sleep(self):
         time.sleep(0.001)