1 package DBICTest::Schema::EventTZPg;
6 use base qw/DBICTest::BaseResult/;
8 __PACKAGE__->load_components(qw/InflateColumn::DateTime/);
10 __PACKAGE__->table('event');
12 __PACKAGE__->add_columns(
13 id => { data_type => 'integer', is_auto_increment => 1 },
14 starts_at => { data_type => 'datetime', timezone => "America/Chicago", locale => 'de_DE' },
15 created_on => { data_type => 'timestamp with time zone', timezone => "America/Chicago" },
16 ts_without_tz => { data_type => 'timestamp without time zone' },
19 __PACKAGE__->set_primary_key('id');
21 sub _datetime_parser {
22 require DateTime::Format::Pg;
23 DateTime::Format::Pg->new();
26 # this is for a reentrancy test, the duplication from above is intentional
27 __PACKAGE__->add_columns(
28 ts_without_tz => { data_type => 'timestamp without time zone', inflate_datetime => 1 },