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