From ea0565644ff47f70499ce3e56ac97d766717e0d4 Mon Sep 17 00:00:00 2001 From: Dmitrii Morozov Date: Fri, 8 Nov 2024 15:18:53 +0100 Subject: Show earliest available statistic for new friends --- persistence/__init__.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'persistence/__init__.py') diff --git a/persistence/__init__.py b/persistence/__init__.py index 348ae59..4d50754 100644 --- a/persistence/__init__.py +++ b/persistence/__init__.py @@ -81,7 +81,7 @@ class StatsRepository: def get_stats(self, stats_datetime: datetime.datetime) -> typing.List[UserStats]: connection = self.__get_connection() cur = connection.cursor() - query = "SELECT * FROM stats WHERE stats_datetime IN (SELECT MIN(stats_datetime) FROM stats WHERE stats_datetime >= '{stats_datetime}')".format(stats_datetime = stats_datetime) + query = "SELECT * FROM stats a WHERE a.stats_datetime IN (SELECT MIN(b.stats_datetime) FROM stats b WHERE b.stats_datetime >= '{stats_datetime}' AND a.display_name = b.display_name)".format(stats_datetime = stats_datetime) cur.execute(query) result = cur.fetchall() return [self.__map_from_db(stats) for stats in result] -- cgit v1.2.3