On 10/1/07 11:06 PM, Kurt Hansen wrote: >> Have you tried simply setting the "schema" attribute of your Rose::DB data >> sources? >> > Yes, I've done the following: > > __PACKAGE__->register_db( > domain => 'pax', > type => 'donor', > ... > schema => '1', > ); > > I tried it, and it didn't seem to work. I also tried setting the schema > to the database name and that didn't work either. > > What should I be doing?
The schema value should be a name, not a boolean. You can also set the schema on the class itself, which should override the schema name used in the data source. You can see a demonstration of these features, including at least one cross-database (well, "cross-schema" anyway) join in this test: http://search.cpan.org/src/JSIRACUSA/Rose-DB-Object-0.765/t/schema-override. t The test runs against Postgres, which has "real" schema support. I'm not sure if it'll work the same with MySQL where the equivalent concept is "database" rather than "schema." But if it doesn't work, you should be able to figure out why by looking at how the Postgres example does work. Then you can submit a patch (or at least a failing test :) -John ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
