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 ++++---- youridb.sql | 1 + 2 files changed, 5 insertions(+), 4 deletions(-) create mode 100644 youridb.sql 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] diff --git a/youridb.sql b/youridb.sql new file mode 100644 index 0000000..bef94ce --- /dev/null +++ b/youridb.sql @@ -0,0 +1 @@ +CREATE TABLE submits ( sha1 character(40), rpmname varchar(512), EVR varchar(100), packager varchar(100), url varchar(512), revision integer, status integer, submit_ts timestamp with time zone ); -- cgit v1.2.1