From 63c933922c2a89f7612fabc7fc96a3c5ae359556 Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Mon, 25 Aug 2014 04:48:26 +0000 Subject: Solve several minor problems at once by storing timestamps as seconds-since-epoch. svn path=/trunk/; revision=5933 --- potpourri/validation-status-sql.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'potpourri/validation-status-sql.py') 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")), -- cgit v1.2.3