diff options
| author | V3n3RiX <venerix@redcorelinux.org> | 2017-09-23 21:42:49 +0100 |
|---|---|---|
| committer | V3n3RiX <venerix@redcorelinux.org> | 2017-09-23 21:42:49 +0100 |
| commit | 67c89253f7e7b3d2351121ba4a95d5ddda84f3da (patch) | |
| tree | ee9062fa38b27a3183f5995f5d306112951c744c /src/frontend/gui/sisyphus-gui.py | |
| parent | eae58edf21609562f2a5fe4d67dd47abdf20e800 (diff) | |
| parent | 9b0024e4aaa7dab7a60e2b8689af5c70bd0a9f2d (diff) | |
Merge branch 'master' of gitlab.com:redcore/sisyphus
Diffstat (limited to 'src/frontend/gui/sisyphus-gui.py')
| -rwxr-xr-x | src/frontend/gui/sisyphus-gui.py | 5 |
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) |