From c3928ce9083a4e1049d13a6f82610d25c038d5b8 Mon Sep 17 00:00:00 2001
From: Sean Finney <seanius@debian.org>
Date: Wed, 3 Sep 2008 01:25:28 +0200
Subject: initial, slightly stupid, maintainer support in database

---
 db.sql                        | 4 +++-
 patchtracker/DB.py            | 6 +++---
 patchtracker/SourceArchive.py | 4 ++++
 3 files changed, 10 insertions(+), 4 deletions(-)

diff --git a/db.sql b/db.sql
index 20d8178..00438ec 100644
--- a/db.sql
+++ b/db.sql
@@ -9,7 +9,9 @@ CREATE TABLE packages (
   loc TEXT NOT NULL,
   diffgz_name TEXT DEFAULT NULL,
   diffgz_size INTEGER DEFAULT NULL,
-  diffgz_md5sum TEXT DEFAULT NULL
+  diffgz_md5sum TEXT DEFAULT NULL,
+  maintainer TEXT NOT NULL,
+  uploaders TEXT DEFAULT NULL
 );
 
 CREATE UNIQUE INDEX idx_pkg_name_version ON packages (name,version);
diff --git a/patchtracker/DB.py b/patchtracker/DB.py
index da0838a..082cce0 100644
--- a/patchtracker/DB.py
+++ b/patchtracker/DB.py
@@ -70,11 +70,11 @@ class PatchTrackerDB:
     cursor = self.db.cursor()
     #print "creating new record for",srcpkg
     q = "INSERT OR IGNORE INTO packages \
-           (name,format,loc,version,diffgz_name,diffgz_size,diffgz_md5sum) \
-           VALUES (?,?,?,?,?,?,?)"
+           (name,format,loc,version,diffgz_name,diffgz_size,diffgz_md5sum,maintainer,uploaders) \
+           VALUES (?,?,?,?,?,?,?,?,?)"
     cursor.execute(q, (srcpkg.name,srcpkg.format,srcpkg.loc,
                        srcpkg.version,srcpkg.diffgz_name,srcpkg.diffgz_size,
-                       srcpkg.diffgz_md5sum))
+                       srcpkg.diffgz_md5sum,srcpkg.maintainer,srcpkg.uploaders))
 
   def saveSuite(self, suite):
     q = "INSERT INTO suites (name) VALUES (?)"
diff --git a/patchtracker/SourceArchive.py b/patchtracker/SourceArchive.py
index 099b506..311587e 100755
--- a/patchtracker/SourceArchive.py
+++ b/patchtracker/SourceArchive.py
@@ -97,11 +97,15 @@ class SourcePackage:
     self.diffgz_size = None
     self.diffgz_md5sum = None
     self.diffgz = None
+    self.uploaders = None
     self.type = "Native"
     self.name = info['Package']  
     self.format = info['Format']  
     self.loc = info['Directory']  
     self.version = info['Version']  
+    self.maintainer = info['Maintainer']  
+    if info.has_key('Uploaders'):
+      self.uploaders = info['Uploaders']  
     self.idx = getidx(self)
 
     for f in info['Files']:
-- 
cgit v1.2.3