diff options
author | Antoine Pitrou <solipsis@pitrou.net> | 2010-02-02 23:00:29 (GMT) |
---|---|---|
committer | Antoine Pitrou <solipsis@pitrou.net> | 2010-02-02 23:00:29 (GMT) |
commit | f06917ee6fe1ec1223831277abc0c4ad5e5d527e (patch) | |
tree | c2959cc8d35f3058097d2d5dc8aca08d113dd362 /Doc/library/sqlite3.rst | |
parent | 05b7c5644c9c7a5e7b656fc241e45ff171c16d84 (diff) | |
download | cpython-f06917ee6fe1ec1223831277abc0c4ad5e5d527e.zip cpython-f06917ee6fe1ec1223831277abc0c4ad5e5d527e.tar.gz cpython-f06917ee6fe1ec1223831277abc0c4ad5e5d527e.tar.bz2 |
Fix sqlite3 docs. `buffer` is gone, `bytes` objects are returned for BLOBs instead.
Patch by Pablo Mouzo.
Diffstat (limited to 'Doc/library/sqlite3.rst')
-rw-r--r-- | Doc/library/sqlite3.rst | 14 |
1 files changed, 6 insertions, 8 deletions
diff --git a/Doc/library/sqlite3.rst b/Doc/library/sqlite3.rst index 74bbb53..696f19c 100644 --- a/Doc/library/sqlite3.rst +++ b/Doc/library/sqlite3.rst @@ -187,7 +187,7 @@ Module functions and constants Registers a callable to convert the custom Python type *type* into one of SQLite's supported types. The callable *callable* accepts as single parameter the Python value, and must return a value of the following types: int, - float, str, bytes (UTF-8 encoded) or buffer. + float, str or bytes. .. function:: complete_statement(sql) @@ -282,7 +282,7 @@ Connection Objects as the SQL function. The function can return any of the types supported by SQLite: bytes, str, int, - float, buffer and None. + float and None. Example: @@ -298,7 +298,7 @@ Connection Objects final result of the aggregate. The ``finalize`` method can return any of the types supported by SQLite: - bytes, str, int, float, buffer and None. + bytes, str, int, float and None. Example: @@ -633,11 +633,9 @@ The following Python types can thus be sent to SQLite without any problem: +-------------------------------+-------------+ | :class:`float` | ``REAL`` | +-------------------------------+-------------+ -| :class:`bytes` (UTF8-encoded) | ``TEXT`` | -+-------------------------------+-------------+ | :class:`str` | ``TEXT`` | +-------------------------------+-------------+ -| :class:`buffer` | ``BLOB`` | +| :class:`bytes` | ``BLOB`` | +-------------------------------+-------------+ @@ -654,7 +652,7 @@ This is how SQLite types are converted to Python types by default: +-------------+---------------------------------------------+ | ``TEXT`` | depends on text_factory, str by default | +-------------+---------------------------------------------+ -| ``BLOB`` | buffer | +| ``BLOB`` | :class:`bytes` | +-------------+---------------------------------------------+ The type system of the :mod:`sqlite3` module is extensible in two ways: you can @@ -669,7 +667,7 @@ Using adapters to store additional Python types in SQLite databases As described before, SQLite supports only a limited set of types natively. To use other Python types with SQLite, you must **adapt** them to one of the sqlite3 module's supported types for SQLite: one of NoneType, int, float, -str, bytes, buffer. +str, bytes. The :mod:`sqlite3` module uses Python object adaptation, as described in :pep:`246` for this. The protocol to use is :class:`PrepareProtocol`. |