Dave Cross: Still Munging Data With Perl: Online event - Mar 17 Learn more

use strict;
use Carp();
our @ISA = qw(Rose::DB::Object::Metadata::Column);
our $VERSION = '0.788';
__PACKAGE__->add_common_method_maker_argument_names('default', 'precision', 'scale');
Rose::Object::MakeMethods::Generic->make_methods
(
{ preserve_existing => 1 },
scalar => [ __PACKAGE__->common_method_maker_argument_names ]
);
foreach my $type (__PACKAGE__->available_method_types)
{
__PACKAGE__->method_maker_class($type => 'Rose::DB::Object::MakeMethods::Time');
__PACKAGE__->method_maker_type($type => 'time');
}
sub type { 'time' }
sub init_with_dbi_column_info
{
my($self, $col_info) = @_;
$self->SUPER::init_with_dbi_column_info($col_info);
$self->scale($col_info->{'TIME_SCALE'})
if(defined $col_info->{'TIME_SCALE'});
$self->precision($col_info->{'TIME_PRECISION'})
if(defined $col_info->{'TIME_PRECISION'});
return;
}
sub should_inline_value
{
my($self, $db, $value) = @_;
no warnings 'uninitialized';
return (($db->validate_time_keyword($value) && $db->should_inline_time_keyword($value)) ||
($db->keyword_function_calls && $value =~ /^\w+\(.*\)$/)) ? 1 : 0;
}
sub method_should_set
{
my($self, $type, $args) = @_;
return 1 if($type eq 'set' || $type eq 'get_set');
return 0 if($type eq 'get');
return $self->SUPER::method_should_set($type, $args);
}
sub parse_value { shift; shift->parse_time(@_) }
sub format_value { shift; shift->format_time(@_) }
sub method_uses_formatted_key
{
my($self, $type) = @_;
return 1 if($type eq 'get' || $type eq 'set' || $type eq 'get_set');
return 0;
}
use constant DEFAULT_PRECISION => 6; # HHMMSS
use constant DEFAULT_SCALE => 0; # HHMMSS (no fractional seconds)
sub precision
{
my($self) = shift;
if(@_)
{
my $p = shift;
unless($p == 2 || $p == 4 || $p >= 6)
{
Carp::croak "Invalid precision: $p. Time column precision must be 2, 4, or >= 6";
}
$self->{'precision'} = $p;
$self->{'scale'} = $self->{'precision'} - DEFAULT_PRECISION;
$self->{'scale'} = 0 if($self->{'scale'} < 0);
return $self->{'precision'};
}
return $self->{'precision'} if(defined $self->{'precision'});
return $self->{'precision'} = DEFAULT_PRECISION;
}
sub scale
{
my($self) = shift;
if(@_)
{
$self->{'scale'} = defined $_[0] ? $_[0] : 0;
$self->{'precision'} = DEFAULT_PRECISION + $self->{'scale'};
return $self->{'scale'};
}
return $self->{'scale'} if(defined $self->{'scale'});
return $self->{'scale'} = DEFAULT_PRECISION;
}
1;
__END__
=head1 NAME
Rose::DB::Object::Metadata::Column::Time - Time column metadata.
=head1 SYNOPSIS
use Rose::DB::Object::Metadata::Column::Time;
$col = Rose::DB::Object::Metadata::Column::Time->new(...);
$col->make_methods(...);
...
=head1 DESCRIPTION
Objects of this class store and manipulate metadata for time columns in a database. Column metadata objects store information about columns (data type, size, etc.) and are responsible for creating object methods that manipulate column values.
This class inherits from L<Rose::DB::Object::Metadata::Column>. Inherited methods that are not overridden will not be documented a second time here. See the L<Rose::DB::Object::Metadata::Column> documentation for more information.
=head1 METHOD MAP
=over 4
=item C<get_set>
L<Rose::DB::Object::MakeMethods::Generic>, L<date|Rose::DB::Object::MakeMethods::Time/time>, ...
=item C<get>
L<Rose::DB::Object::MakeMethods::Time>, L<date|Rose::DB::Object::MakeMethods::Time/time>, ...
=item C<get_set>
L<Rose::DB::Object::MakeMethods::Time>, L<date|Rose::DB::Object::MakeMethods::Time/time>, ...
=back
See the L<Rose::DB::Object::Metadata::Column|Rose::DB::Object::Metadata::Column/"MAKING METHODS"> documentation for an explanation of this method map.
=head1 OBJECT METHODS
=over 4
=item B<parse_value DB, VALUE>
Convert VALUE to the equivalent L<Time::Clock> object. VALUE maybe returned unmodified if it is a valid time keyword or otherwise has special meaning to the underlying database. DB is a L<Rose::DB> object that is used as part of the parsing process. Both arguments are required.
=item B<precision [INT]>
Get or set the precision of the time value. The precision is the total count of digits in the whole time. For example, 12:34 has a precision of 4, and 12:34:56.12 has a precision of 8. The precision value must be 2, 4, or greater than or equal to 6. The default precision is 6. When the precision is set, the L<scale|/scale> is also set automatically.
=item B<scale [INT]>
Get or set the integer number of places past the decimal point preserved for fractional seconds. The default scale is 0. When the scale is set, the L<precision|/precision> is also set automatically.
Returns "time".
=item B<type>
Returns "time".
=back
=head1 AUTHOR
John C. Siracusa (siracusa@gmail.com)
=head1 LICENSE
Copyright (c) 2010 by John C. Siracusa. All rights reserved. This program is
free software; you can redistribute it and/or modify it under the same terms
as Perl itself.