Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DBIx::Skinny::InflateCUsernContributedSPerlyDoInflateColumn::DateTime::Auto(3)

NAME
       DBIx::Skinny::InflateColumn::DateTime::Auto - DateTime inflate/deflate
       and auto	insert update time for DBIx::Skinny

SYNOPSIS
       Use this	module in your schema.

	 package Your::DB::Schema;
	 use DBIx::Skinny::Schema;
	 use DBIx::Skinny::InflateColumn::DateTime;

	 install_table table1 => {
	     pk	'id';
	     columns qw/id name	created_at updated_at/;
	 };

	 install_table table2 => {
	     pk	'id';
	     columns qw/id name	booked_on created_on updated_on/;
	 };

       In your app.

	 my $row = Your::DB->single('table1', {	id => 1	});
	 print $row->created_at->ymd;  # created_at is DateTime	object

DESCRIPTION
       DBIx::Skinny::InflateColumn::DateTime provides inflate/deflate settings
       for *_at/*_on columns.

       It also set trigger for pre_insert and pre_update.

       Its concept refer to DBIx::Class::InflateColumn::DateTime, and some
       factor from DBIx::Class::InflateColumn::DateTime::Auto
       (http://blog.hide-k.net/archives/2006/08/dbixclassauto_i.php).

INFLATE/DEFLATE
       This module installs inflate rule for /_(at|on)$/ columns.

       That columns will be inflated as	DateTime objects.

OPTIONS
   time_zone
       default time_zone is 'local'.

       set this	option if you decide other time_zone.

       Example:

	 use DBIx::Skinny::InflateColumn::DateTime (time_zone => DateTime::TimeZone->new(name => 'Asia/Tokyo'));

   rules
       default rules is	[qr/^.+_at$/, qr/^.+_on$/].

       set this	option if you decide other rules.

       Example:

	 use DBIx::Skinny::InflateColumn::DateTime (rules => [qr/^created$/, qr/^updated$/]);

   auto_insert_rules
       default rules is	[qr/^created_at$/, qr/^created_on$/, qr/^updated_at$/,
       qr/^updated_on$/].

       set this	option if you decide other rules.

       Example:

	 use DBIx::Skinny::InflateColumn::DateTime (auto_insert_rules => [qr/^created$/, qr/^updated$/]);

   auto_update_rules
       default rules is	[qr/^updated_at$/, qr/^updated_on$/].

       set this	option if you decide other rules.

       Example:

	 use DBIx::Skinny::InflateColumn::DateTime (auto_insert_rules => [qr/^updated$/]);

TRIGGERS
   pre_insert
       Set current time	stamp if column	match auto_insert_rules	and exists.

   pre_update
       Set current time	stamp if column	match auto_update_rules	and exists.

       Row object's columns will be updated as well.

AUTHOR
       Ryo Miyake <ryo.studiom {at} gmail.com>

SEE ALSO
       DBIx::Skinny, DBIx::Class::InflateColumn::DateTime

       http://blog.hide-k.net/archives/2006/08/dbixclassauto_i.php

AUTHOR
       Ryo Miyake  "<ryo.studiom __at__	gmail.com>"

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

perl v5.32.1			DBIx::Skinny::InflateColumn::DateTime::Auto(3)

NAME | SYNOPSIS | DESCRIPTION | INFLATE/DEFLATE | OPTIONS | TRIGGERS | AUTHOR | SEE ALSO | AUTHOR | LICENSE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=DBIx::Skinny::InflateColumn::DateTime::Auto&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help