def add_to_sqlite(self):
conn = sqlite3.connect(results_database)
self.create_sqlite()
c = conn.cursor()
if self.winner and self.loser != "":
c.execute(
"""INSERT INTO {} ('winner', 'loser', 'winner_score', 'loser_score')
VALUES (?, ?, ?, ?);""".format(self.game),
(self.winner, self.loser, self.winner_score, self.loser_score))
conn.commit()
conn.close()
elo = Elo(self.winner, self.loser, self.game)
elo.get_new_elo()
def add_to_sqlite(self):
conn = sqlite3.connect(config.DB_CONN)
self.create_sqlite()
# 1 = Win 0 - Loss
c = conn.cursor()
if self.usr_score > self.opp_score:
result = 1
elif self.opp_score > self.usr_score:
result = 0
else:
result = None
c.execute(
"""INSERT INTO {} ('player', 'opponent', 'usr_score', 'opp_score', 'result')
VALUES (?, ?, ?, ?, ?);""".format(self.game),
(self.usr, self.opp, self.usr_score, self.opp_score, result))
conn.commit()
elo = Elo(self.usr, self.opp, result, self.game)
elo.get_new_elo()
