Solve several minor problems at once by storing timestamps as seconds-since-epoch.

svn path=/trunk/; revision=5933

1 files changed, 2 insertions, 2 deletions

diff --git a/potpourri/validation-status-sql.py b/potpourri/validation-status-sql.py
index 81d79b48..9e68d4ba 100755
--- a/potpourri/validation-status-sql.py
+++ b/potpourri/validation-status-sql.py
@@ -132,10 +132,10 @@ class Parser(object):
       return
     xml = self.read_xml()
     with self.db:
-      session_id = self.db.execute("INSERT INTO sessions (session, handle) VALUES (datetime(?), ?)",
+      session_id = self.db.execute("INSERT INTO sessions (session, handle) VALUES (strftime('%s', ?), ?)",
                                    (xml.get("date"), self.handle)).lastrowid
       self.db.executemany("INSERT INTO events (session_id, timestamp, generation_id, code_id, uri_id) "
-                          "VALUES (?, datetime(?), ?, ?, ?)",
+                          "VALUES (?, strftime('%s', ?), ?, ?, ?)",
                           ((session_id,
                             x.get("timestamp"),
                             self.string_id("generations", x.get("generation")),