Restore 'timezone' field in column info ( extends eef9b484 )

[dbsrgits/DBIx-Class.git] / t / icdt / offline_pg.t

BEGIN { do "./t/lib/ANFANG.pm" or die ( $@ || $! ) }
use DBIx::Class::Optional::Dependencies -skip_all_without => qw( ic_dt_pg );

use strict;
use warnings;

use Test::More;
use Test::Warn;

use DBICTest;

DBICTest::Schema->load_classes('EventTZPg');

{
  my $s = DBICTest::Schema->connect('dbi:Pg:whatever');

  ok (!$s->storage->_dbh, 'definitely not connected');

  # Check that datetime_parser returns correctly before we explicitly connect.
  my $store = ref $s->storage;
  is($store, 'DBIx::Class::Storage::DBI', 'Started with generic storage');

  my $parser = $s->storage->datetime_parser;
  is( $parser, 'DateTime::Format::Pg', 'datetime_parser is as expected');

  my $colinfo = $s->source('EventTZPg')->column_info('created_on');
  is (
    $colinfo->{timezone},
    $colinfo->{time_zone},
    'Legacy timezone key is still present in colinfo',
  );

  ok (!$s->storage->_dbh, 'still not connected');
}

my $schema = DBICTest->init_schema();

# this may generate warnings under certain CI flags, hence do it outside of
# the warnings_are below
my $dt = DateTime->new( year => 2000, time_zone => "America/Chicago" );

warnings_are {
  my $event = $schema->resultset("EventTZPg")->find(1);
  $event->update({created_on => '2009-01-15 17:00:00+00'});
  $event->discard_changes;
  isa_ok($event->created_on, "DateTime") or diag $event->created_on;
  is($event->created_on->time_zone->name, "America/Chicago", "Timezone changed");
  # Time zone difference -> -6hours
  is($event->created_on->iso8601, "2009-01-15T11:00:00", "Time with TZ correct");

# test 'timestamp without time zone'
  my $dt = DateTime->from_epoch(epoch => time);
  $dt->set_nanosecond(int 500_000_000);
  $event->update({ts_without_tz => $dt});
  $event->discard_changes;
  isa_ok($event->ts_without_tz, "DateTime") or diag $event->created_on;
  is($event->ts_without_tz, $dt, 'timestamp without time zone inflation');
  is($event->ts_without_tz->microsecond, $dt->microsecond,
    'timestamp without time zone microseconds survived');
} [], 'No warnings during DT manipulations';

done_testing;