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()