summaryrefslogtreecommitdiff
path: root/internet.py
diff options
context:
space:
mode:
Diffstat (limited to 'internet.py')
-rwxr-xr-xinternet.py99
1 files changed, 0 insertions, 99 deletions
diff --git a/internet.py b/internet.py
deleted file mode 100755
index 57ecb29..0000000
--- a/internet.py
+++ /dev/null
@@ -1,99 +0,0 @@
-#!/usr/bin/python3
-import sys, subprocess, sqlite3
-from PyQt5 import QtCore, QtGui, QtWidgets, uic
-
-class Internet(QtWidgets.QMainWindow):
- def __init__(self):
- super(Internet, self).__init__()
- uic.loadUi('ui/internet.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_internet.item(self.table_internet.currentRow(), 1).text()
- subprocess.Popen(['xterm', '-e', 'epkg', 'autoinstall'] + pkgname.split())
-
- def uninstall_package(self):
- pkgname = self.table_internet.item(self.table_internet.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
- WHERE a.name IN
- ('firewalld',
- 'ufw',
- 'ufw-frontends',
- 'cifs-utils',
- 'samba',
- 'sshfs',
- 'filezilla',
- 'franz',
- 'qtox',
- 'telegram',
- 'viber',
- 'konversation',
- 'quassel',
- 'aria2',
- 'dropbox',
- 'megasync',
- 'owncloud-client',
- 'teamviewer',
- 'telnet-bsd',
- 'tigervnc',
- 'youtube-dl',
- 'quiterss',
- 'qbittorrent',
- 'transmission',
- 'firefox',
- 'google-chrome',
- 'opera',
- 'qupzilla',
- 'vivaldi',
- 'adobe-flash',
- 'chrome-binary-plugins',
- 'freshplayerplugin',
- 'google-talkplugin',
- 'wmail',
- 'trojita',
- 'aircrack-ng',
- 'wavemon')
- ''')
- rows = cursor.fetchall()
-
- for row in rows:
- inx = rows.index(row)
- self.table_internet.insertRow(inx)
- self.table_internet.setItem(inx, 0, QtWidgets.QTableWidgetItem(row[0]))
- self.table_internet.setItem(inx, 1, QtWidgets.QTableWidgetItem(row[1]))
- self.table_internet.setItem(inx, 2, QtWidgets.QTableWidgetItem(row[2]))
- self.table_internet.setItem(inx, 3, QtWidgets.QTableWidgetItem(row[3]))
- self.table_internet.setItem(inx, 4, QtWidgets.QTableWidgetItem(row[4]))