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

2010-02-12 Thread Michael Bayer
Bob Farrell wrote: > 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

[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

[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