From bdf5cb78b9d7daf702e0e05660580ab311473fdc Mon Sep 17 00:00:00 2001
From: SoniEx2 <endermoneymod@gmail.com>
Date: Thu, 23 Jul 2020 13:15:56 -0300
Subject: Restore functionality

Everything works again, as far as I can tell.
---
 ganarchy/db.py | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'ganarchy/db.py')

diff --git a/ganarchy/db.py b/ganarchy/db.py
index 37509a5..328b682 100644
--- a/ganarchy/db.py
+++ b/ganarchy/db.py
@@ -160,7 +160,7 @@ class Database:
         c = self.conn.cursor()
         c.execute('''
             CREATE TEMPORARY TABLE "repos" (
-                "url" TEXT PRIMARY KEY,
+                "url" TEXT,
                 "active" INT,
                 "branch" TEXT,
                 "project" TEXT
@@ -222,7 +222,7 @@ class Database:
             ''',
             activities
         )
-        conn.commit()
+        self.conn.commit()
         c.close()
 
     def list_projects(self):
@@ -282,7 +282,7 @@ class Database:
                         FROM "repos" "T3"
                         WHERE "active" AND "project" IS ?1
                     )
-                    GROUP BY "url"
+                    GROUP BY "url", "branch"
                     ORDER BY "e"
                 ''',
                 (project_commit,)
@@ -313,7 +313,7 @@ class Database:
                     AND "project" IS ?
                 ORDER BY "entry" ASC
             ''',
-            (url, branch, project)
+            (uri, branch, project_commit)
         ).fetchall()
         history = [x for [x] in history]
         c.close()
-- 
cgit 1.4.1