diff options
| author | V3n3RiX <venerix@koprulu.sector> | 2022-10-26 14:05:06 +0100 |
|---|---|---|
| committer | V3n3RiX <venerix@koprulu.sector> | 2022-10-26 14:05:06 +0100 |
| commit | cc6bdb0e4844ba2eb02688f85368c5c949cf0e62 (patch) | |
| tree | f47bc2837bf1c7383193bda32c56718c3fe3a9c6 /src/frontend/gui/sisyphus-gui.py | |
| parent | db3be7eb3ec5096e279e49bd87dd61c250635735 (diff) | |
fix variables in syncDatabase
Diffstat (limited to 'src/frontend/gui/sisyphus-gui.py')
| -rw-r--r-- | src/frontend/gui/sisyphus-gui.py | 22 |
1 files changed, 19 insertions, 3 deletions
diff --git a/src/frontend/gui/sisyphus-gui.py b/src/frontend/gui/sisyphus-gui.py index c7c16ff..5b798c3 100644 --- a/src/frontend/gui/sisyphus-gui.py +++ b/src/frontend/gui/sisyphus-gui.py @@ -27,7 +27,8 @@ class Sisyphus(QtWidgets.QMainWindow): self.filterDatabases = OrderedDict([ ('all packages', 'all'), ('installed packages', 'installed'), - ('available packages', 'installable'), + ('alien packages', 'alien'), + ('available packages', 'available'), ('upgradable packages', 'upgradable') ]) self.databaseFilter.addItems(self.filterDatabases.keys()) @@ -129,7 +130,7 @@ class Sisyphus(QtWidgets.QMainWindow): i.category AS cat, i.name as pn, i.version as iv, - IFNULL(a.version, 'None') AS av, + IFNULL(a.version, 'alien') AS av, d.description AS descr FROM local_packages AS i LEFT OUTER JOIN remote_packages as a ON i.category = a.category @@ -165,7 +166,22 @@ class Sisyphus(QtWidgets.QMainWindow): LEFT JOIN remote_descriptions AS d ON i.name = d.name AND i.category = d.category WHERE %s LIKE %s %s ''' % (Sisyphus.applicationView, Sisyphus.searchTerm, noVirtual)), - ('installable', '''SELECT + ('alien', '''SELECT + i.category AS cat, + i.name AS pn, + i.version as iv, + IFNULL(a.version, 'alien') AS av, + d.description AS desc + FROM local_packages AS i + LEFT JOIN remote_packages AS a + ON a.category = i.category + AND a.name = i.name + AND a.slot = i.slot + LEFT JOIN remote_descriptions AS d ON i.name = d.name AND i.category = d.category + WHERE %s LIKE %s %s + AND av IS 'alien' + ''' % (Sisyphus.applicationView, Sisyphus.searchTerm, noVirtual)), + ('available', '''SELECT a.category AS cat, a.name AS pn, i.version as iv, |