3 from db_test import DBDakTestCase
5 from daklib.dbconn import DBConn, Uid
10 class TimestampTestCase(DBDakTestCase):
12 TimestampTestCase checks that the timestamps created and modified are
15 TODO: Should we check all tables?
19 local_session = DBConn().session()
20 query = local_session.query('now').from_statement('select now() as now')
22 return query.first().now
27 def test_timestamps(self):
28 timestamp01 = self.now()
30 uid = Uid(uid = 'ftp-master@debian.org')
33 created01 = uid.created
34 modified01 = uid.modified
36 timestamp02 = self.now()
37 self.assertTrue(timestamp01 < created01)
38 self.assertTrue(timestamp01 < modified01)
39 self.assertTrue(created01 < timestamp02)
40 self.assertTrue(modified01 < timestamp02)
44 created02 = uid.created
45 modified02 = uid.modified
46 self.assertEqual(created01, created02)
47 self.assertTrue(modified01 < modified02)
49 timestamp03 = self.now()
50 self.assertTrue(modified02 < timestamp03)
52 def classes_to_clean(self):
55 if __name__ == '__main__':