On 2/28/06 8:14 PM, Ron Savage wrote: > o If I want to set the schema I can do that in the call to > Rose::DB->register_db, just as I can with driver, database, etc, although I > have not yet found a Rose doc indicating this was possible
http://search.cpan.org/dist/Rose-DB/lib/Rose/DB.pm#register_db "Any Rose::DB object method that sets a data source configuration value is a valid parameter name." (Follow the links in the POD to see a list of "data source configuration" object methods.) > o list_tables doesn't need a schema. All of: > - undef > - '%' > - uc $self -> username > produce the same ouput - correct - in the call to $dbh -> table_info. Hm, I wonder if that's a feature or a bug? :) > For consistency with the DBI docs, I'll use $self -> schema in the call to > list_tables and at the same time will delete sub schema from Oracle.pm, so it > Just Works. Sounds like a plan. > o I have another program which calls: > - table_info > - column_info > - primary_key_info > - foreign_key_info > (don't we all?) RDBO auto-init! :) > and it turns out the culprit to all this is primary_key_info. In /its/ schema > parameter, I have to have uc $user to get any output. Yeah, it's always something with those DBI methods. > o So why don't I use '%'? My assumption is that under (currently unknown) > circumstances it can return too much information. That is, by using $self -> > schema and by letting you set the schema in the call to register_db, you'll be > getting back info on precisely the schema you specified (i.e. wanted). If you > want table info for another schema (i.e. user), just create another entry in > the registry via register_db, and use that Okay, but what about the case where you have no explicitly set schema and list_tables() returns a table owned by some other user, then you call primary_key_info() passing your username and get no info back? -John ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
