def initCombined(self): bd = Bbdd() data = bd.select("combined", None, "bet=" + str(self.id)) i = 0 for bet in data: self.addCombined() date = QDateTime.fromString(bet[2], "yyyy-MM-dd hh:mm:ss") self.dates[i].setDateTime(date) sport = key_from_value(self.sportIndexToId, bet[3]) self.sports[i].setCurrentIndex(sport) self.setRegionComb(i) region = key_from_value(self.regionIndexToIdCmb[i], bet[5]) self.regions[i].setCurrentIndex(region) self.setCompetitionComb(i) competition = key_from_value(self.competitionIndexToIdCmb[i], bet[4]) self.competitions[i].setCurrentIndex(competition) self.players1[i].setCurrentText(bet[6]) self.players2[i].setCurrentText(bet[7]) self.picks[i].setText(bet[8]) result = { "Pendiente": 0, "Acertada": 1, "Fallada": 2, "Nula": 3, "Medio Acertada": 4, "Medio Fallada": 5, "Retirada": 6 }[bet[9]] self.results[i].setCurrentIndex(result) i += 1 bd.close()
def initCombined(self): bd = Bbdd() data = bd.select("combined", None, "bet=" + str(self.id)) i = 0 for bet in data: self.addCombined() date = QDateTime.fromString(bet[2], "yyyy-MM-dd hh:mm:ss") self.dates[i].setDateTime(date) try: sport = key_from_value(self.sportIndexToId, bet[3]) self.sports[i].setCurrentIndex(sport) self.setRegionComb(i) region = key_from_value(self.regionIndexToIdCmb[i], bet[5]) self.regions[i].setCurrentIndex(region) self.setCompetitionComb(i) competition = key_from_value(self.competitionIndexToIdCmb[i], bet[4]) self.competitions[i].setCurrentIndex(competition) except: print("No data combined") self.players1[i].setCurrentText(bet[6]) self.players2[i].setCurrentText(bet[7]) self.picks[i].setText(bet[8]) self.results[i].setCurrentIndex(int(bet[9])) i += 1 bd.close()
def updateTree(self): year = self.cmbYear.currentText() sMonth = self.cmbMonth.currentText() month = key_from_value(self.months, sMonth) data = LibStats.getMarket(year, month) self.treeMonth.clear() items = [] for i in data: item = QTreeWidgetItem(i) item = paint_row(item, i[5]) items.append(item) self.treeMonth.addTopLevelItems(items)
def updateStats(self): year = self.cmbYear.currentText() sMonth = self.cmbMonth.currentText() month = key_from_value(self.months, sMonth) data = LibStats.getMonth(year, month) self.txtApostado.setText(str(data[0])) self.txtGanancias.setText(str(data[1])) self.txtPerdidas.setText(str(data[2])) self.txtBeneficio.setText(str(data[3])) self.txtPendiente.setText(str(data[4])) self.txtYield.setText(str(data[5])) self.txtCuota.setText(str(data[6])) self.txtApuestas.setText(str(data[7])) self.txtAciertos.setText(str(data[8])) self.txtFallos.setText(str(data[9])) self.txtNulos.setText(str(data[10])) self.txtAcierto.setText(str(data[11])) self.txtApuestaMedia.setText(str(data[12]))