diff options
| author | bionel <ionel.busuioc@gmail.com> | 2017-09-23 22:23:23 +0300 |
|---|---|---|
| committer | bionel <ionel.busuioc@gmail.com> | 2017-09-23 22:23:23 +0300 |
| commit | 6dfc06d59325fd2ea6eb83369268f21adba1cd80 (patch) | |
| tree | 2033745f70656cbd8d346ff04b8feb4a6dd5b0e8 /src/frontend | |
| parent | 3534bd6f81c1bd371344106e67c7ef0668afdf1e (diff) | |
remove virtuals from listed packages
Diffstat (limited to 'src/frontend')
| -rwxr-xr-x | src/frontend/gui/sisyphus-gui.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/frontend/gui/sisyphus-gui.py b/src/frontend/gui/sisyphus-gui.py index e0b112a..d27a171 100755 --- a/src/frontend/gui/sisyphus-gui.py +++ b/src/frontend/gui/sisyphus-gui.py @@ -96,6 +96,7 @@ class Sisyphus(QtWidgets.QMainWindow): def loadDatabase(self): with sqlite3.connect('/var/lib/sisyphus/db/sisyphus.db') as db: cursor=db.cursor() + filterOut = "'%" + "virtual" + "%'" cursor.execute('''SELECT a.category AS cat, a.name AS pn, @@ -108,7 +109,8 @@ class Sisyphus(QtWidgets.QMainWindow): AND a.name = i.name AND a.slot = i.slot WHERE %s LIKE %s %s - ''' % (Sisyphus.SEARCHFIELD, Sisyphus.SEARCHTERM, Sisyphus.SEARCHFILTER)) + AND cat NOT LIKE %s + ''' % (Sisyphus.SEARCHFIELD, Sisyphus.SEARCHTERM, Sisyphus.SEARCHFILTER, filterOut)) rows = cursor.fetchall() Sisyphus.PKGCOUNT = len(rows) Sisyphus.PKGSELECTED = 0 |