From 990367ef6ef2caf967f72cd97b3bf2fe9f68cd5a Mon Sep 17 00:00:00 2001 From: Dmitrii Morozov Date: Wed, 31 Jul 2024 18:14:05 +0200 Subject: Added time played stats --- persistence/__init__.py | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'persistence') diff --git a/persistence/__init__.py b/persistence/__init__.py index be040eb..348ae59 100644 --- a/persistence/__init__.py +++ b/persistence/__init__.py @@ -58,7 +58,7 @@ class StatsRepository: def __initialize(self): cur = self.__get_connection().cursor() - cur.execute("CREATE TABLE IF NOT EXISTS stats(user_id TEXT, stats_datetime DATETIME, display_name TEXT, level INT, matches_played INT, kills INT, wins INT)") + cur.execute("CREATE TABLE IF NOT EXISTS stats(user_id TEXT, stats_datetime DATETIME, display_name TEXT, level INT, matches_played INT, kills INT, wins INT, minutes_played INT)") cur.execute("CREATE UNIQUE INDEX IF NOT EXISTS user_id_date_idx ON stats(user_id, stats_datetime)") async def put_stats(self, user: User, stats_datetime: datetime.datetime): @@ -66,14 +66,15 @@ class StatsRepository: connection = self.__get_connection() cur = connection.cursor() - query = "INSERT OR REPLACE INTO stats(user_id, stats_datetime, display_name, level, matches_played, kills, wins) VALUES('{user_id}', '{stats_datetime}', '{display_name}', {level}, {matches_played}, {kills}, {wins})".format( + query = "INSERT OR REPLACE INTO stats(user_id, stats_datetime, display_name, level, matches_played, kills, wins, minutes_played) VALUES('{user_id}', '{stats_datetime}', '{display_name}', {level}, {matches_played}, {kills}, {wins}, {minutes_played})".format( user_id = user.id, stats_datetime = stats_datetime, display_name = user.display_name, level = stats.level, matches_played = stats.matches_played, kills = stats.kills, - wins = stats.wins) + wins = stats.wins, + minutes_played = stats.minutesplayed) cur.execute(query) connection.commit() @@ -93,6 +94,7 @@ class StatsRepository: user_stats.matches_played = int(record[4]) user_stats.kills = int(record[5]) user_stats.wins = int(record[6]) + user_stats.minutesplayed = int(record[7]) return user_stats class PresenceRepository: -- cgit v1.2.3