From cc6bdb0e4844ba2eb02688f85368c5c949cf0e62 Mon Sep 17 00:00:00 2001 From: V3n3RiX Date: Wed, 26 Oct 2022 14:05:06 +0100 Subject: fix variables in syncDatabase --- src/backend/syncDatabase.py | 6 +++--- src/frontend/gui/sisyphus-gui.py | 22 +++++++++++++++++++--- 2 files changed, 22 insertions(+), 6 deletions(-) diff --git a/src/backend/syncDatabase.py b/src/backend/syncDatabase.py index e70a75c..1823847 100644 --- a/src/backend/syncDatabase.py +++ b/src/backend/syncDatabase.py @@ -9,13 +9,13 @@ import sisyphus.getEnvironment import sisyphus.getFilesystem def remoteCSV(): - packagesCsvURL,descriptionCsvURL = sisyphus.getEnvironment.csvURL() + packagesCsvURL,descriptionsCsvURL = sisyphus.getEnvironment.csvURL() http = urllib3.PoolManager() - with http.request('GET', isPackageCsv, preload_content=False) as tmp_buffer, open(sisyphus.getFilesystem.remotePackagesCsv, 'wb') as output_file: + with http.request('GET', packagesCsvURL, preload_content=False) as tmp_buffer, open(sisyphus.getFilesystem.remotePackagesCsv, 'wb') as output_file: shutil.copyfileobj(tmp_buffer, output_file) - with http.request('GET', isDescriptionCsv, preload_content=False) as tmp_buffer, open(sisyphus.getFilesystem.remoteDescriptionsCsv, 'wb') as output_file: + with http.request('GET', descriptionsCsvURL, preload_content=False) as tmp_buffer, open(sisyphus.getFilesystem.remoteDescriptionsCsv, 'wb') as output_file: shutil.copyfileobj(tmp_buffer, output_file) def localCSV(): 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, -- cgit v1.2.3