I wanted to write a quick/dirty script to convert some data from one db to another and I thought that sqlsoup would be the perfect candidate for the job.
I put my new insertion calls in a function like this: def convert(*args,**kw): newdb.sometable.insert(....) newdb.someothertable.insert(....) # etc Then I call newdb.engine.transaction(convert) Nothing happens though at this point. if I call newdb.flush().. the data insertion is attempted but either it isn't being run in a transaction or an incorrect order is aborting the transaction. I'm not sure why the transaction method isn't committing. The flush call fails because it attempts to insert the data in the wrong order and there are foreign key violations. What do you think Jonathan? -Dennis --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
