summaryrefslogtreecommitdiff
path: root/everything.py
diff options
context:
space:
mode:
Diffstat (limited to 'everything.py')
-rwxr-xr-xeverything.py61
1 files changed, 0 insertions, 61 deletions
diff --git a/everything.py b/everything.py
deleted file mode 100755
index 2137525..0000000
--- a/everything.py
+++ /dev/null
@@ -1,61 +0,0 @@
-#!/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', 'epkg', 'autoinstall'] + pkgname.split())
-
- def uninstall_package(self):
- pkgname = self.table_everything.item(self.table_everything.currentRow(), 1).text()
- subprocess.Popen(['xterm', '-e', 'epkg', 'autoremove'] + pkgname.split())
-
- def remove_orphans(self):
- subprocess.Popen(['xterm', '-e', 'epkg', 'autoclean'])
-
- def exit_category(self):
- self.close()
-
- def load_packages(self):
- with sqlite3.connect('/var/lib/epkg/db/epkg.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]))