On Oct 1, 2007, at 11:02 AM, [EMAIL PROTECTED] wrote:
> > Hi again, I really must be missing something fundamental here as I > cannot seem to solve this problem: > > I have a loop that queries one table (without any contraints) and > writes to a second table (with constraints). Here's what the loop > looks like in pseudo-code: > > while True: > 1) query old table and create a work list > 2) while items are in the work list: > 2.1) create a new object > 2.2) save > 3) commit > > I can wrap the save (2.2) and commit (3) in try/except blocks which > solves the IntegrityError exceptions at that point. The problem is > that I'm getting IntegrityError exceptions in the query section (1) > what seem to be deferred INSERTS from the commit (3). > > How can I turn off the deferred inserts? > some sample code would be helpful here in order to get some context as to what youre doing. if the problem is just that the INSERT's dont occur until you say session.commit(), you can issue session.flush () at any time which will flush all pending changes/new items to the database. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
