X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F89inflate_datetime.t;h=d92340c95d05982498ee513a3bc34cd7aac8d1ec;hb=9cf15d4b69b6171e139ea012184334bc9f6f6f54;hp=a3bc58219307304e867cd480d3675f6c3ee44386;hpb=6d2d616060ab47feb43935bd6712f586eb313c8e;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/89inflate_datetime.t b/t/89inflate_datetime.t index a3bc582..d92340c 100644 --- a/t/89inflate_datetime.t +++ b/t/89inflate_datetime.t @@ -10,7 +10,7 @@ my $schema = DBICTest->init_schema(); eval { require DateTime::Format::MySQL }; plan skip_all => "Need DateTime::Format::MySQL for inflation tests" if $@; -plan tests => 8; +plan tests => 17; # inflation test my $event = $schema->resultset("Event")->find(1); @@ -42,3 +42,31 @@ my $created_cron = $created->created_on; isa_ok($created->created_on, 'DateTime', 'DateTime returned'); is("$created_cron", '2006-06-23T00:00:00', 'Correct date/time'); + + +# Test "timezone" parameter +my $event_tz = $schema->resultset('EventTZ')->create({ + starts_at => DateTime->new(year=>2007, month=>12, day=>31, time_zone => "America/Chicago" ), + created_on => DateTime->new(year=>2006, month=>1, day=>31, + hour => 13, minute => 34, second => 56, time_zone => "America/New_York" ), +}); + +my $starts_at = $event_tz->starts_at; +is("$starts_at", '2007-12-31T00:00:00', 'Correct date/time using timezone'); + +my $created_on = $event_tz->created_on; +is("$created_on", '2006-01-31T12:34:56', 'Correct timestamp using timezone'); +is($event_tz->created_on->time_zone->name, "America/Chicago", "Correct timezone"); + +my $loaded_event = $schema->resultset('EventTZ')->find( $event_tz->id ); + +isa_ok($loaded_event->starts_at, 'DateTime', 'DateTime returned'); +$starts_at = $loaded_event->starts_at; +is("$starts_at", '2007-12-31T00:00:00', 'Loaded correct date/time using timezone'); +is($starts_at->time_zone->name, 'America/Chicago', 'Correct timezone'); + +isa_ok($loaded_event->created_on, 'DateTime', 'DateTime returned'); +$created_on = $loaded_event->created_on; +is("$created_on", '2006-01-31T12:34:56', 'Loaded correct timestamp using timezone'); +is($created_on->time_zone->name, 'America/Chicago', 'Correct timezone'); +