From 39f1a32d93adef18e47ac9cb432d655bda60bb96 Mon Sep 17 00:00:00 2001 From: Nicolas Vigier Date: Fri, 10 Feb 2012 21:14:23 +0000 Subject: add sql file to create youridb --- create-srpm | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'create-srpm') diff --git a/create-srpm b/create-srpm index b49972d..837c776 100755 --- a/create-srpm +++ b/create-srpm @@ -30,7 +30,7 @@ class youridb: dbpasswd = config.get("youridb", "dbpasswd") dbhost = config.get("youridb", "dbhost") sslmode = 1 - self.db = psycopg2.connect(dbname=dbname, user=dbuser, + self.db = psycopg2.connect(database=dbname, user=dbuser, password=dbpasswd, host=dbhost) def add(self, srpm, url, revision, packager): @@ -39,8 +39,8 @@ class youridb: rpmEVR = rpmhdr[rpm.RPMTAG_EVR] rpmsha1 = file_hash(srpm) cur = self.db.cursor() - cur.execute("INSERT INTO submits (sha1, rpmname, EVR, packager, url, revision, status) VALUES (%s, %s, %s, %s, %s, %s, %s);", - (rpmsha1, rpmname, rpmEVR, packager, url, revision, 'create-srpm')) + cur.execute("INSERT INTO submits (sha1, rpmname, EVR, packager, url, revision, status, submit_ts) VALUES (%s, %s, %s, %s, %s, %s, %s, CURRENT_TIMESTAMP);", + (rpmsha1, rpmname, rpmEVR, packager, url, revision, '1')) cur.close() self.db.commit() @@ -58,7 +58,7 @@ class CmdIface: try: db = youridb() except Exception, e: - print e.pgerror + print 'youridb error:', e return 0 pw = pwd.getpwuid(os.getuid()) username = pw[0] -- cgit v1.2.1