diff options
| author | user <user@node5.net> | 2024-03-23 22:58:48 +0100 |
|---|---|---|
| committer | user <user@node5.net> | 2024-03-23 22:58:48 +0100 |
| commit | 0a3b0a01f704b519bc44e6ca33ba5b833ff93244 (patch) | |
| tree | 6916f729da9bd20e969a9fa694ac7cccd0b2efaf /src/db_handler.py | |
| parent | a16451a7a1a168d1362004ff951f73bb57c64e29 (diff) | |
fix chart
Diffstat (limited to 'src/db_handler.py')
| -rw-r--r-- | src/db_handler.py | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/src/db_handler.py b/src/db_handler.py index 033b11a..1c271d6 100644 --- a/src/db_handler.py +++ b/src/db_handler.py @@ -64,8 +64,7 @@ SELECT count(la.id) as total_count, date_trunc('hour', la.timestamp) as date, cn FROM login_attempt la JOIN connection cn on cn.id = la.connection GROUP BY date_trunc('hour', la.timestamp), cn.ip -ORDER BY date_trunc('hour', la.timestamp) DESC -LIMIT 48; +ORDER BY date_trunc('hour', la.timestamp) DESC; ; """) histogram = cur.fetchall() |