From 9d4f3f8ce124023f704d5ca1a9e7a87029b43073 Mon Sep 17 00:00:00 2001 From: Daniel Friesel Date: Fri, 3 Sep 2021 20:24:54 +0200 Subject: Ensure that database timezone matches IRIS time zone All travelynx and IRIS timestamps are Europe/Berlin. And the DateTime objects know that they are Europe/Berlin. However, when inserting into a timestamp with time zone column, Mojo::Pg or one of the backend DBI/DBD libraries does not respect the time zone. So, UTC+1 or UTC+2 timestamps are treated as UTC+0, resulting in major mayhem. --- lib/Travelynx.pm | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'lib') diff --git a/lib/Travelynx.pm b/lib/Travelynx.pm index 2618191..8ef5fbf 100755 --- a/lib/Travelynx.pm +++ b/lib/Travelynx.pm @@ -369,6 +369,15 @@ sub startup { state $pg = Mojo::Pg->new("postgresql://${user}\@${host}:${port}/${dbname}") ->password($pw); + + $pg->on( + connection => sub { + my ( $pg, $dbh ) = @_; + $dbh->do("set time zone 'Europe/Berlin'"); + } + ); + + return $pg; } ); -- cgit v1.2.3