diff options
Diffstat (limited to 'frontend/gui/games.py')
-rwxr-xr-x | frontend/gui/games.py | 77 |
1 files changed, 0 insertions, 77 deletions
diff --git a/frontend/gui/games.py b/frontend/gui/games.py deleted file mode 100755 index 5eed9fa..0000000 --- a/frontend/gui/games.py +++ /dev/null @@ -1,77 +0,0 @@ -#!/usr/bin/python3 -import sys, subprocess, sqlite3 -from PyQt5 import QtCore, QtGui, QtWidgets, uic - -class Games(QtWidgets.QMainWindow): - def __init__(self): - super(Games, self).__init__() - uic.loadUi('ui/games.ui', self) - self.centerOnScreen() - self.show() - self.load_packages() - - self.package_install.clicked.connect(self.install_package) - self.package_uninstall.clicked.connect(self.uninstall_package) - self.orphans_remove.clicked.connect(self.remove_orphans) - self.category_exit.clicked.connect(self.exit_category) - - def centerOnScreen(self): - resolution = QtWidgets.QDesktopWidget().screenGeometry() - self.move((resolution.width() / 2) - (self.frameSize().width() / 2), - (resolution.height() / 2) - (self.frameSize().height() / 2)) - - def install_package(self): - pkgname = self.table_games.item(self.table_games.currentRow(), 1).text() - subprocess.Popen(['xterm', '-e', 'sisyphus', 'auto-install'] + pkgname.split()) - - def uninstall_package(self): - pkgname = self.table_games.item(self.table_games.currentRow(), 1).text() - subprocess.Popen(['xterm', '-e', 'sisyphus', 'auto-uninstall'] + pkgname.split()) - - def remove_orphans(self): - subprocess.Popen(['xterm', '-e', 'sisyphus', 'remove-orphans']) - - def exit_category(self): - self.close() - - def load_packages(self): - with sqlite3.connect('/var/lib/sisyphus/db/sisyphus.db') as db: - cursor=db.cursor() - cursor.execute('''SELECT - a.category AS cat, - a.name AS pn, - a.version AS av, - i.version AS iv, - a.description AS descr - FROM remote_packages AS a - LEFT JOIN local_packages AS i - ON a.category = i.category - AND a.name = i.name - AND a.slot = i.slot - WHERE a.name IN - ('steam', - 'playonlinux', - 'armagetronad', - 'chromium-bsu', - 'supertuxkart', - 'teeworlds', - 'dosbox', - 'snes9x', - 'zsnes', - 'urbanterror', - 'openttd', - '0ad', - 'warzone2100', - 'wesnoth', - 'xonotic') - ''') - rows = cursor.fetchall() - - for row in rows: - inx = rows.index(row) - self.table_games.insertRow(inx) - self.table_games.setItem(inx, 0, QtWidgets.QTableWidgetItem(row[0])) - self.table_games.setItem(inx, 1, QtWidgets.QTableWidgetItem(row[1])) - self.table_games.setItem(inx, 2, QtWidgets.QTableWidgetItem(row[2])) - self.table_games.setItem(inx, 3, QtWidgets.QTableWidgetItem(row[3])) - self.table_games.setItem(inx, 4, QtWidgets.QTableWidgetItem(row[4])) |