I'm interested in doing complex joins with RDBO but without having to map the results to specific Rose::DB::Object classes.
I found a discussion along these lines from '05. http://www.gossamer-threads.com/lists/catalyst/users/3095 excerpt: "For funky SQL in the FROM clause or the column list, then it's really raw SQL time. But in that situation, it's usually difficult or impossible for an ORM to do anything sensible with the results. Let's say I do a weird 6-table join, selecting columns from various (but not all) tables, plus a bunch of derived values and sub-selected values and function calls. Doing fetchrow_hashref on that gives me a pretty opaque hash. Unless there's a ORM class that exactly matches the name, number, and type of columns returned, there's not much that can be automated." The features I'm interested in are: o Providing a somewhat consistent interface between these ad-hoc result sets and normal RDBO objects. o Catching field typos which the accessors/mutators would give you. (although you could do the same by locking the hash refs from DBI, obviously). o Inflating columns. Mainly datestamps/timestamps, but those come up a lot. It would use the $sth->{TYPE} info to provide default inflation logic. I don't care about being able to "save" these objects or it having any knowledge of foreign relationships. Is there any support for this currently with RDBO? Thanks, Maurice ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
