/ 
Data-FormValidator-Constraints-DateTime-0.03
River stage one • 1 direct dependent • 2 total dependents
/ Data::FormValidator::Constraints::DateTime

NAME

Data::FormValidator::Constraints::DateTime - D::FV constraints for dates and times

DESCRIPTION

The package provides constraint routines for Data::FormValidator for dealing with dates and times. It provides an easy mechanism for validating dates of any format (using strptime(3)) and transforming those dates into valid DateTime objects, or into strings that would be properly formatted for various database engines.

ABSTRACT

use Data::FormValidator;
use Data::FormValidator::Constraints::DateTime qw(:all);
  
# create our profile
my $profile = {
    validator_packages      => [qw(Data::FormValidator::Constraints::DateTime)],
    required                => [qw(my_date)],
    constraints             => {
        # my_date is in the format MM/DD/YYYY
        my_date   => {
          constraint_method   => 'to_datetime',
          params              => [\'%D'], # some valid strptime format string
        },
    },
    untaint_all_constraints => 1,
};

# validate 'my_date'
my $results = Data::FormValidator->check($my_input, $profile);

unless( $results->has_missing || $results->has_invalid ) {
  # if we got here then $results->valid('my_date')
  # is a valid DateTime object 
}

STRPTIME FORMATS

All of the validation routines exported by this module use strptime(3) format strings to know what format your date string is in before we can process it. You specify this format foreach date you want to validate using the 'params' array ref (see the example above).

We use DateTime::Format::Strptime for this transformation. If you need a list of these formats (if you haven't yet committed them to memory) you can see the strptime(3) man page (if you are on a *nix system) or you can see the DateTime::Format::Strptime documentation.

There are however some routines that can live without the format param. These include routines which try and validate according to rules for a particular database (to_mysql_* and to_pg_*). If no format is provided, then we will attempt to validate according to the rules for that datatype in that database (using DateTime::Format::MySQL and DateTime::Format::Pg). See each validation routine for examples.

VALIDATION ROUTINES

Following is a list of validation subroutines that can be exported by this module.

to_datetime

The routine will change the date string into a DateTime object

to_mysql_datetime

The routine will change the date string into a DATETIME datatype suitable for MySQL

to_mysql_date

The routine will change the date string into a DATE datatype suitable for MySQL

to_mysql_timestamp

The routine will change the date string into a TIMESTAMP datatype suitable for MySQL

to_pg_datetime

The routine will change the date string into a DATETIME datatype suitable for PostgreSQL

AUTHOR

Michael Peters <mpeters@plusthree.com>

Thanks to Plus Three, LP (http://www.plusthree.com) for sponsoring my work on this module

CONTRIBUTORS

Mark Stosberg <mark@summersault.com>
Charles Frank <cfrank@plusthree.com>

SUPPORT

This module is a part of the large Data::FormValidator project. If you have questions, comments, bug reports or feature requests, please join the Data::FormValidator's mailing list.

SEE ALSO

Data::FormValidator, DateTime. DateTime::Format::Strptime, DateTime::Format::MySQL, DateTime::Format::Pg