Re: [SQLObject] Changing database connection programatically

2008-07-10 Thread Molly Aplet
Aha! Further investigation showed that the second host was dropping all connections from outside of localhost, and that the problem had nothing to do with SQLObject. Whoops. On Thu, Jul 10, 2008 at 1:33 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Thu, Jul 10, 2008 at 01:01:38PM -0700, Moll

Re: [SQLObject] Changing database connection programatically

2008-07-10 Thread Oleg Broytmann
On Thu, Jul 10, 2008 at 01:01:38PM -0700, Molly Aplet wrote: > My intention was to overwrite the first connection with the second > connection--is there a way to do this? cls._connection = connectionForURI(cls.live_connection_string) or cls.setConnection(cls.live_connection_string) must w

Re: [SQLObject] Changing database connection programatically

2008-07-10 Thread Molly Aplet
My intention was to overwrite the first connection with the second connection--is there a way to do this? On Thu, Jul 10, 2008 at 12:08 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Thu, Jul 10, 2008 at 11:25:30AM -0700, Molly Aplet wrote: > > However, this method results in a lost connectio

Re: [SQLObject] Changing database connection programatically

2008-07-10 Thread Oleg Broytmann
On Thu, Jul 10, 2008 at 11:25:30AM -0700, Molly Aplet wrote: > However, this method results in a lost connection to the second DB. What do you expect? You cannot have both connections at once. Have I missed something? > Would a hub help, or > is that only for managing multiple connections to t

[SQLObject] Changing database connection programatically

2008-07-10 Thread Molly Aplet
Hi all, I'm trying to determine the best way to toggle between my test and live dbs, and I've hit a bit of a wall. I'm using MySQL 5.0.22 and SQLObject 0.7, and since I'm in a corporate environment, neither of those is likely to change any time soon. My setup is as follows: I've got two dbs, whi