From a09a21d956c747d0479eab11c50b5988d9053faa Mon Sep 17 00:00:00 2001 From: V3n3RiX Date: Sun, 9 Jul 2017 13:22:03 +0100 Subject: drop categories, list all available packages by default, redesign UI --- src/frontend/gui/office.py | 76 ---------------------------------------------- 1 file changed, 76 deletions(-) delete mode 100755 src/frontend/gui/office.py (limited to 'src/frontend/gui/office.py') diff --git a/src/frontend/gui/office.py b/src/frontend/gui/office.py deleted file mode 100755 index 86c9e74..0000000 --- a/src/frontend/gui/office.py +++ /dev/null @@ -1,76 +0,0 @@ -#!/usr/bin/python3 -import sys, subprocess, sqlite3 -from PyQt5 import QtCore, QtGui, QtWidgets, uic - -class Office(QtWidgets.QMainWindow): - def __init__(self): - super(Office, self).__init__() - uic.loadUi('ui/office.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_office.item(self.table_office.currentRow(), 1).text() - subprocess.Popen(['xterm', '-e', 'sisyphus', 'auto-install'] + pkgname.split()) - - def uninstall_package(self): - pkgname = self.table_office.item(self.table_office.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 - ('fet', - 'libreoffice', - 'wps-office', - 'tesseract', - 'okular', - 'qpdfview', - 'cups', - 'cups-filters', - 'cups-pdf', - 'simple-scan', - 'cnijfilter', - 'cnijfilter-drivers', - 'hplip', - 'xsane') - ''') - rows = cursor.fetchall() - - for row in rows: - inx = rows.index(row) - self.table_office.insertRow(inx) - self.table_office.setItem(inx, 0, QtWidgets.QTableWidgetItem(row[0])) - self.table_office.setItem(inx, 1, QtWidgets.QTableWidgetItem(row[1])) - self.table_office.setItem(inx, 2, QtWidgets.QTableWidgetItem(row[2])) - self.table_office.setItem(inx, 3, QtWidgets.QTableWidgetItem(row[3])) - self.table_office.setItem(inx, 4, QtWidgets.QTableWidgetItem(row[4])) -- cgit v1.2.3