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."
