summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorbionel <ionel.busuioc@gmail.com>2017-09-23 22:23:23 +0300
committerbionel <ionel.busuioc@gmail.com>2017-09-23 22:23:23 +0300
commit6dfc06d59325fd2ea6eb83369268f21adba1cd80 (patch)
tree2033745f70656cbd8d346ff04b8feb4a6dd5b0e8 /src
parent3534bd6f81c1bd371344106e67c7ef0668afdf1e (diff)
remove virtuals from listed packages
Diffstat (limited to 'src')
-rwxr-xr-xsrc/frontend/gui/sisyphus-gui.py4
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