[sqlalchemy] Re: execute() and commit() and commit

2010-02-12 Thread Bob Farrell
Sorry, I forgot to mention that if I run my select * from test; *after* I get the error for test3, it shows that insert did in fact get committed to the database: {. b...@mote: ~/dev/sasqlconsole .] £ sqlite3 test.sqlite select * from test 7|8|9 So it seems that the commit is getting sent to the

[sqlalchemy] Re: execute() and commit() and commit

2010-02-12 Thread Bob Farrell
I tried this against Oracle and it works without a hitch, so it looks like it's a problem with sqlite - we've got some ideas on how to fix it so we'll carry on looking. So this thread can be ignored now, as it's not a sqlalchemy issue (unless sqlalchemy planned to special case commit as text for