From c694c9621c9d551e800eae8a16fa169ae3cf7991 Mon Sep 17 00:00:00 2001 From: Holger Levsen Date: Fri, 12 Oct 2012 17:14:31 +0200 Subject: [PATCH] Revert "fixup" This reverts commit 9da44d5dc3609082fa384f50e482583e211bafa0. --- db_add.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/db_add.py b/db_add.py index e498b7c..934668b 100755 --- a/db_add.py +++ b/db_add.py @@ -48,11 +48,11 @@ def db_update_build(con, db_id, end, status): cur = con.cursor() cur.execute("SAVEPOINT a") try: - cur.execute("UPDATE jenkins_build SET build_end = '%s', status = '%s' WHERE id = %s RETURNING id" % (end, status, db_id)) + cur.execute("UPDATE jenkins_build SET build_end = to_timestamp('%s'), status = '%s' WHERE id = %s RETURNING id" % (end, status, db_id)) con.commit() except psycopg2.DatabaseError as e: cur.execute("ROLLBACK TO a") # have to rollback after failed command - logger.debug("UPDATE jenkins_build SET build_end = '%s', status = '%s' WHERE id = %s RETURNING id" % (end, status, db_id)) + logger.debug("UPDATE jenkins_build SET build_end = to_timestamp('%s'), status = '%s' WHERE id = %s RETURNING id" % (end, status, db_id)) return cur.fetchone()[0] def db_add_origin(con, origin): -- 2.39.5