Re: [pysqlite] [3.6.3-r1] Row not updated?
Roger Binns <[email protected]> Fri, 21 Nov 2008 00:37:48 -0800
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Dennis Lee Bieber wrote:
>> cursor.execute("BEGIN")
>
> You are forcing a new transaction -- but you never committed the
> update!
This is APSW not pysqlite. APSW does not do *any* transaction handling
behind your back. Consequently the database would have been in
autocommit mode and the UPDATE would have been committed. SQLite does
not support nested transactions so if there was already a transaction in
progress then you get apsw.SQLError with message "cannot start a
transaction within a transaction". (The error code and message are
generated by SQLite not APSW).
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkkmc1kACgkQmOOfHg372QQ6DACggcl+C/YaeahRsYOQ1VbAJUGx
3H0AnR4BMatJTKceng5TQlnjtBQDVA/1
=6Tbn
-----END PGP SIGNATURE-----