diff options
Diffstat (limited to 'src/acit/types.py')
| -rw-r--r-- | src/acit/types.py | 29 |
1 files changed, 20 insertions, 9 deletions
diff --git a/src/acit/types.py b/src/acit/types.py index fd9d20a..3d41297 100644 --- a/src/acit/types.py +++ b/src/acit/types.py @@ -47,11 +47,21 @@ class Site(): ")" ) - #cur.execute( - # "CREATE TABLE IF NOT EXISTS accounts (" - # "email VARCHAR(80)," - # "hash VARCHAR(80)," - # )# TODO + cur.execute( + "CREATE TABLE IF NOT EXISTS permissiontable (" + "email VARCHAR(80)," + "tracker VARCHAR(80)," + "bugid INT)" + ) + + cur.execute( + "CREATE TABLE IF NOT EXISTS tokens (" + "email VARCHAR(80)," + "token VARCHAR(80)," + "tracker VARCHAR(80)," + "bugid INT," + "usedin TINYTEXT DEFAULT NULL)" + ) conn.commit() @@ -104,12 +114,13 @@ class Site(): name,homepage=data - log(name) + #log(name) cur.execute("REPLACE INTO trackers (name,homepage) VALUES (?,?)",(name,homepage)) conn.commit() - self.update_all_bugpages(conn,cur,trackerfilter=name) + #self.update_all_bugpages(conn,cur,trackerfilter=name) + cherrypy.engine.publish("regen",name,None) self.last_tracker_update=datetime.now() @@ -346,7 +357,7 @@ class Tracker(): NOTE: this executes an SQL query. """ with self.site.dbpool.get_connection() as conn, conn.cursor() as cur: - cur.execute("SELECT email FROM subscribers WHERE tracker=? AND bugid=NULL",(self.tracker,)) + cur.execute("SELECT email FROM subscribers WHERE tracker=? AND bugid IS NULL",(self.tracker,)) return [ value[0] for value in cur ] def addsubscriber(self,email): @@ -356,6 +367,6 @@ class Tracker(): def rmsubscriber(self,email): with self.site.dbpool.get_connection() as conn, conn.cursor() as cur: - cur.execute("DELETE FROM subscribers WHERE tracker=? AND bugid=NULL AND email=?)",(self.tracker,email)) + cur.execute("DELETE FROM subscribers WHERE tracker=? AND bugid IS NULL AND email=?)",(self.tracker,email)) conn.commit() |