From 5d8a3d623e982425a5bbb0dfd003fc3cce8d2843 Mon Sep 17 00:00:00 2001 From: user Date: Fri, 29 Mar 2024 10:52:25 +0100 Subject: chart - show 3 days --- src/db_handler.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src') diff --git a/src/db_handler.py b/src/db_handler.py index 4d834e8..9556d6c 100644 --- a/src/db_handler.py +++ b/src/db_handler.py @@ -63,7 +63,7 @@ def get_histogram_detailed() -> str: SELECT count(la.id) as total_count, date_trunc('hour', la.timestamp) as date, cn.ip FROM login_attempt la JOIN connection cn on cn.id = la.connection -WHERE la.timestamp BETWEEN (select max(timestamp) from login_attempt) - interval '2 days' AND (select max(timestamp) from login_attempt) +WHERE la.timestamp BETWEEN (select max(timestamp) from login_attempt) - interval '3 days' AND (select max(timestamp) from login_attempt) GROUP BY date_trunc('hour', la.timestamp), cn.ip ORDER BY COUNT(la.id) DESC ; -- cgit v1.2.3