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.txtRegion.text()] columns = ["name"] bbdd = Bbdd() bbdd.insert(columns, data, "region") bbdd.close() QMessageBox.information(self, _("Added"), _("New region added.")) self.close()
def accept(self): data = [self.txtName.text()] columns = ["name"] bbdd = Bbdd() bbdd.insert(columns, data, "tipster") bbdd.close() QMessageBox.information(self, "Añadido", "Nuevo tipster añadido.") self.close()
def accept(self): data = [self.txtName.text()] columns = ["name"] bbdd = Bbdd() bbdd.insert(columns, data, "tipster") bbdd.close() QMessageBox.information(self, _("Added"), _("New tipster added.")) self.close()
def accept(self): data = [self.txtRegion.text()] columns = ["name"] bbdd = Bbdd() bbdd.insert(columns, data, "region") bbdd.close() QMessageBox.information(self, "Añadida", "Nueva región añadida.") 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.insert(columns, data, "tipster_month") bbdd.close() QMessageBox.information(self, _("Added"), _("New tipster payment added.")) self.close()
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.insert(columns, data, "competition") bbdd.close() QMessageBox.information(self, "Añadida", "Nueva competición añadida.") self.close()
def insert(self): if not self.isEmpty(): bd = Bbdd() msg = bd.insert(["name"], [self.name], "bookie") bd.close() else: msg = "Faltan datos por introducir" return msg
def accept(self): idTipster = self.tipsterIndexToId.get(self.cmbTipster.currentIndex()) print(idTipster) money = str(str_to_float(self.txtMoney.text())) data = [ self.cmbMonth.currentIndex(), self.txtYear.text(), idTipster, money ] columns = ["month", "year", "tipster", "money"] bbdd = Bbdd() bbdd.insert(columns, data, "tipster_month") bbdd.close() QMessageBox.information(self, "Añadido", "Nuevo pago de tipster añadido.") 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(str(bool(free))) columns = ["date", "bookie", "money", "free"] bbdd.insert(columns, data, "bonus") QMessageBox.information(self, "Añadido", "Nuevo bono añadido.") 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(str_to_float(self.txtStake.text()))) data.append(str(str_to_float(self.txtOne.text()))) # cmbResult data.append(self.cmbResult.currentText()) data.append(str(str_to_float(self.txtProfit.text()))) data.append(str(str_to_float(self.txtBet.text()))) data.append(str(str_to_float(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.insert(columns, data, "bet") id_bet = bbdd.max("bet", "id") if self.cmbMarket.currentText() == "Combinada": columns = [ "bet", "date", "sport", "competition", "region", "player1", "player2", "pick", "result" ] for i in range(0, self.contComb): data = [] data.append(id_bet) 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].currentText()) bbdd.insert(columns, data, "combined") bbdd.close() QMessageBox.information(self, "Añadida", "Nueva apuesta añadida.") self.close()
def imports(self): if self.directory_bd is None: bd = Bbdd() else: bd = Bbdd(self.directory_bd) try: data = get_data(self.directory) data = data.popitem()[1] for i in data: row = [] if i[0] == "Fecha": continue row.append(i[0]) sport = bd.getId("'" + i[1] + "'", "sport") if sport is None: bd.insert(["name"], [i[1]], "sport") sport = bd.getId("'" + i[1] + "'", "sport") row.append(sport) region = bd.getId("'" + i[3] + "'", "region") if region is None: bd.insert(["name"], [i[3]], "region") region = bd.getId("'" + i[3] + "'", "region") competition = bd.getId("'" + i[2] + "'", "competition") if competition is None: bd.insert(["name", "region", "sport"], [i[2], region, sport], "competition") competition = bd.getId("'" + i[2] + "'", "competition") row.append(competition) row.append(region) row.append(i[4]) row.append(i[5]) row.append(i[6]) bookie = bd.getId("'" + i[7] + "'", "bookie") if bookie is None: bd.insert(["name"], [i[7]], "bookie") bookie = bd.getId("'" + i[7] + "'", "bookie") row.append(bookie) market = bd.getId("'" + i[8] + "'", "market") if market is None: bd.insert(["name"], [i[8]], "market") market = bd.getId("'" + i[8] + "'", "market") row.append(market) tipster = bd.getId("'" + i[9] + "'", "tipster") if tipster is None: bd.insert(["name"], [i[9]], "tipster") tipster = bd.getId("'" + i[9] + "'", "tipster") row.append(tipster) row.append(i[10]) row.append(i[11]) row.append(i[12]) row.append(i[13]) row.append(i[14]) row.append(i[15]) row.append(False if i[16] == "No" else True) columns = [ "date", "sport", "competition", "region", "player1", "player2", "pick", "bookie", "market", "tipster", "stake", "one", "result", "profit", "bet", "quota", "free" ] bd.insert(columns, row, "bet") except: return "Error de importación: El archivo de importación no tiene una estructura correcta."