def accept(self):
money = str(self.txtMoney.text())
data = [
self.cmbMonth.currentIndex(),
self.txtYear.text(),
self.txtName.text(), money
]
columns = ["month", "year", "name", "money"]
bbdd = Bbdd()
bbdd.update(columns, data, "conjunta", "id=" + str(self.id))
bbdd.deleteWhere("conjunta_tipster", "conjunta=" + str(self.id))
for i in self.selected:
if i in (0, 1):
continue
bbdd.insert(["conjunta", "tipster"], [self.id, i],
"conjunta_tipster")
bbdd.close()
QMessageBox.information(self, _("Added"),
_("New joint purchase added."))
self.close()
def accept(self):
money = str(str_to_float(self.txtMoney.text()))
data = [
self.cmbMonth.currentIndex(),
self.txtYear.text(),
self.txtName.text(), money
]
columns = ["month", "year", "name", "money"]
bbdd = Bbdd()
bbdd.update(columns, data, "conjunta", "id=" + str(self.id))
bbdd.deleteWhere("conjunta_tipster", "conjunta=" + str(self.id))
for i in self.selected:
if i in (0, 1):
continue
bbdd.insert(["conjunta", "tipster"], [self.id, i],
"conjunta_tipster")
bbdd.close()
QMessageBox.information(self, "Añadido", "Nueva conjunta añadida.")
self.close()
def deleteItem(self):
resultado = QMessageBox.question(self, "Eliminar", "¿Estas seguro que desas eliminar la competición y las apuestas asociadas?", QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("competition", self.itemSelected)
bd.deleteWhere("bet", "competition=" + str(self.itemSelected))
self.mainWindows.setCentralWidget(Competitions(self.mainWindows))
self.mainWindows.enableTools()
def deleteItem(self):
resultado = QMessageBox.question(self, _("Remove"), _("Are you sure you want to eliminate it?"),
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("bet", self.itemSelected)
bd.deleteWhere("combined", "bet=" + str(self.itemSelected))
self.mainWindows.setCentralWidget(Bets(self.mainWindows))
self.mainWindows.enableTools()
def deleteItem(self):
resultado = QMessageBox.question(
self, "Eliminar", "¿Estas seguro que desas eliminarlo?",
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("bet", self.itemSelected)
bd.deleteWhere("combined", "bet=" + str(self.itemSelected))
self.mainWindows.setCentralWidget(Bets(self.mainWindows))
self.mainWindows.enableTools()
def deleteConjunta(self):
resultado = QMessageBox.question(self, "Eliminar",
"¿Estás seguro que desas eliminar esta conjunta?",
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("conjunta", str(self.itemConjunta))
bd.deleteWhere("conjunta_tipster","conjunta=" + str(self.itemConjunta))
self.mainWindows.setCentralWidget(TipstersMonth(self.mainWindows))
self.mainWindows.enableTools("tipster_money")
bd.close()
def deleteItem(self):
resultado = QMessageBox.question(self, _("Remove"), _('Are you sure you want to eliminate the region ') +
'and its associated competitions and bets?',
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("region", self.itemSelected)
bd.deleteWhere("competition", "region=" + str(self.itemSelected))
bd.deleteWhere("bet", "region=" + str(self.itemSelected))
self.mainWindows.setCentralWidget(Regions(self.mainWindows))
self.mainWindows.enableTools()
def deleteItem(self):
resultado = QMessageBox.question(
self, _("Remove"),
_("Are you sure you want to eliminate this tipster and all associated bets?"
), QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("tipster", self.itemSelected)
bd.deleteWhere("bet", "tipster=" + str(self.itemSelected))
self.mainWindows.setCentralWidget(Tipsters(self.mainWindows))
self.mainWindows.enableTools()
def deleteItem(self):
resultado = QMessageBox.question(
self, _("Remove"),
_("Are you sure you want to eliminate ") +
_("the competition and the associated bets?"),
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("competition", self.itemSelected)
bd.deleteWhere("bet", "competition=" + str(self.itemSelected))
self.mainWindows.setCentralWidget(Competitions(self.mainWindows))
self.mainWindows.enableTools()
def deleteConjunta(self):
resultado = QMessageBox.question(
self, _("Remove"),
_("Are you sure you want to eliminate this purchase joint?"),
QMessageBox.Yes | QMessageBox.No, QMessageBox.No)
if resultado == QMessageBox.Yes:
bd = Bbdd()
bd.delete("conjunta", str(self.itemConjunta))
bd.deleteWhere("conjunta_tipster",
"conjunta=" + str(self.itemConjunta))
self.mainWindows.setCentralWidget(TipstersMonth(self.mainWindows))
self.mainWindows.enableTools("tipster_money")
bd.close()
def deleteWhere(table, where):
bd = Bbdd()
msg = bd.deleteWhere(table, where)
bd.close()
if msg != 0:
msg = "Se ha producido un error al actualizar la BBDD"
return msg
def accept(self):
data = []
bbdd = Bbdd()
# dtDate
data.append(self.dtDate.dateTime().toPyDateTime())
# cmbSport
idSport = self.sportIndexToId.get(self.cmbSport.currentIndex())
data.append(idSport)
# cmbCompetition
idCompetition = self.competitionIndexToId.get(
self.cmbCompetition.currentIndex())
data.append(idCompetition)
# cmbRegion
idRegion = self.regionIndexToId.get(self.cmbRegion.currentIndex())
data.append(idRegion)
data.append(self.txtPlayer1.currentText())
data.append(self.txtPlayer2.currentText())
data.append(self.txtPick.text())
# cmbBookie
idBookie = self.bookieIndexToId.get(self.cmbBookie.currentIndex())
data.append(idBookie)
# cmbMarket
idMarket = self.marketIndexToId.get(self.cmbMarket.currentIndex())
data.append(idMarket)
# cmbTipster
idTipster = self.tipsterIndexToId.get(self.cmbTipster.currentIndex())
data.append(idTipster)
data.append(str(self.txtStake.text()))
data.append(str(self.txtOne.text()))
# cmbResult
data.append(self.cmbResult.currentIndex())
data.append(str(self.txtProfit.text()))
data.append(str(self.txtBet.text()))
data.append(str(self.txtQuota.text()))
data.append(1 if self.chkFree.isChecked() else 0)
columns = [
"date", "sport", "competition", "region", "player1", "player2",
"pick", "bookie", "market", "tipster", "stake", "one", "result",
"profit", "bet", "quota", "free"
]
bbdd.update(columns, data, "bet", "id=" + self.id)
if self.cmbMarket.currentText() == "Combinada":
columns = [
"bet", "date", "sport", "competition", "region", "player1",
"player2", "pick", "result"
]
bbdd.deleteWhere("combined", "bet=" + str(self.id))
for i in range(0, self.contComb):
data = []
data.append(self.id)
data.append(self.dates[i].dateTime().toPyDateTime())
idSport = self.sportIndexToId.get(
self.sports[i].currentIndex())
data.append(idSport)
idCompetition = self.competitionIndexToIdCmb[i].get(
self.competitions[i].currentIndex())
data.append(idCompetition)
idRegion = self.regionIndexToIdCmb[i].get(
self.regions[i].currentIndex())
data.append(idRegion)
data.append(self.players1[i].currentText())
data.append(self.players2[i].currentText())
data.append(self.picks[i].text())
data.append(self.results[i].currentIndex())
bbdd.insert(columns, data, "combined")
bbdd.close()
QMessageBox.information(self, _("Modified"), _("Modified bet."))
self.close()
