Hi All [and John],
I'm exploring Rose::DB::Object et al.. I'm familiar with Class::DBI
and have messed around a bit (and decided not to adopt) with
DBIX::Class.
I'm working with a fairly large database that contains data handed to
me as XML with minimal documentation.
I've reverse engineered a schema that represents it, and built various
tools to dig useful information out of it.
One of the things that I want to do is best (for me, anyway...)
expressed as a big ugly query that digs out just the things that I
want.
In the Class::DBI world, I've done:
Foo::DB::Moose->set_sql(poodle => qq{
select moose.id
from ....
...
});
$meese = Foo::DB::Moose->search_poodle();
while($moose = $meese->next()) {
# blah, blah, blah....
}
I took this approach in part because I couldn't get Class::DBI to
express the query [hardly its fault, it's icky], and also because it
was just easier for me to understand.
It looks like I might be able to figure out how to get RDO::Manager to
express the query, but it would be quicker (at least as a first cut to
be able to do something like
Foo::DB::Moose::Manager->get_iterator_from_sql(blahblahblah);
I haven't seen anything in my dives into the docs. Is it possible?
Can you give me a pointer?
Thanks,
g.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object
