On Mon, Jun 12, 2006 at 09:06:06AM +0800, Alex Le Dain wrote:
> So to do what I want to do would would mean I probably need to create
> three connection instances, connA, connB and connC and pass these as an
> argument when I access the SQLObjects. For example:
> connA = connectionForURI('mysql://blahA:[EMAIL PROTECTED]:3306/blahA')
> connB = connectionForURI('mysql://blahB:[EMAIL PROTECTED]:3306/blahB')
> connC = connectionForURI('mysql://blahC:[EMAIL PROTECTED]:3306/blahC')
>
> tA = MyTable1.get(1, connA)
> tB = MyTable1.get(1, connB)
> tC = MyTable1.get(1, connC)
>
> Can anyone confirm this as the best way to achieve multiple connections?
It is. I use this approach to convert a database from MySQL to SQLite
and SQLite to Postgres.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
