Does .commit() ensure the .execute()'s and .executemany()'s called before are run atomically?
Peng Yu <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CABrM6wn2TkCgC5NWMsB=LZVgL-u=5r+XLnYMC6m9GiZktFWUyw@mail.gmail.com> |
In python sqlite3 program, if I call .execute() multiple times then call .commit(). Does it ensure that all the sqlite3 commands specified by execute()'s either all take effect or none effect? In other words, if any error occurs while running the sqlite3 commands specified in execute(), what happens? Also, is .executemany() the same as calling .execute() many times? -- Regards, Peng _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users