NAME
Tangram::DateTime - map date & time fields
SYNOPSIS
use Tangram;
# or
use Tangram::Core;
use Tangram::RawDate; # rawdate
use Tangram::RawTime; # rawtime
use Tangram::RawDateTime; # rawdatetime
use Tangram::DMDateTime; # dmdatetime
$schema = Tangram::Schema->new(
classes => { NaturalPerson => { fields => {
rawdatetime => [ qw( birth death ) ],
rawdate => [ qw( beginVacation endVacation ) ],
rawtime => [ qw( breakfast lunch dinner ) ],
dmdatetime => [ qw( attack retreat ) ],
DESCRIPTION
These classes are responsible for mapping strings to SQL date or time types. These classes are not imported by Tangram.pm, thus they must be explicitly imported via a use
directive.
The three typetags rawdate
, rawtime
and rawdatetime
are for mapping strings to SQL date/time types. 'Raw' means that Tangram doesn't attempt to interpret the strings, it merely passes them down to DBI.
dmdatetime
is like rawdatetime
except that the date is converted to the Date::Manip internal format. This mapping was contributed by Gabor Herr <herr@iti.informatik.tu-darmstadt.de>.
The persistent fields may be specified either as a hash or as an array of field names.
In the hash form, each entry consists in a field name and an associated option hash. The option hash may contain the following fields:
col
sql
col
sets the name of the column used to store the field's value. This field is optional, it defaults to the persistent field name. Override if the field name is not an acceptable SQL column name.
sql
sets the SQL type of the column. Used by Schema::deploy() when initializing a database. Defaults to 'VARCHAR(255) NULL' for strings, 'INT NULL' for ints and 'REAL NULL' for reals.
The persistent fields may also be specified as an array of strings, in which case the defaults are used.