It is perfectly allowed to open multiple cursors against a single connection. You can only execute one statement per cursor at a time, but you can have multiple cursors running from the same connection:
cr1 = cn.cursor() cr2 = cn.cursor() cr1.execute('select ...') while True: row = cr1.fetchone() if not row: break ... cr2.execute('INSERT ...') for example. If you are inserting into one of the tables used in the outer select, simply make sure that select has an order by with a + in front of one of the column names to avoid side effects (ie, changes made to the database by the insert are visible to all statements/cursors on that connection even before those changes are committed). > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Joseph L. Casale > Sent: Wednesday, 17 July, 2013 13:41 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Guidance with Python and nested cursors > > > ________________________________________ > From: sqlite-users-boun...@sqlite.org on behalf of Petite Abeille > Sent: Wednesday, July 17, 2013 1:25 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Guidance with Python and nested cursors > > On Jul 17, 2013, at 9:07 PM, Joseph L. Casale > <jcas...@activenetwerx.com> wrote: > > >> I am using Python to query a table for all its rows, for each row, > I query related rows from a > >> second table, then perform some processing and insert in to a third > table. > >> > >> What is the technically correct approach for this? > > > >From the above outline, one SQL statement: > > Hi, > Problem is I need to perform some Python processing of the data, then > insert. > > Thanks! > jlc > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users