[Catalyst] DB Functions in the Schema

[fREW Schmidt]

I don't know the answer to this off the top of my head, but I do know that
you mailed it to the wrong people :-)  You are much more likey to get a good
answer if you send this to the DBIC ML.

Good luck!

On Aug 17, 2009 3:13 AM, "Trevor Phillips" <trevor.phillips at gmail.com>
wrote:

Is there an easy way to represent a DB function call as a named column
within a DBIx::Class schema?

eg;

If at the DB level I would do something like:
 select updated, from_unixtime(updated) as updated2 from mytable;
... can I have;

__PACKAGE__->add_columns(
  "updated", { data_type =3D> "TIMESTAMP" }
  "updated2", { something =3D> "from_unixtime(updated)", etc...}
...
);

Thanks.

--
Trevor Phillips  - http://dortamur.livejournal.com/
"On nights such as this, evil deeds are done. And good deeds, of
course. But mostly evil, on the whole."
     -- (Terry Pratchett, Wyrd Sisters)

_______________________________________________
List: Catalyst at lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20090817/4824d=
d65/attachment.htm