def export(self): bd = Bbdd() file = OrderedDict() data = bd.select("bet") dataOds = [[ "Fecha", "Deporte", "Competicion", "Región", "Local", "Visitante", "Pick", "Casa", "Mercado", "Tipster", "Stake", "Unidad", "Resultado", "Beneficio", "Apuesta", "Cuota", "Gratuita" ]] for i in data: row = [] row.append(i[1]) row.append(bd.getValue(i[2], "sport")) row.append(bd.getValue(i[3], "competition")) row.append(bd.getValue(i[4], "region")) row.append(i[5]) row.append(i[6]) row.append(i[7]) row.append(bd.getValue(i[8], "bookie")) row.append(bd.getValue(i[9], "market")) row.append(bd.getValue(i[10], "tipster")) row.append(i[11]) row.append(i[12]) row.append(i[13]) row.append(i[14]) row.append(i[15]) row.append(i[16]) row.append("No" if i[17] == 0 else "Sí") dataOds.append(row) bd.close() file.update({"Apuestas": dataOds}) save_data(self.directory, file)
def initData(self): bd = Bbdd() name = bd.getValue(self.id, "tipster") self.txtName.setText(name) bd.close()
def initTree(self): bd = Bbdd() data = bd.select("tipster_month", "year, month") items = [] for i in data: id = i[0] year = i[2] month = numberToMonth(i[1]+1) tipster = bd.getValue(i[3], "tipster") money = i[4] item = QTreeWidgetItem([str(id), str(year), str(month), str(tipster), str(money)]) items.append(item) self.treeMain.addTopLevelItems(items) data = bd.select("conjunta", "year, month") if len(data) < 1: self.lblConjunta.setVisible(False) self.treeConjunta.setVisible(False) else: items = [] for i in data: id = i[0] year = i[3] month = numberToMonth(i[2] + 1) name = i[1] money = i[4] item = QTreeWidgetItem([str(id), str(year), str(month), str(name), str(money)]) items.append(item) self.treeConjunta.addTopLevelItems(items) bd.close()
def initData(self): bd = Bbdd() name = bd.getValue(self.id, "region") self.txtRegion.setText(name) bd.close()
def setCompetition(self): self.cmbCompetition.clear() bd = Bbdd() idRegion = self.regionIndexToId.get(self.cmbRegion.currentIndex()) idSport = self.sportIndexToId.get(self.cmbSport.currentIndex()) where = "region=" + str(idRegion) + " AND sport=" + str(idSport) data = bd.select("competition", "name", where) index, idCmb = 0, 0 idBd = bd.getValue(self.id, "bet", "competition") self.competitionIndexToId = {} index = 0 for i in data: id = i[0] if id == idBd: idCmb = index name = i[1] self.cmbCompetition.addItem(name) self.competitionIndexToId[index] = id index += 1 if index == 0: self.btnAccept.setDisabled(True) else: self.btnAccept.setDisabled(False) self.cmbCompetition.setCurrentIndex(idCmb) bd.close()
def initTree(self): self.treeBookie.clear() data = Bookie.selectAll() items = [] for i in data: bank = Bookie.sumAll("bookie=" + str(i.id)) bank = 0.0 if bank is None else bank bonus = Bookie.sumBonus("bookie=" + str(i.id)) bonus = 0.0 if bonus is None else bonus bank += bonus if 0.01 > bank > -0.01: continue item = QTreeWidgetItem( [i.name, "{0:.2f}".format(bank) + self.coin]) items.append(item) self.treeBookie.addTopLevelItems(items) self.treeMovement.clear() bd = Bbdd() data = bd.select("movement", "date DESC") items = [] for i in data: id = i[0] try: sDate = datetime.strptime(i[1], "%d/%m/%y") except: sDate = datetime.strptime(i[1], "%d/%m/%Y") # Fix for Windows sDate = date.strftime(sDate, "%Y/%m/%d") account = i[2] if account == 1: account = "Banco" elif account == 2: account = "Paypal" elif account == 3: account = "Skrill" bookie = bd.getValue(i[3], "bookie") money = i[4] if money < 0: type = _("Withdrawal to the bank.") else: type = _("Deposit at bookie") item = QTreeWidgetItem([ str(sDate), str(id), bookie, type, str(account), str(money) + self.coin ]) items.append(item) self.treeMovement.addTopLevelItems(items) bd.close()
def initTree(self): bd = Bbdd() data = bd.select("competition", "name") items = [] for i in data: id = i[0] name = i[1] region = bd.getValue(i[2], "region") sport = bd.getValue(i[3], "sport") item = QTreeWidgetItem([str(name), str(id), region, str(sport)]) items.append(item) self.treeMain.addTopLevelItems(items) self.treeMain.sortByColumn(0, QtCore.Qt.AscendingOrder) bd.close()
def initTree(self): bd = Bbdd() data = bd.select("competition", "name") index = 0 items = [] for i in data: index += 1 id = i[0] name = i[1] region = bd.getValue(i[2], "region") sport = bd.getValue(i[3], "sport") item = QTreeWidgetItem([str(index), str(id), str(name), region, str(sport)]) items.append(item) self.treeMain.addTopLevelItems(items) bd.close()
def changeItem(self): if self.itemSelected != -1: self.treeMain.topLevelItem(self.indexSelected).setText(3, "") self.treeMain.topLevelItem(self.indexSelected).setText(9, "") self.itemSelected = self.treeMain.currentItem().text(1) self.indexSelected = int(self.treeMain.currentItem().text(0)) - 1 bd = Bbdd() sport = bd.getValue(self.treeMain.currentItem().text(1), "bet", "sport") sport = bd.getValue(sport, "sport") self.treeMain.currentItem().setText(3, sport) bookie = bd.getValue(self.treeMain.currentItem().text(1), "bet", "bookie") bookie = bd.getValue(bookie, "bookie") self.treeMain.currentItem().setText(9, bookie) bd.close() self.mainWindows.enableActions()
def initData(self): bd = Bbdd() # txtName name = bd.getValue(self.id, "competition") self.txtName.setText(name) # cmbRegion data = bd.select("region", "name") self.regionIndexToId = {} index, idCmb = 0, 0 idBd = bd.getValue(self.id, "competition", "region") for i in data: id = i[0] if id == idBd: idCmb = index name = i[1] self.cmbRegion.addItem(name) self.regionIndexToId[index] = id index += 1 self.cmbRegion.setCurrentIndex(idCmb) # cmbSport bd = Bbdd() data = bd.select("sport", "name") self.sportIndexToId = {} index, idCmb = 0, 0 idBd = bd.getValue(self.id, "competition", "sport") for i in data: id = i[0] if id == idBd: idCmb = index name = i[1] self.cmbSport.addItem(name) self.sportIndexToId[index] = id index += 1 self.cmbSport.setCurrentIndex(idCmb) bd.close()
def initTree(self): year = self.cmbYear.currentText() month = self.cmbMonth.currentText() month = monthToNumber(month) self.treeMain.clear() bd = Bbdd() data = bd.select("bet", "date DESC", "date LIKE '" + year + "-" + month + "%'") index = 0 items = [] for i in data: index += 1 id = i[0] date = i[1][:-3] competition = bd.getValue(i[3], "competition") region = bd.getValue(i[4], "region") player1 = i[5] player2 = i[6] pick = i[7] #bookie = bd.getValue(i[8], "bookie") market = bd.getValue(i[9], "market") # TODO Preload in dictionary tipster = bd.getValue(i[10], "tipster") # TODO Preload in dictionary stake = i[11] one = i[12] result = numberToResult(i[13]) profit = i[14] bet = i[15] quota = i[16] item = QTreeWidgetItem([str(index), str(id), str(date), "", str(competition), str(region), player1, player2, pick, "", market, tipster, str(stake), str(one) + self.coin, str(bet) + self.coin, str(quota), str(result), str(profit) + self.coin]) item = paint_row(item, profit, i[13]) if os.path.isfile(expanduser("~") + "/.betcon/resources/sports/" + str(i[2]) + ".png"): item.setBackground(3, QBrush(QPixmap(expanduser("~") + "/.betcon/resources/sports/" + str(i[2]) + ".png"))) else: if os.path.isfile(directory + "/../resources/sports/" + str(i[2]) + ".png"): item.setBackground(3, QBrush(QPixmap(directory + "/../resources/sports/" + str(i[2]) + ".png"))) else: sport = bd.getValue(i[2], "sport") item.setText(3, sport) if os.path.isfile(expanduser("~") + "/.betcon/resources/bookies/" + str(i[8]) + ".png"): item.setBackground(9, QBrush(QPixmap(expanduser("~") + "/.betcon/resources/bookies/" + str(i[8]) + ".png"))) else: if os.path.isfile(directory + "/../resources/bookies/" + str(i[8]) + ".png"): item.setBackground(9, QBrush(QPixmap(directory + "/../resources/bookies/" + str(i[8]) + ".png"))) else: bookie = bd.getValue(i[8], "bookie") item.setText(9, bookie) items.append(item) self.treeMain.addTopLevelItems(items) bd.close()
def setRegion(self): self.btnAccept.setDisabled(False) self.cmbRegion.clear() bd = Bbdd() idSport = self.sportIndexToId.get(self.cmbSport.currentIndex()) where = " sport=" + str(idSport) data = bd.select("competition", None, where, "region") dataRegion = "" if len(data) > 0: sData = "(" j = 0 for i in data: if j == len(data) - 1: sData += str(i[0]) + ")" else: sData += str(i[0]) + ", " j += 1 where = " id in " + sData dataRegion = bd.select("region", "name", where) if len(dataRegion) < 1: self.btnAccept.setDisabled(True) bd.close() else: self.regionIndexToId = {} index, idCmb = 0, 0 idBd = bd.getValue(self.id, "bet", "region") for i in dataRegion: id = i[0] if id == idBd: idCmb = index name = i[1] self.cmbRegion.addItem(name) self.regionIndexToId[index] = id index += 1 self.cmbRegion.setCurrentIndex(idCmb) bd.close() self.setCompetition() else: self.btnAccept.setDisabled(True) bd.close() if len(data) == 0 or len(dataRegion) == 0: self.btnAccept.setDisabled(True) else: self.btnAccept.setDisabled(False)
def initTree(self): bd = Bbdd() data = bd.select("bonus", "date") items = [] for i in data: id = i[0] date = i[1] bookie = bd.getValue(i[2], "bookie") money = i[3] free = _("Yes") if str_to_bool(i[4]) else _("No") item = QTreeWidgetItem([str(date), str(id), str(bookie), str(money) + self.coin, str(free)]) items.append(item) self.treeMain.addTopLevelItems(items) bd.close()
def initTree(self): bd = Bbdd() data = bd.select("bet", "date DESC") index = 0 items = [] for i in data: index += 1 id = i[0] date = i[1] competition = bd.getValue(i[3], "competition") region = bd.getValue(i[4], "region") player1 = i[5] player2 = i[6] pick = i[7] #bookie = bd.getValue(i[8], "bookie") market = bd.getValue(i[9], "market") tipster = bd.getValue(i[10], "tipster") stake = i[11] one = i[12] result = i[13] profit = str(i[14]) bet = str(i[15]) quota = i[16] item = QTreeWidgetItem([ str(index), str(id), str(date), "", str(competition), str(region), player1, player2, pick, "", market, tipster, str(stake), str(one), str(bet), str(quota), str(result), str(profit) ]) profit = str_to_float(profit) if result == "Pendiente": for j in range(18): item.setBackground(j, QBrush(Qt.yellow)) else: if profit < 0: for j in range(18): item.setBackground(j, QBrush(Qt.red)) elif profit > 0: for j in range(18): item.setBackground(j, QBrush(Qt.green)) else: for j in range(18): item.setBackground(j, QBrush(Qt.cyan)) if os.path.isfile(directory + "/../resources/sports/" + str(i[2]) + ".png"): item.setBackground( 3, QBrush( QPixmap(directory + "/../resources/sports/" + str(i[2]) + ".png"))) else: sport = bd.getValue(i[2], "sport") item.setText(3, sport) if os.path.isfile(directory + "/../resources/bookies/" + str(i[8]) + ".png"): item.setBackground( 9, QBrush( QPixmap(directory + "/../resources/bookies/" + str(i[8]) + ".png"))) else: bookie = bd.getValue(i[8], "bookie") item.setText(9, bookie) items.append(item) self.treeMain.addTopLevelItems(items) bd.close()
def initData(self): # dtDate bd = Bbdd() sDate = bd.getValue(self.id, "bet", "date") date = QDateTime.fromString(sDate, "yyyy-MM-dd hh:mm:ss") self.dtDate.setDateTime(date) # cmbSport data = bd.select("sport", "name") self.sportIndexToId = {} index, idCmb = 0, 0 idBd = bd.getValue(self.id, "bet", "sport") for i in data: id = i[0] if id == idBd: idCmb = index name = i[1] self.cmbSport.addItem(name) self.sportIndexToId[index] = id index += 1 self.cmbSport.setCurrentIndex(idCmb) # cmbBookie data = bd.select("bookie", "name") index, idCmb = 0, 0 idBd = bd.getValue(self.id, "bet", "bookie") self.bookieIndexToId = {} index = 0 for i in data: id = i[0] if id == idBd: idCmb = index name = i[1] country = i[2] if LibYaml().interface['bookieCountry'] == 'Y': name += ' (' + country + ')' self.cmbBookie.addItem(name) self.bookieIndexToId[index] = id index += 1 self.cmbBookie.setCurrentIndex(idCmb) self.players = bd.executeQuery( "SELECT player1 AS player FROM bet UNION SELECT player2 AS player FROM bet ORDER BY player" ) self.players = [row[0] for row in self.players] self.txtPlayer1.addItems(self.players) self.txtPlayer2.addItems(self.players) # txtPlayer1 player1 = bd.getValue(self.id, "bet", "player1") self.txtPlayer1.setCurrentText(player1) # txtPlayer2 player2 = bd.getValue(self.id, "bet", "player2") self.txtPlayer2.setCurrentText(player2) # txtPick pick = bd.getValue(self.id, "bet", "pick") self.txtPick.setText(pick) # cmbMarket data = bd.select("market", "name") index, idCmb = 0, -1 idBd = bd.getValue(self.id, "bet", "market") self.marketIndexToId = {} index = 0 for i in data: id = i[0] if id == idBd: idCmb = index name = i[1] self.cmbMarket.addItem(name) self.marketIndexToId[index] = id index += 1 self.cmbMarket.setCurrentIndex(idCmb) # cmbTipster data = bd.select("tipster", "name") index, idCmb = 0, 0 idBd = bd.getValue(self.id, "bet", "tipster") self.tipsterIndexToId = {} index = 0 for i in data: id = i[0] if id == idBd: idCmb = index name = i[1] self.cmbTipster.addItem(name) self.tipsterIndexToId[index] = id index += 1 self.cmbTipster.setCurrentIndex(idCmb) # txtStake stake = bd.getValue(self.id, "bet", "stake") self.txtStake.setValue(stake) # txtOne one = bd.getValue(self.id, "bet", "one") self.txtOne.setValue(one) # txtBet bet = bd.getValue(self.id, "bet", "bet") self.txtBet.setValue(bet) # txtQuota quota = bd.getValue(self.id, "bet", "quota") self.txtQuota.setValue(quota) # txtProfit profit = bd.getValue(self.id, "bet", "profit") self.txtProfit.setValue(profit) result = bd.getValue(self.id, "bet", "result") self.cmbResult.setCurrentIndex(int(result)) freeBet = bd.getValue(self.id, "bet", "free") self.chkFree.setChecked(freeBet) bd.close() self.setRegion() # Combined self.contComb = 0 self.dates = [] self.sports = [] self.regions = [] self.competitions = [] self.players1 = [] self.players2 = [] self.picks = [] self.results = [] self.buttons = [] self.regionIndexToIdCmb = [] self.competitionIndexToIdCmb = []
def setId(self, id): self.id = id bd = Bbdd() self.name = bd.getValue(self.id, "bookie") bd.close()