From fd6d12d355e5fb5596168b91affe71eb059c0e99 Mon Sep 17 00:00:00 2001
From: Daniel Friesel <derf@finalrewind.org>
Date: Sun, 28 Apr 2019 22:33:09 +0200
Subject: Handle inconsistent data when calculating monthly/yearly stats

Closes #11
---
 lib/Travelynx/Command/database.pm | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'lib/Travelynx')

diff --git a/lib/Travelynx/Command/database.pm b/lib/Travelynx/Command/database.pm
index b5e8cf5..bd22512 100644
--- a/lib/Travelynx/Command/database.pm
+++ b/lib/Travelynx/Command/database.pm
@@ -330,6 +330,19 @@ my @migrations = (
 		}
 		$db->update( 'schema_version', { version => 4 } );
 	},
+
+	# v4 -> v5
+	# Handle inconsistent data (overlapping journeys) in statistics. Introduces
+	# the "inconsistencies" stats key -> rebuild all stats.
+	sub {
+		my ($db) = @_;
+		$db->query(
+			qq{
+				truncate journey_stats;
+				update schema_version set version = 5;
+			}
+		);
+	},
 );
 
 sub setup_db {
-- 
cgit v1.2.3