Hi everyone.
I have some questions about using both InflateColumn::DateTime and TimeStamp in my schema.
First of all, scenario:
1. I am creating a Catalyst application where the end-user (the one who installs the application) specifies in which timezone datetime objects will be saved in the schema.
2. The timezone he has specified is saved in the schema itself, so it's accessible from the schema itself and not from the Catalyst application only.
3. I want certain columns to be set on create and on update automatically, and in the timezone the user has chosen.
4. It is more than probable that the timezone the end-user has chosen is different than their system's local time.
My questions:
1. InflateColumn::DateTime allows me to specify a timezone hard coded in the schema. I can't use this because it's the end-user's decision. What can I do?
2. Does TimeStamp take any timezone into account, or instead uses a floating time zone or local time or whatever?
3. TimeStamp's documentation mentions I can override the get_timestamp method. Am I supposed to do that for every resultset in the schema? If so, that's bad, because it means I have to duplicate the same code for every table in the database.
Any help greatly appreciated,
Ido Perlmuter.
_______________________________________________
List:
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-classIRC: irc.perl.org#dbix-class
SVN:
http://dev.catalyst.perl.org/repos/bast/DBIx-Class/Searchable Archive:
http://www.grokbase.com/group/dbix-class@...
