[pysqlite] APSW 3.6.10-r1 released
Roger Binns <[email protected]> Tue, 03 Feb 2009 01:20:00 -0800
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
APSW 3.6.10-r1 is now available. The home page is at
http://code.google.com/p/apsw/ which includes full documentation, source
and binary distributions for Windows (Python 2.3 onwards including 3.0).
APSW is a wrapper around SQLite that provides all SQLite API
functionality in Python. It is not DBAPI compliant as it provides
SQLite semantics. pysqlite provides DBAPI semantics. You can see the
two approaches contrasted at
http://apsw.googlecode.com/svn/publish/pysqlite.html
Changelist is below and a clickable version at
http://apsw.googlecode.com/svn/publish/changes.html
You can use the database as a context manager as defined in PEP 0343.
When you use 'with' a transaction is started. If the block finishes with
an exception then the transaction is rolled back, otherwise it is
committed. See Connection.__enter__() for an example.
Behind the scenes the savepoint functionality introduced in SQLite 3.6.8
is used. Consequently Connection 'with' blocks can be nested. If you use
Connection level execution tracers then they will be called with the
savepoint SQL statements.
You can also use blobs as a context manager which ensures it is always
closed when finished using it. See blob.__enter__() for an example.
Added constants:
* SQLITE_SAVEPOINT (authorizer code)
* SQLITE_IOERR_CLOSE (extended result code)
* SQLITE_IOERR_DIR_CLOSE (extended result code)
* New mapping: SQLITE_FCNTL_LOCKSTATE, SQLITE_GET_LOCKPROXYFILE,
SQLITE_SET_LOCKPROXYFILE, SQLITE_LAST_ERRNO. SQLite does not document
the purpose of these except the first one.
Updated Virtual File System (VFS) test code. SQLite?s routines that call
VFSFile.xTruncate() used to ignore errors but now return an error to the
caller. VFSFile.xFileControl() is now called so a user implemented one
must call any base it inherits from for SQLite to function normally.
Updated the xDlSym VFS routine to have the different but compatible type
signature as changed in SQLite 3.6.7 to deal with pedantic compiler
warnings.
Fixed bug in apswtrace that could result in poorly formatted times.
Leading comments are also stripped for queries printed in the final
reports. You can also request subsets of the reports.
The speedtest script will now fallback to the Python builtin sqlite3
module if it can?t find an externally installed pysqlite.
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
iEYEARECAAYFAkmIDD0ACgkQmOOfHg372QSSLgCdH9NgbFfWMhA0Sv3ekDioiUav
MjEAn3K3jz7rvT+ZrWTae8c95SW/h/Qi
=cMs1
-----END PGP SIGNATURE-----