From: Diez B. Roggisch <deets@we...> - 2008-05-21 17:48:16
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.