[Dbix-class] DBIx::Class::InflateColumn::DateTime for DB2

[Takashi Karino]

Hi , Jess

Thank you for your quick reponse.
I'm looking forward to your next DateTime::Format::DB2 release.

anyway, I looked through DBIx::Class source file, then found out
inflate & deflate method are called at different timing with method
names are determined.

I don't have enough experience of DBIx::Class, so I don't give you a
good solution.

On 1/17/07, Jess Robinson <castaway at desert-island.demon.co.uk> wrote:
>
>
> On Tue, 16 Jan 2007, Takashi Karino wrote:
>
> > Hi, all
> >
> > I encountered a problem as below while tyring to use
> > DBIx::Class::InflateColumn::DateTime.
> >
> > 'register_column' method of DBIx::Class::InflateColumn::DateTime
> > changes 'timestamp' to 'datetime' internally, then call
> > 'parse_datetime' method of DateTime::Format::XX object.
> > but, DateTime::Format::DB2 doesn't have parse_datetime.
> >
> > So I have to make some fix for DBIx::Class::InflateColumn::DateTime to
> > call parse_timestamp or add parase(format)_datetime method to
> > DateTime::Format::DB2 as my code get done correctly.
> >
> > I think the fix for DateTime::Format::DB2 is easier, but DB2 actually
> > does't have datetime type unlike other DBMS (Oracle, MySQL).
> >
> > Could anyone give some comments which one is more appropriate.
>
>
> Hiho,
>
> Well, if someone could check that all DateTime::Format::X modules contain
> parse_ functions named after the appropriate datatypes, I would prefer to
> remove the "timestamp isa datetime" line in InflateColumn::DateTime.
>
> IIRC, some DBs have both, and the formatting isn't quite the same? MySQL
> 3.x anyone?
>
> However, it appears that I have a copy of DateTime::Format::DB2 here that
> I added parse_datetime to, so it could be it was decided the other way a
> while back and I forgot to release it.. so I'll do that.
>
> Jess
>
>
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
>

Best regards.
-- Takashi Karino