summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorDaniel Friesel <derf@finalrewind.org>2021-04-05 09:38:08 +0200
committerDaniel Friesel <derf@finalrewind.org>2021-04-05 09:46:28 +0200
commit1f3b3c742ce91a722d713fada8f5d5829ed0ae7a (patch)
tree1ffcb2c3515b6b536d461d773179be7809a56d69 /lib
parent11727e0f99decf316ae19e6ccf0321610ab7a6f5 (diff)
munin: fix date range calculation
TODO: handle CET -> CEST transition (there's a day each year where 2am does not exist and DateTime does not like it)
Diffstat (limited to 'lib')
-rw-r--r--lib/Travelynx/Command/munin.pm16
1 files changed, 9 insertions, 7 deletions
diff --git a/lib/Travelynx/Command/munin.pm b/lib/Travelynx/Command/munin.pm
index 5e67f5a..28dae18 100644
--- a/lib/Travelynx/Command/munin.pm
+++ b/lib/Travelynx/Command/munin.pm
@@ -1,4 +1,5 @@
package Travelynx::Command::munin;
+
# Copyright (C) 2020 Daniel Friesel
#
# SPDX-License-Identifier: AGPL-3.0-or-later
@@ -48,16 +49,17 @@ sub run {
query_to_munin(
'checkins_24h',
$db->query( $checkin_window_query,
- $now->subtract( hours => 24 )->epoch )->hash->{count}
+ $now->clone->subtract( hours => 24 )->epoch )->hash->{count}
+ );
+ query_to_munin(
+ 'checkins_7d',
+ $db->query( $checkin_window_query,
+ $now->clone->subtract( days => 7 )->epoch )->hash->{count}
);
- query_to_munin( 'checkins_7d',
- $db->query( $checkin_window_query, $now->subtract( days => 7 )->epoch )
- ->hash->{count} );
query_to_munin(
'checkins_30d',
- $db->query(
- $checkin_window_query, $now->subtract( days => 30 )->epoch
- )->hash->{count}
+ $db->query( $checkin_window_query,
+ $now->clone->subtract( days => 30 )->epoch )->hash->{count}
);
query_to_munin( 'polylines',
$db->select( 'polylines', 'count(*) as count' )->hash->{count} );