Added time played stats

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: