I'm just starting to experiment with RDBO and like it very much so far.
Thanks, John and everybody!
I'm experimenting at work, where we use MySQL, with each instance
containing multiple databases. Via RDBO, I would like to use the same
DBI connection to query multiple databases, sometimes performing joins
across multiple databases. To do this, I need to fully-qualify the table
names with the database names.
However, RDBO seems to fully-qualify like this only for
databases whose Rose::DB drivers contain
sub supports_schema { 1 }
i.e. Oracle and Pg. In my limited experiments, I've been able to
coerce RDBO into generating SQL that contains database-qualified table
names by shoving the above sub into the Rose::DB::MySQL symbol table and
passing a schema parameter to Rose::DB->register_db.
I'd rather contribute a patch that does this properly, but I'm not sure
I understand all the ways that RDBO uses schemata, or all the ways that
the Oracle and Pg concepts of schemata differ from the MySQL concept of
multiple databases. Thoughts? Any advice would be much appreciated.
Thanks again,
David
-------------------------------------------------------------------------
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
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
