Re: [SQLObject] simultaneous conection to 2 different databases

[Oleg B. <ph...@ph...>]

On Tue, Feb 05, 2008 at 08:55:35PM +0100, Petr Jake?? wrote:
> Hi,
> I have not clue how to realize simultaneous conection for two different
> databases in one script.
> 
> For example:
> 
> 1)
> db_filename = '/opt/firebird/examples/empbuild/automat.fdb'
> connection_string = 'firebird://127.0.0.1:3050/' + db_filename
> connection = connectionForURI(connection_string)
> sqlhub.processConnection = connection
> 
> 2)
> connection = connectionForURI('sqlite:///work/mincovnik.db')
> sqlhub.processConnection = connection

   You cannot do this with sqlhub. You have to pass the second connection
as the connection parameter to all SQLObject methods:

   connection2 = connectionForURI('sqlite:///work/mincovnik.db')
   ATable.select(clause, connection=connection2)

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.