X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FInflateColumn%2FDateTime.pm;h=a650d69b83ba30e09974d35b5cacac821d1bd59a;hb=c27646a3d7f0945c7d14f2ba551667335e93f5f6;hp=3734b716487abbc751ab4d96c7cb0cf42014c58d;hpb=ae74c3bf530ac1b404352fbfcccb7ad6292c8569;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/InflateColumn/DateTime.pm b/lib/DBIx/Class/InflateColumn/DateTime.pm index 3734b71..a650d69 100644 --- a/lib/DBIx/Class/InflateColumn/DateTime.pm +++ b/lib/DBIx/Class/InflateColumn/DateTime.pm @@ -11,10 +11,10 @@ DBIx::Class::InflateColumn::DateTime - Auto-create DateTime objects from date an =head1 SYNOPSIS Load this component and then declare one or more -columns to be of the datetime or date datatype. +columns to be of the datetime, timestamp or date datatype. package Event; - __PACKAGE__->load_components(qw/InflateColumn::DateTime/); + __PACKAGE__->load_components(qw/InflateColumn::DateTime Core/); __PACKAGE__->add_columns( starts_when => { data_type => 'datetime' } ); @@ -24,6 +24,12 @@ Then you can treat the specified column as a L object. print "This event starts the month of ". $event->starts_when->month_name(); +If you want to set a specific timezone for that field, use: + + __PACKAGE__->add_columns( + starts_when => { data_type => 'datetime', extra => { timezone => "America/Chicago" } } + ); + =head1 DESCRIPTION This module figures out the type of DateTime::Format::* class to @@ -33,6 +39,8 @@ one your code should continue to work without modification (though note that this feature is new as of 0.07, so it may not be perfect yet - bug reports to the list very much welcome). +For more help with using components, see L. + =cut __PACKAGE__->load_components(qw/InflateColumn/); @@ -52,7 +60,12 @@ sub register_column { $self->next::method($column, $info, @rest); return unless defined($info->{data_type}); my $type = lc($info->{data_type}); - $type = 'datetime' if ($type eq 'timestamp'); + $type = 'datetime' if ($type =~ /^timestamp/); + my $timezone; + if ( exists $info->{extra} and exists $info->{extra}{timezone} and defined $info->{extra}{timezone} ) { + $timezone = $info->{extra}{timezone}; + } + if ($type eq 'datetime' || $type eq 'date') { my ($parse, $format) = ("parse_${type}", "format_${type}"); $self->inflate_column( @@ -60,10 +73,13 @@ sub register_column { { inflate => sub { my ($value, $obj) = @_; - $obj->_datetime_parser->$parse($value); + my $dt = $obj->_datetime_parser->$parse($value); + $dt->set_time_zone($timezone) if $timezone; + return $dt; }, deflate => sub { my ($value, $obj) = @_; + $value->set_time_zone($timezone) if $timezone; $obj->_datetime_parser->$format($value); }, }