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(" "))
