I have done stuff like that in the past by using the DBIx::Class::DynamicDefault module. There may be a better way to do it, though, so it is probably worth asking on the DBIC mailing list.
-- Lee On Mon, 17 Aug 2009 16:12:58 +0800 Trevor Phillips <[email protected]> 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 => "TIMESTAMP" } > "updated2", { something => "from_unixtime(updated)", etc...} > ... > ); > > Thanks. > _______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
