documented methods for detecting replicant reliability, created stub methods
[dbsrgits/DBIx-Class.git] / t / 89inflate_datetime.t
1 use strict;
2 use warnings;
3
4 use Test::More;
5 use lib qw(t/lib);
6 use DBICTest;
7
8 my $schema = DBICTest->init_schema();
9
10 eval { require DateTime::Format::MySQL };
11 plan skip_all => "Need DateTime::Format::MySQL for inflation tests" if $@;
12
13 plan tests => 17;
14
15 # inflation test
16 my $event = $schema->resultset("Event")->find(1);
17
18 isa_ok($event->starts_at, 'DateTime', 'DateTime returned');
19
20 # klunky, but makes older Test::More installs happy
21 my $starts = $event->starts_at;
22 is("$starts", '2006-04-25T22:24:33', 'Correct date/time');
23
24 # create using DateTime
25 my $created = $schema->resultset('Event')->create({
26     starts_at => DateTime->new(year=>2006, month=>6, day=>18),
27     created_on => DateTime->new(year=>2006, month=>6, day=>23)
28 });
29 my $created_start = $created->starts_at;
30
31 isa_ok($created->starts_at, 'DateTime', 'DateTime returned');
32 is("$created_start", '2006-06-18T00:00:00', 'Correct date/time');
33
34 ## timestamp field
35 isa_ok($event->created_on, 'DateTime', 'DateTime returned');
36
37 # klunky, but makes older Test::More installs happy
38 my $createo = $event->created_on;
39 is("$createo", '2006-06-22T21:00:05', 'Correct date/time');
40
41 my $created_cron = $created->created_on;
42
43 isa_ok($created->created_on, 'DateTime', 'DateTime returned');
44 is("$created_cron", '2006-06-23T00:00:00', 'Correct date/time');
45
46
47 # Test "timezone" parameter
48 my $event_tz = $schema->resultset('EventTZ')->create({
49     starts_at => DateTime->new(year=>2007, month=>12, day=>31, time_zone => "America/Chicago" ),
50     created_on => DateTime->new(year=>2006, month=>1, day=>31,
51         hour => 13, minute => 34, second => 56, time_zone => "America/New_York" ),
52 });
53
54 my $starts_at = $event_tz->starts_at;
55 is("$starts_at", '2007-12-31T00:00:00', 'Correct date/time using timezone');
56
57 my $created_on = $event_tz->created_on;
58 is("$created_on", '2006-01-31T12:34:56', 'Correct timestamp using timezone');
59 is($event_tz->created_on->time_zone->name, "America/Chicago", "Correct timezone");
60
61 my $loaded_event = $schema->resultset('EventTZ')->find( $event_tz->id );
62
63 isa_ok($loaded_event->starts_at, 'DateTime', 'DateTime returned');
64 $starts_at = $loaded_event->starts_at;
65 is("$starts_at", '2007-12-31T00:00:00', 'Loaded correct date/time using timezone');
66 is($starts_at->time_zone->name, 'America/Chicago', 'Correct timezone');
67
68 isa_ok($loaded_event->created_on, 'DateTime', 'DateTime returned');
69 $created_on = $loaded_event->created_on;
70 is("$created_on", '2006-01-31T12:34:56', 'Loaded correct timestamp using timezone');
71 is($created_on->time_zone->name, 'America/Chicago', 'Correct timezone');
72