diff options
| author | Aymeric Augustin <aymeric.augustin@m4x.org> | 2015-09-13 09:30:35 +0200 |
|---|---|---|
| committer | Aymeric Augustin <aymeric.augustin@m4x.org> | 2015-09-17 23:01:33 +0200 |
| commit | 4f6a7663bcddffb114f2647f9928cbf1fdd8e4b5 (patch) | |
| tree | 648c2ae602182f4ae41095ddd40a8515cf5a1ced /docs | |
| parent | fc8a6a9b002aef90ff68f3d95e560db1ea728c76 (diff) | |
Refs #14091 -- Fixed connection.queries on SQLite.
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/faq/models.txt | 2 | ||||
| -rw-r--r-- | docs/ref/databases.txt | 10 | ||||
| -rw-r--r-- | docs/releases/1.9.txt | 2 |
3 files changed, 2 insertions, 12 deletions
diff --git a/docs/faq/models.txt b/docs/faq/models.txt index efa9d34c9b..982b806c78 100644 --- a/docs/faq/models.txt +++ b/docs/faq/models.txt @@ -23,8 +23,6 @@ the following:: ``connection.queries`` includes all SQL statements -- INSERTs, UPDATES, SELECTs, etc. Each time your app hits the database, the query will be recorded. -Note that the SQL recorded here may be :ref:`incorrectly quoted under SQLite -<sqlite-connection-queries>`. If you are using :doc:`multiple databases</topics/db/multi-db>`, you can use the same interface on each member of the ``connections`` dictionary:: diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt index 3a846ef6ea..5d6a23d751 100644 --- a/docs/ref/databases.txt +++ b/docs/ref/databases.txt @@ -704,16 +704,6 @@ can use the "pyformat" parameter style, where placeholders in the query are given as ``'%(name)s'`` and the parameters are passed as a dictionary rather than a list. SQLite does not support this. -.. _sqlite-connection-queries: - -Parameters not quoted in ``connection.queries`` ------------------------------------------------ - -``sqlite3`` does not provide a way to retrieve the SQL after quoting and -substituting the parameters. Instead, the SQL in ``connection.queries`` is -rebuilt with a simple string interpolation. It may be incorrect. Make sure -you add quotes where necessary before copying a query into an SQLite shell. - .. _oracle-notes: Oracle notes diff --git a/docs/releases/1.9.txt b/docs/releases/1.9.txt index efece97853..b977501519 100644 --- a/docs/releases/1.9.txt +++ b/docs/releases/1.9.txt @@ -510,6 +510,8 @@ Models * Added support for referencing annotations in ``QuerySet.distinct()``. +* ``connection.queries`` shows queries with substituted parameters on SQLite. + CSRF ^^^^ |