def __init__(self): super(base2, self).__init__() self.choise = ChoiceWindow() self.setupUi(self) self.setWindowTitle("Piekarnia") # wyświetl przepis self.tableRecipes.cellChanged.connect(self.choose) self.tableRecipes.cellClicked.connect(self.saveCell) self.selectedRow = 0 self.selectedColumn = 0 self.selectedCell = " " self.saveButton.disconnect() self.saveButton.clicked.connect(self.saveData) self.deleteButton.clicked.connect(self.askIfDeleteRecipe) self.differencesRecipes = [] self.differencesData = [] rows = query.count("tabele") self.recipes = [] self.recipesDb = [] self.data = [] self.dataDb = []
def readDataFromDb(self, tab): # print(self.data, len(self.data)) self.dataDb = [] rows = query.count(tab) for i in range(rows): a = query.read(tab, i + 1) self.dataDb.append(a) self.dataDb[i][1] = self.dataDb[i][1][1:-1]
def readRecipesFromDb(self): rows = query.count("tabele") self.recipesDb = [] for i in range(rows): col = [2] if i < rows: # col[ = i+1 col = query.read("tabele", i + 1) self.recipesDb.append(str(col))
def differenceData(self): self.differencesData = [] self.readData() tab = self.selectedCell if tab == " ": return 0 # print("differenceData()") self.readDataFromDb(tab) found = [0] index = 0 # print(self.data) send = [0, "", ""] save = " " if query.count(tab) > 0: for data in self.data: for dataDb in self.dataDb: # print("porównuję... ",index, data, dataDb) if dataDb[0] == data[0] and dataDb[1] == data[1]: # print("znalazłem") save = dataDb found.append(0) #dokończ query.exists(tab, col1, col2) found[index] = 1 break else: found[index] = 0 found.append(0) # print("nie istrnieje") # print("0: ", data[0], "1: ", data[1]) if found[index]:# and self.checkExistsDataInDb(tab, data[0], data[1]): index += 1 continue else: send = [index+1, data[0], data[1]] self.differencesData.append(send) # print("else:", data) index += 1 if not self.differencesData: return 0 else: # print("differences", send) return 1 else: for data in self.data: send = [index+1, data[0], data[1]] self.differencesData.append(send) index += 1 # print("differences", send) return 1
def get(cls, q_obj=None, **kwargs): query = cls.objects() query_obj = { } if q_obj: query_obj.update(q_obj) if kwargs: query_obj.update(kwargs) #print query_obj if len(query_obj) == 0: return None query.filter(query_obj).limit(1) result = query.all_items() if query.count() != 1: return None return result[0]
def get(cls, q_obj=None, **kwargs): query = cls.objects() query_obj = {} if q_obj: query_obj.update(q_obj) if kwargs: query_obj.update(kwargs) #print query_obj if len(query_obj) == 0: return None query.filter(query_obj).limit(1) result = query.all_items() if query.count() != 1: return None return result[0]
def printRecipes(self): rows = query.count("tabele") self.tableRecipes.setRowCount(rows + 5) # self.tableRecipes.setColumnCount(1) # max = rows + 5 if rows < 13: self.tableRecipes.setRowCount(13) max = 13 else: self.tableRecipes.setRowCount(rows + 4) max = rows + 4 for i in range(max): if i < rows: col = query.read("tabele", i + 1) item = str(col) self.tableRecipes.setItem(i, 0, QTableWidgetItem(item)) else: self.tableRecipes.setItem(i, 0, QTableWidgetItem(" "))
def checkExistsDataInDb(self, *args): if len(args) == 3: tab = args[0] item = args[1] quan = args[2] rows = query.count(tab) for i in range(rows): ques = query.exists(tab, item, quan) if ques != 1 and tab == " ": # print("nie dodano") return 1 elif ques: # print("Jest już w bazie") return 1 else: print("Nie ma w bazie") # self.differencesRecipes.append(tab) return 0
def printData(self): tab = self.selectedCell self.label.setText(tab) tab = str(tab) rows = query.count(tab) self.readDataFromDb(tab) if rows < 13: self.tableData.setRowCount(13) max = 13 else: self.tableData.setRowCount(rows + 4) max = rows + 4 self.tableData.setColumnCount(2) self.readDataFromDb(tab) for i in range(max): if i < rows: self.tableData.setItem(i, 0, QTableWidgetItem(self.dataDb[i][0])) self.tableData.setItem(i, 1, QTableWidgetItem(self.dataDb[i][1])) else: self.tableData.setItem(i, 1, QTableWidgetItem(" ")) self.tableData.setItem(i, 0, QTableWidgetItem(" "))