Re: [SQLObject] Manage objects in different databases under the same program instance

[Petr J. <pet...@tp...>]

> In order to create the DB objects inside the approppriate DB, AFAIK I can pass
> a connection parameter in the class creation, and all will be fine. But how do
> I go about doing selects and obtaining results from a specific DB? I may have
> two DBs open, and each with its file & dir structure inside. If I want to do,
> say, File.select(), how can I specify that I want results from only one of the
> DBs?
>

What about:

from sqlobject import *

connection01 = connectionForURI('sqlite:/:memory:')
connection02 = connectionForURI('sqlite:/:memory:')

class File01(SQLObject):
    _connection = connection01

class File02(SQLObject):
    _connection = connection02