From 8ada3ad72e6f183ff4d17687328ad5e0b552919a Mon Sep 17 00:00:00 2001
From: bionel <ionel.busuioc@gmail.com>
Date: Sun, 17 Sep 2017 21:56:26 +0300
Subject: switch to model based tableview

---
 src/frontend/gui/sisyphus-gui.py    | 57 ++++++++++++++++++++-----------------
 src/frontend/gui/ui/sisyphus-gui.ui |  4 +--
 2 files changed, 33 insertions(+), 28 deletions(-)

diff --git a/src/frontend/gui/sisyphus-gui.py b/src/frontend/gui/sisyphus-gui.py
index 1562d53..10c1ed8 100755
--- a/src/frontend/gui/sisyphus-gui.py
+++ b/src/frontend/gui/sisyphus-gui.py
@@ -11,7 +11,7 @@ class Sisyphus(QtWidgets.QMainWindow):
         self.centerOnScreen()
         self.show()
         self.progress.hide()
-        self.loadDatabase()
+        self.loadDatabase("'%%'")
 
         self.input.returnPressed.connect(self.filterDatabase)
 
@@ -41,7 +41,7 @@ class Sisyphus(QtWidgets.QMainWindow):
         self.move((resolution.width() / 2) - (self.frameSize().width() / 2),
                     (resolution.height() / 2) - (self.frameSize().height() / 2))
 
-    def loadDatabase(self):
+    def loadDatabase(self,searchTerm):
         with sqlite3.connect('/var/lib/sisyphus/db/sisyphus.db') as db:
             cursor=db.cursor()
             cursor.execute('''SELECT
@@ -55,41 +55,46 @@ class Sisyphus(QtWidgets.QMainWindow):
                             ON a.category = i.category
                             AND a.name = i.name
                             AND a.slot = i.slot
-                        ''')
+                            WHERE a.name LIKE %s
+                        '''%searchTerm)
             rows = cursor.fetchall()
-
+            model = QtGui.QStandardItemModel(len(rows), 5)
             for row in rows:
-                inx = rows.index(row)
-                self.database.insertRow(inx)
-                self.database.setItem(inx, 0, QtWidgets.QTableWidgetItem(row[0]))
-                self.database.setItem(inx, 1, QtWidgets.QTableWidgetItem(row[1]))
-                self.database.setItem(inx, 2, QtWidgets.QTableWidgetItem(row[2]))
-                self.database.setItem(inx, 3, QtWidgets.QTableWidgetItem(row[3]))
-                self.database.setItem(inx, 4, QtWidgets.QTableWidgetItem(row[4]))
+                indx = rows.index(row)
+                for column in range(0, 5):
+                    item = QtGui.QStandardItem("%s"%(row[column]))
+                    model.setItem(indx, column, item)
+            self.database.setModel(model)
 
     def filterDatabase(self):
-        items = self.database.findItems(self.input.text(), QtCore.Qt.MatchExactly)
-        if items:
-            for item in items:
-                results = ''.join('%d' % (item.row() + 0)).split()
-                coordinates = map(int, results)
-                for coordinate in coordinates:
-                    self.database.setCurrentCell(coordinate, 0)
-        else:
-            self.input.setText("There are no packages with that name...")
+        search = self.input.text()
+        queryTerm = "'%" + search + "%'"
+        self.loadDatabase(queryTerm)
     
     def packageInstall(self):
-        self.showProgressBar()
-        Sisyphus.PKGLIST = self.database.item(self.database.currentRow(), 1).text()
-        self.installThread.start()
+        indexes = self.database.selectionModel().selectedRows(1)
+        if len(indexes) == 0:
+            print('Please select at least one package!!!')
+        Sisyphus.PKGLIST = []
+        for index in sorted(indexes):
+            Sisyphus.PKGLIST.append(index.data())
+        print(Sisyphus.PKGLIST)
+        #self.showProgressBar()
+        #self.installThread.start()
 
     def finishedInstall(self):
         self.hideProgressBar()
 
     def packageUninstall(self):
-        self.showProgressBar()
-        Sisyphus.PKGLIST = self.database.item(self.database.currentRow(), 1).text()
-        self.uninstallThread.start()
+        indexes = self.database.selectionModel().selectedRows(1)
+        if len(indexes) == 0:
+            print('Please select at least one package!!!')
+        Sisyphus.PKGLIST = []
+        for index in sorted(indexes):
+            Sisyphus.PKGLIST.append(index.data())
+        print(Sisyphus.PKGLIST)
+        #self.showProgressBar()
+        #self.uninstallThread.start()
 
     def finishedUninstall(self):
         self.hideProgressBar()
diff --git a/src/frontend/gui/ui/sisyphus-gui.ui b/src/frontend/gui/ui/sisyphus-gui.ui
index 85ff753..8dcedb8 100644
--- a/src/frontend/gui/ui/sisyphus-gui.ui
+++ b/src/frontend/gui/ui/sisyphus-gui.ui
@@ -108,7 +108,7 @@
        </widget>
       </item>
       <item row="1" column="0" colspan="5">
-       <widget class="QTableWidget" name="database">
+       <widget class="QTableView" name="database">
         <property name="frameShape">
          <enum>QFrame::Panel</enum>
         </property>
@@ -125,7 +125,7 @@
          <bool>false</bool>
         </property>
         <property name="selectionMode">
-         <enum>QAbstractItemView::SingleSelection</enum>
+         <enum>QAbstractItemView::MultiSelection</enum>
         </property>
         <property name="selectionBehavior">
          <enum>QAbstractItemView::SelectRows</enum>
-- 
cgit v1.2.3