* Shell: Errors when SQLite are preparing a statement now show
the relevant extract of the query, and where the error was
detected.
* Shell: Output modes table (ASCII line drawing, lots of
sanitization), box (Unicode line drawing) and
qbox (box with quoted values) available.
* Shell: if started interactively then box is the default mode
(list remains the default in non-interactive)
* Added :meth:`Connection.pragma` to execute pragmas
and get results.
* Added :attr:`Cursor.get` returning query results with the
least amount of structure.
* Fixed execution tracers should return comment text for
comment only queries, and add :attr:`Cursor.has_vdbe`.
* Ensure that all applicable options are implemented for
:func:`apsw.config`, :meth:`Connection.config` and similar.
* Added :func:`apsw.sleep`
* Strings for :meth:`apsw.VFS.xNextSystemCall` are interned
* Detect unbound recursion not handled by CPython, and handle
better.
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-apsw?expand=0&rev=33
* Fixed :issue:`412` in :meth:`apsw.ext.make_virtual_module`.
* Added :meth:`apsw.connections` to get all connections.
* :func:`sys.unraisablehook` is called correctly (:issue:`410`)
* Be stricter where :class:`bool` values are expected (eg
* :meth:`VTTable.BestIndex`), only accepting :class:`int` and
:class:`bool`. Previously you could for example supply
strings and lists, which were almost certainly unintended
errors.
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-apsw?expand=0&rev=31
* Implemented `window functions
* Function flags can be specified to
Connection.createscalarfunction and
Connection.createaggregatefunction
* Added apsw.mapping_function_flags
* Added Connection.trace_v2` with apsw.mapping_trace_codes
and apsw.mapping_statement_status
* Ensure all SQLite APIs are wrapped.
* When an unraisable exception happens, sqlite3_log is
now called so you will have context within SQLite's actions.
* sys.unraisablehook now called first, and if it doesn't exist then
sys.excepthook as before.
* When the wrong type is given for a function argument, the
error message now includes the parameter name and function
signature.
* Let SQLite do size checking instead of APSW for strings and
blobs.
* Added :meth:`apsw.ext.log_sqlite` which installs a handler
that forwards SQLite messages to the logging module
* Added set_default_vfs and unregister_vfs taking vfs
names.
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-apsw?expand=0&rev=29
* Fixed regression in statement cache update (version 3.38.1-r1) where
trailing whitespace in queries would be incorrectly treated as
incomplete execution (APSW issue 376)
* Added Various interesting and useful bits of functionality (APSW issue
369)
* Added more Pythonic attributes as an alternative to getters and setters,
including Connection.in_transaction, Connection.exectrace,
Connection.rowtrace, Cursor.exectrace, Cursor.rowtrace,
Cursor.connection (APSW issue 371)
* Completed: To the extent permitted by CPython APIs every item has the
same docstring as this documentation. Every API can use named
parameters. The type stubs cover everything including constants. The
type stubs also include documentation for everything, which for example
Visual Studio Code displays as you type or hover. There is a single
source of documentation in the source code, which is then automatically
extracted to make this documentation, docstrings, and docstrings in the
type stubs.
* Example/Tour updated and appearance improved (APSW issue 367).
* Added Connection.cache_stats() to provide more information about the
statement cache.
* Cursor.execute() now uses sqlite_prepare_v3 which allows supplying
flags.
* Cursor.execute() has a new can_cache parameter to control whether the
query can use the statement cache. One example use is with authorizers
because they only run during prepare, which doesn’t happen with already
cached statements.
* (The Cursor.execute() additional parameters are keyword only and also
present in Cursor.executemany(), and the corresponding
Connection.execute() and Connection.executemany() methods.)
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-apsw?expand=0&rev=27
* Allow breaking of reference cycles between objects that contain a
Connection or Cursor
* Fixed custom VFS extension loading failure could leave the error message
unterminated
* Updated size of mutex array used by the fork checker
* Connections are opened with SQLITE_OPEN_EXRESCODE so open errors will also
include extended result codes
* Connection.changes() and Connection.totalchanges() use the new SQLite APIs
that return 64 bit values
* Added Connection.autovacuum_pages()
* Implemented Connection.serialize() and Connection.deserialize().
* Allow any subclass of VFS to implement WAL, not just direct subclasses
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-apsw?expand=0&rev=26
- Update to 3.35.4-r1:
- Updates for SQLite download url (the year is part of the urls).
- Added enable flag for built-in SQL math functions, and enable
it by default with –enable-all-extensions.
- Use the newer buffer API for Python 3
(old API removed in Python 3.10).
- Fix loadable extensions are missing,
so insert --enable-all-extensions and --enable=load_extension.
See: https://rogerbinns.github.io/apsw/build.html#building
This version ist needed for calibre and also the build parameters " --enable-all-extensions and --enable=load_extension".
Without this parameters calibre find no sqlite-extension.
OBS-URL: https://build.opensuse.org/request/show/909410
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-apsw?expand=0&rev=24
- Update to version 3.9.2-r1
* No changelog
- singlespec auto-conversion
- Downgrade to 3.7.17 so we build on 13.1 too.
- Fix file collision between doc and normal
- Version bump to 3.8.0.2-r1 to use latest sqlite queries.
- Drop the macroed commands in favor of normal ones
- Drop clean section
- Write fully what documents go where.
- Drop unused tarballs, defines and checks for obsolete openSUSE versions
- osc service localrun format_spec_file
to add comments and such.
- build for all supported versions from a single spec
- link dynamically against the sqlite3 version that ships with each distro
version, rather than using amalgamation: this is required by s3ql
- initial package (3.7.0.1-r1)
OBS-URL: https://build.opensuse.org/request/show/519978
OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-apsw?expand=0&rev=9
