On Sun, Aug 12, 2007 at 09:15:32PM -0500, Christopher Singley wrote:
> On Saturday 11 August 2007 13:05, Oleg Broytmann wrote:
> > Most SQLObject methods accept "connection" parameter. So you create two
> > connections and pass one or the other to an every method.
>
> Could you perhaps provide a brief example, please? This is something I'm
> interested in trying, too.
from sqlobject import connectionForURI
from_connection = connectionForURI("sqlite:///home/work/data.db")
to_connection = connectionForURI("postgres:/database")
class MyTable(SQLObject):
name= StringCol()
for row in MyTable.select(connection=from_connection):
values = row.sqlmeta.asDict()
new_row = MyTable(connection=to_connection, **values)
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
