From 574e83d56727a088d57d4bb1c7dcd37a2c67f1fd Mon Sep 17 00:00:00 2001
From: Daniel Friesel <derf@finalrewind.org>
Date: Sun, 7 Mar 2021 19:06:21 +0100
Subject: Move incomplete checkin removal from "maintenance" to "work" task

---
 lib/Travelynx/Command/work.pm | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

(limited to 'lib/Travelynx/Command/work.pm')

diff --git a/lib/Travelynx/Command/work.pm b/lib/Travelynx/Command/work.pm
index 961a48c..24621b5 100644
--- a/lib/Travelynx/Command/work.pm
+++ b/lib/Travelynx/Command/work.pm
@@ -17,11 +17,19 @@ has usage => sub { shift->extract_usage };
 sub run {
 	my ($self) = @_;
 
-	my $now  = DateTime->now( time_zone => 'Europe/Berlin' );
-	my $json = JSON->new;
+	my $now              = DateTime->now( time_zone => 'Europe/Berlin' );
+	my $checkin_deadline = $now->clone->subtract( hours => 48 );
+	my $json             = JSON->new;
 
 	my $db = $self->app->pg->db;
 
+	my $res = $db->delete( 'in_transit',
+		{ checkin_time => { '<', $checkin_deadline } } );
+
+	if ( my $rows = $res->rows ) {
+		$self->app->log->debug("Removed ${rows} incomplete checkins");
+	}
+
 	for my $entry (
 		$db->select( 'in_transit_str', '*', { cancelled => 0 } )->hashes->each )
 	{
-- 
cgit v1.2.3