Sells, Fred schrieb: > I hit a similar problem where we have identical databases for our > subsidiaries with a unique schema. I needed to write something that would > cycle through all the schema's, executing the same logic. I could not figure > out how to do it with sqlobject and just went to straight sql. This was > using MySQL 4.1 FWIW.
Does mysql support schemas? Didn't know that. > > I'm not sure if your proposal solves that? Of course I'm just a sqlobject > hacker; mostly use the straight db api. Nope. But a patch I suggested today to Oleg does. It's about adding a schema-keyword to connection-uris which allows one to set the schema on a per-connection-base. THen your use-case could have been dealt with by *not* declaring schemas on the objects themselves, but instead creating connections with schemas & then executing model code. Diez ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
