summaryrefslogtreecommitdiff
path: root/src/frontend/gui/system.py
diff options
context:
space:
mode:
authorV3n3RiX <venerix@redcorelinux.org>2017-06-29 15:23:07 +0100
committerV3n3RiX <venerix@redcorelinux.org>2017-06-29 15:23:07 +0100
commita376cafe07b319d0e7f71a7cdc4583eececa9561 (patch)
tree818bf4fb188f9bcd6b36e3aff1a8c02962ca1b29 /src/frontend/gui/system.py
parentc9dce560d1b0d6fe06ef8bf525a5b4a19437480a (diff)
populate each category with at least 2 apps
Diffstat (limited to 'src/frontend/gui/system.py')
-rwxr-xr-xsrc/frontend/gui/system.py16
1 files changed, 15 insertions, 1 deletions
diff --git a/src/frontend/gui/system.py b/src/frontend/gui/system.py
index f8cc428..d3ccbe9 100755
--- a/src/frontend/gui/system.py
+++ b/src/frontend/gui/system.py
@@ -37,7 +37,21 @@ class System(QtWidgets.QMainWindow):
def load_packages(self):
with sqlite3.connect('/var/lib/sisyphus/db/sisyphus.db') as db:
cursor=db.cursor()
- cursor.execute('''SELECT * from remote_packages''')
+ cursor.execute('''SELECT
+ a.category AS cat,
+ a.name AS pn,
+ a.version AS av,
+ i.version AS iv,
+ a.description AS descr
+ FROM remote_packages AS a
+ LEFT JOIN local_packages AS i
+ ON a.category = i.category
+ AND a.name = i.name
+ AND a.slot = i.slot
+ WHERE a.name IN
+ ('aqemu',
+ 'virtualbox')
+ ''')
rows = cursor.fetchall()
for row in rows: