diff options
| -rwxr-xr-x | potpourri/validation-status-sql.py | 4 |
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")), |