DBIx::Class::DateTime::Epoch man page on Pidora

Man page or keyword search:  
man Server   31170 pages
apropos Keyword Search (all sections)
Output format
Pidora logo
[printable version]

DBIx::Class::DateTime:UsercContributed Perl DocDBIx::Class::DateTime::Epoch(3)

NAME
       DBIx::Class::DateTime::Epoch - Automatic inflation/deflation of
       epoch-based columns to/from DateTime objects

SYNOPSIS
	   package MySchema::Foo;

	   use base qw( DBIx::Class );

	   __PACKAGE__->load_components( qw( DateTime::Epoch TimeStamp Core ) );
	   __PACKAGE__->add_columns(
	       name => {
		   data_type => 'varchar',
		   size	     => 10,
	       },
	       bar => { # epoch stored as an int
		   data_type	    => 'bigint',
		   inflate_datetime => 1,
	       },
	       baz => { # epoch stored as a string
		   data_type	    => 'varchar',
		   size		    => 50,
		   inflate_datetime => 'epoch',
	       },
	       # working in conjunction with DBIx::Class::TimeStamp
	       creation_time => {
		   data_type	    => 'bigint',
		   inflate_datetime => 1,
		   set_on_create    => 1,
	       },
	       modification_time => {
		   data_type	    => 'bigint',
		   inflate_datetime => 1,
		   set_on_create    => 1,
		   set_on_update    => 1,
	       }
	   );

DESCRIPTION
       This module automatically inflates/deflates DateTime objects from/to
       epoch values for the specified columns. This module is essentially an
       extension to DBIx::Class::InflateColumn::DateTime so all of the
       settings, including "locale" and "timezone", are also valid.

       A column will be recognized as an epoch time given one of the following
       scenarios:

       ·   "data_type" is an "int" of some sort and "inflate_datetime" is also
	   set to a true value

       ·   "data_type" is some other value (e.g. "varchar") and
	   "inflate_datetime" is explicitly set to "epoch".

       DBIx::Class::TimeStamp can also be used in conjunction with this module
       to support epoch-based columns that are automatically set on creation
       of a row and updated subsequent modifications.

METHODS
   add_columns( )
       Provides backwards compatibility with the older DateTime::Epoch API.

   _inflate_to_datetime( )
       Overrides column inflation to use "Datetime->from_epoch".

   _deflate_from_datetime( )
       Overrides column deflation to call "epoch()" on the column value.

SEE ALSO
       ·   DBIx::Class

       ·   DBIx::Class::TimeStamp

       ·   DateTime

AUTHORS
       Brian Cassidy <bricas@cpan.org>

       Adam Paynter <adapay@cpan.org>

COPYRIGHT AND LICENSE
       Copyright 2006-2011 by Brian Cassidy

       This library is free software; you can redistribute it and/or modify it
       under the same terms as Perl itself.

perl v5.14.1			  2011-01-18   DBIx::Class::DateTime::Epoch(3)
[top]

List of man pages available for Pidora

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net