| 1 | package DBIO::PostgreSQL::Test::EventTZPg; | ||
| 2 | # ABSTRACT: Test result class for PostgreSQL timezone-aware datetime inflation | ||
| 3 | |||
| 4 | 1 | ▶ | use strict; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 5 | 1 | ▶ | use warnings; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 6 | |||
| 7 | 1 | our $VERSION = '0.900007'; | |
| 8 | |||
| 9 | 1 | ▶ | use base qw/DBIO::Test::BaseResult/; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 10 | |||
| 11 | 1 | __PACKAGE__->load_components(qw/InflateColumn::DateTime/); | |
| 12 | |||
| 13 | 1 | __PACKAGE__->table('event'); | |
| 14 | |||
| 15 | 1 | __PACKAGE__->add_columns( | |
| 16 | id => { data_type => 'integer', is_auto_increment => 1 }, | ||
| 17 | |||
| 18 | starts_at => { data_type => 'date', datetime_undef_if_invalid => 1 }, | ||
| 19 | |||
| 20 | created_on => { | ||
| 21 | data_type => 'timestamp with time zone', | ||
| 22 | timezone => 'America/Chicago', | ||
| 23 | }, | ||
| 24 | varchar_date => { data_type => 'varchar', size => 20, is_nullable => 1 }, | ||
| 25 | varchar_datetime => { data_type => 'varchar', size => 20, is_nullable => 1 }, | ||
| 26 | skip_inflation => { data_type => 'datetime', inflate_datetime => 0, is_nullable => 1 }, | ||
| 27 | ts_without_tz => { data_type => 'timestamp without time zone', is_nullable => 1 }, | ||
| 28 | ); | ||
| 29 | |||
| 30 | 1 | __PACKAGE__->set_primary_key('id'); | |
| 31 | |||
| 32 | 1 | 1; | |
| 33 | |||
| 34 | __END__ | ||