GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  DBIX::SKINNY::INFLATECOLUMN::DATETIME::AUTO (3)

.ds Aq ’

NAME

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

CONTENTS

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.
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 DBIX::SKINNY::INFLATECOLUMN::DATETIME::AUTO (3) 2010-06-26

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.