From bc02c657543a7d2be99ffbec9d002d698941f56f Mon Sep 17 00:00:00 2001 From: V3n3RiX Date: Mon, 12 Jun 2017 02:41:32 +0100 Subject: merge epkg into sisyphus : from now on sisyphus-cli will be the CLI frontend (old epkg) && sisyphus-gui will be the GUI frontend ;; the backend libsisyphus.sh will be ported to python as well --- frontend/gui/everything.py | 61 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 61 insertions(+) create mode 100755 frontend/gui/everything.py (limited to 'frontend/gui/everything.py') diff --git a/frontend/gui/everything.py b/frontend/gui/everything.py new file mode 100755 index 0000000..e6b874b --- /dev/null +++ b/frontend/gui/everything.py @@ -0,0 +1,61 @@ +#!/usr/bin/python3 +import sys, subprocess, sqlite3 +from PyQt5 import QtCore, QtGui, QtWidgets, uic + +class Everything(QtWidgets.QMainWindow): + def __init__(self): + super(Everything, self).__init__() + uic.loadUi('ui/everything.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_everything.item(self.table_everything.currentRow(), 1).text() + subprocess.Popen(['xterm', '-e', 'sisyphus', 'autoinstall'] + pkgname.split()) + + def uninstall_package(self): + pkgname = self.table_everything.item(self.table_everything.currentRow(), 1).text() + subprocess.Popen(['xterm', '-e', 'sisyphus', 'autoremove'] + pkgname.split()) + + def remove_orphans(self): + subprocess.Popen(['xterm', '-e', 'sisyphus', 'autoclean']) + + 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 + ''') + rows = cursor.fetchall() + + for row in rows: + inx = rows.index(row) + self.table_everything.insertRow(inx) + self.table_everything.setItem(inx, 0, QtWidgets.QTableWidgetItem(row[0])) + self.table_everything.setItem(inx, 1, QtWidgets.QTableWidgetItem(row[1])) + self.table_everything.setItem(inx, 2, QtWidgets.QTableWidgetItem(row[2])) + self.table_everything.setItem(inx, 3, QtWidgets.QTableWidgetItem(row[3])) + self.table_everything.setItem(inx, 4, QtWidgets.QTableWidgetItem(row[4])) -- cgit v1.2.3