PCBdataBase.py 文件源码

def findEntries(self):
        for i in range(self.categoriesTable.rowCount(), 0, -1):
            self.categoriesTable.removeRow(i - 1)
        ##
        self.sql.reloadList()

        for i in self.sql.packages():
            dane = self.sql.getValues(i)

            software = eval(dane["soft"])
            for j in software:
                if j[1] == self.fromSoftware.currentText():
                    rowNumber = self.categoriesTable.rowCount()
                    self.categoriesTable.insertRow(rowNumber)
                    #
                    widgetActive = QtGui.QCheckBox('')
                    widgetActive.setStyleSheet('margin-left:18px;')
                    self.categoriesTable.setCellWidget(rowNumber, 0, widgetActive)
                    #
                    item0 = QtGui.QTableWidgetItem(i)
                    self.categoriesTable.setItem(rowNumber, 1, item0)
                    #
                    item1 = QtGui.QTableWidgetItem(dane["name"])
                    item1.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled)
                    self.categoriesTable.setItem(rowNumber, 2, item1)
                    #
                    item2 = QtGui.QTableWidgetItem(j[0])
                    self.categoriesTable.setItem(rowNumber, 3, item2)
                    #
                    itemCat = QtGui.QTableWidgetItem(readCategories()[int(dane['category'])][0])
                    itemCat.setFlags(QtCore.Qt.ItemIsSelectable | QtCore.Qt.ItemIsEnabled)
                    self.categoriesTable.setItem(rowNumber, 4, itemCat)
                    #
                    item3 = QtGui.QTableWidgetItem(str(j[2]))
                    item3.setTextAlignment(QtCore.Qt.AlignCenter)
                    self.categoriesTable.setItem(rowNumber, 5, item3)
                    #
                    item4 = QtGui.QTableWidgetItem(str(j[3]))
                    item4.setTextAlignment(QtCore.Qt.AlignCenter)
                    self.categoriesTable.setItem(rowNumber, 6, item4)
                    #
                    item5 = QtGui.QTableWidgetItem(str(j[4]))
                    item5.setTextAlignment(QtCore.Qt.AlignCenter)
                    self.categoriesTable.setItem(rowNumber, 7, item5)
                    #
                    item6 = QtGui.QTableWidgetItem(str(j[5]))
                    item6.setTextAlignment(QtCore.Qt.AlignCenter)
                    self.categoriesTable.setItem(rowNumber, 8, item6)
                    #
                    item7 = QtGui.QTableWidgetItem(str(j[6]))
                    item7.setTextAlignment(QtCore.Qt.AlignCenter)
                    self.categoriesTable.setItem(rowNumber, 9, item7)
                    #
                    item8 = QtGui.QTableWidgetItem(str(j[7]))
                    item8.setTextAlignment(QtCore.Qt.AlignCenter)
                    self.categoriesTable.setItem(rowNumber, 10, item8)