def accept(self): data = [] data.append(self.txtDate.text()) data.append(self.cmbAccount.currentIndex() + 1) idBookie = self.bookieIndexToId.get(self.cmbBookie.currentIndex()) data.append(idBookie) if self.cmbType.currentIndex() == 1: type = "-" else: type = "" money = type + str(self.txtMoney.text()) money = str_to_float(money) data.append(money) columns = ["date", "account", "bookie", "money"] bbdd = Bbdd() bbdd.insert(columns, data, "movement") money *= -1 data = ["'+bank+'" + str(money)] columns = ["bank"] account = self.cmbAccount.currentIndex() bbdd.update(columns, data, "bank", "id=" + str(account + 1)) bbdd.close() QMessageBox.information(self, "Añadido", "Movimiento añadido.") 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 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): data = [self.txtName.text()] columns = ["name"] bbdd = Bbdd() bbdd.update(columns, data, "market", "id=" + self.id) bbdd.close() QMessageBox.information(self, _("Updated"), _("Market updated.")) self.close()
def accept(self): data = [self.txtName.text()] columns = ["name"] bbdd = Bbdd() bbdd.update(columns, data, "tipster", "id=" + self.id) bbdd.close() QMessageBox.information(self, "Actualizado", "Tipster actualizado.") self.close()
def accept(self): data = [self.txtRegion.text()] columns = ["name"] bbdd = Bbdd() bbdd.update(columns, data, "region", "id=" + self.id) bbdd.close() QMessageBox.information(self, _("Updated"), _("Updated region.")) self.close()
def accept(self): data = [self.txtRegion.text()] columns = ["name"] bbdd = Bbdd() bbdd.update(columns, data, "region", "id=" + self.id) bbdd.close() QMessageBox.information(self, "Actualizada", "Región actualizada.") self.close()
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("movement", self.itemSelected) data = ["'+bank+'" + self.treeMovement.currentItem().text(5)] columns = ["bank"] bd.update(columns, data, "bank", "name='" + self.treeMovement.currentItem().text(4) + "'") bd.close() self.mainWindows.setCentralWidget(Banks(self.mainWindows)) self.mainWindows.enableTools("bank")
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("movement", self.itemSelected) data = ["'+bank+'" + self.treeMovement.currentItem().text(5)] columns = ["bank"] bd.update(columns, data, "bank", "name='" + self.treeMovement.currentItem().text(4) + "'") bd.close() self.mainWindows.setCentralWidget(Banks(self.mainWindows)) self.mainWindows.enableTools("bank")
def update(self): if not self.isEmpty(): bd = Bbdd() msg = bd.update(["name", "country"], [self.name, self.country], "bookie", "id=" + self.id) bd.close() if msg != 0: msg = "Se ha producido un error al actualizar la BBDD" if self.ruta is not None: try: if not os.path.exists( expanduser("~") + "/.betcon/resources/bookies"): os.makedirs( expanduser("~") + "/.betcon/resources/bookies") copy2( self.ruta, expanduser("~") + "/.betcon/resources/bookies/" + self.id + ".png") img = Images( expanduser("~") + "/.betcon/resources/bookies/" + self.id + ".png") img.resize(100, 20) except: msg = "Imágen incorrecta" else: msg = "Faltan datos por introducir" return msg
def accept(self): data = [] data.append(self.txtName.text()) idRegion = self.regionIndexToId.get(self.cmbRegion.currentIndex()) data.append(idRegion) idSport = self.sportIndexToId.get(self.cmbSport.currentIndex()) data.append(idSport) columns = ["name", "region", "sport"] bbdd = Bbdd() bbdd.update(columns, data, "competition", "id=" + self.id) bbdd.close() QMessageBox.information(self, "Actualizada", "Competición actualizada.") self.close()
def accept(self): idTipster = self.tipsterIndexToId.get(self.cmbTipster.currentIndex()) print(idTipster) money = str(self.txtMoney.text()) data = [ self.cmbMonth.currentIndex(), self.txtYear.text(), idTipster, money ] columns = ["month", "year", "tipster", "money"] bbdd = Bbdd() bbdd.update(columns, data, "tipster_month") bbdd.close() QMessageBox.information(self, _("Updated"), _("Added tipster payment.")) self.close()
def update(self): if not self.isEmpty(): bd = Bbdd() msg = bd.update(["name"], [self.name], "bookie", "id="+self.id) bd.close() if msg != 0: msg = "Se ha producido un error al actualizar la BBDD" else: msg = "Faltan datos por introducir" return msg
def accept(self): type = self.cmbType.currentIndex() if type == 0: type="+" else: type="-" data = ["'+bank"+type+"'"+str(self.txtMoney.text())] columns = ["bank"] account = self.cmbAccount.currentIndex() bbdd = Bbdd() bbdd.update(columns, data, "bank", "id="+str(account+1)) bbdd.close() QMessageBox.information(self, _("Added"), _("Added funds.")) self.close()
def accept(self): type = self.cmbType.currentIndex() if type == 0: type="+" else: type="-" data = ["'+bank"+type+"'"+str(str_to_float(self.txtMoney.text()))] columns = ["bank"] account = self.cmbAccount.currentIndex() bbdd = Bbdd() bbdd.update(columns, data, "bank", "id="+str(account+1)) bbdd.close() QMessageBox.information(self, "Añadido", "Fondos añadidos.") self.close()
def accept(self): data = [self.txtName.text()] columns = ["name"] bbdd = Bbdd() bbdd.update(columns, data, "sport", "id="+self.id) bbdd.close() if self.ruta is not None: try: if not os.path.exists(expanduser("~") + "/.betcon/resources/sports"): os.makedirs(expanduser("~") + "/.betcon/resources/sports") copy2(self.ruta, expanduser("~") + "/.betcon/resources/sports/" + self.id + ".png") img = Images(expanduser("~") + "/.betcon/resources/sports/" + self.id + ".png") img.resize(100, 20) except: msg = "Imágen incorrecta" QMessageBox.information(self, _("Updated"), _("Updated sport.")) self.close()
def accept(self): data = [] bbdd = Bbdd() # dtDate data.append(self.txtDate.date().toPyDate()) # cmbBookie idBookie = self.bookieIndexToId.get(self.cmbBookie.currentIndex()) data.append(idBookie) data.append(str(str_to_float(self.txtMoney.text()))) free = self.chkFree.isChecked() data.append(free) columns = ["date", "bookie", "money", "free"] bbdd.update(columns, data, "bonus", "id=" + self.id) QMessageBox.information(self, "Actualizado", "Bono actualizado.") self.close()
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()