summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorV3n3RiX <venerix@redcorelinux.org>2017-09-23 21:42:49 +0100
committerV3n3RiX <venerix@redcorelinux.org>2017-09-23 21:42:49 +0100
commit67c89253f7e7b3d2351121ba4a95d5ddda84f3da (patch)
treeee9062fa38b27a3183f5995f5d306112951c744c /src
parenteae58edf21609562f2a5fe4d67dd47abdf20e800 (diff)
parent9b0024e4aaa7dab7a60e2b8689af5c70bd0a9f2d (diff)
Merge branch 'master' of gitlab.com:redcore/sisyphus
Diffstat (limited to 'src')
-rwxr-xr-xsrc/frontend/gui/sisyphus-gui.py5
1 files changed, 2 insertions, 3 deletions
diff --git a/src/frontend/gui/sisyphus-gui.py b/src/frontend/gui/sisyphus-gui.py
index 7f41589..1de49c8 100755
--- a/src/frontend/gui/sisyphus-gui.py
+++ b/src/frontend/gui/sisyphus-gui.py
@@ -95,7 +95,7 @@ class Sisyphus(QtWidgets.QMainWindow):
def loadDatabase(self):
with sqlite3.connect(sisyphus_database_path) as db:
cursor=db.cursor()
- FILTEROUT = "'%" + "virtual" + "%'"
+ FILTEROUT = "AND cat NOT LIKE 'virtual'"
cursor.execute('''SELECT
a.category AS cat,
a.name AS pn,
@@ -107,8 +107,7 @@ class Sisyphus(QtWidgets.QMainWindow):
ON a.category = i.category
AND a.name = i.name
AND a.slot = i.slot
- WHERE %s LIKE %s %s
- AND cat NOT LIKE %s
+ WHERE %s LIKE %s %s %s
''' % (Sisyphus.SEARCHFIELD, Sisyphus.SEARCHTERM, Sisyphus.SEARCHFILTER, FILTEROUT))
rows = cursor.fetchall()
Sisyphus.PKGCOUNT = len(rows)