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=27ceaeb7090186425c4cb073fdc2d4565876e92b;hpb=de78905bf27ab9812561dd590da5841e72c0581a;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/lib/DBIx/Class/InflateColumn/DateTime.pm b/lib/DBIx/Class/InflateColumn/DateTime.pm index 27ceaeb..a650d69 100644 --- a/lib/DBIx/Class/InflateColumn/DateTime.pm +++ b/lib/DBIx/Class/InflateColumn/DateTime.pm @@ -14,7 +14,7 @@ Load this component and then declare one or more 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,7 +39,7 @@ 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 components, see L. +For more help with using components, see L. =cut @@ -54,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( @@ -62,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); }, }