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]))
