diff options
author | Dmitrii Morozov <snoopdesigns@gmail.com> | 2024-07-31 18:14:05 +0200 |
---|---|---|
committer | Dmitrii Morozov <snoopdesigns@gmail.com> | 2024-07-31 18:14:05 +0200 |
commit | 990367ef6ef2caf967f72cd97b3bf2fe9f68cd5a (patch) | |
tree | 7c1fc0723dc7b48f9b3a9d7150d668dbcc6da569 /persistence | |
parent | c2c3c022cce2faec962be9a6b875efba0c569e7a (diff) |
Added time played stats
Diffstat (limited to 'persistence')
-rw-r--r-- | persistence/__init__.py | 8 |
1 files changed, 5 insertions, 3 deletions
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: |