def loadBreakfastData(self):
try:
# imput data from db into table
Date = self.dateEdit.date().toString(QtCore.Qt.ISODate)
result = SQLStatements.getBreakfastInfo(self.userID,Date)
self.tableWidgetBreakfast.setRowCount(0)
self.tableWidgetBreakfast.setHorizontalHeaderLabels(['Food', 'Calories', 'Grams'])
for row_number, row_data in enumerate(result):
self.tableWidgetBreakfast.insertRow(row_number)
for column_number, data in enumerate(row_data):
self.tableWidgetBreakfast.setItem(row_number, column_number,
QtWidgets.QTableWidgetItem(str(data)))
#set total calories amount
data = SQLStatements.getTotalBreakfastCalories(self.userID,Date)
tot = 0
for row in data:
tot += row[0]
self.labelBreakfastValue.setText(str(tot))
except Exception as e:
print(e)
