summaryrefslogtreecommitdiff
path: root/docs/topics/db/sql.txt
AgeCommit message (Collapse)Author
2026-03-10Fixed #36391 -- Doc'd RawSQL usage in docs/topics/db/sql.txt.Amar
2026-01-18Applied Black's 2026 stable style.Mariusz Felisiak
https://github.com/psf/black/releases/tag/26.1.0
2025-08-25Refs #36485 -- Rewrapped docs to 79 columns line length.David Smith
Lines in the docs files were manually adjusted to conform to the 79 columns limit per line (plus newline), improving readability and consistency across the content.
2025-08-25Refs #36485 -- Removed unnecessary parentheses in :meth: and :func: roles in ↵David Smith
docs.
2023-04-20Improved examples in docs about raw SQL queries.Mariusz Felisiak
Regression in 14459f80ee3a9e005989db37c26fd13bb6d2fab2.
2023-03-22Fixed #34409 -- Doc'd limitation of dictfetchall() and namedtuplefetchall() ↵Jesper Olsson
examples. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2023-03-01Fixed #34140 -- Reformatted code blocks in docs with blacken-docs.django-bot
2023-02-28Refs #34140 -- Corrected rst code-block and various formatting issues in docs.Joseph Victor Zammit
2023-02-10Refs #34140 -- Applied rst code-block to non-Python examples.Carlton Gibson
Thanks to J.V. Zammit, Paolo Melchiorre, and Mariusz Felisiak for reviews.
2022-05-19Removed unnecessary semicolons in docs about performing raw SQL.Tom Sparrow
2022-03-17Added missing backticks to function names.Mariusz Felisiak
2021-09-20Removed versionadded/changed annotations for 3.2.Mariusz Felisiak
2021-05-20Changed IRC references to Libera.Chat.Mariusz Felisiak
2021-01-05Fixed #32231 -- Allowed passing None params to QuerySet.raw().Alexander Lyabah
2020-05-04Refs #30573 -- Rephrased "Of Course" and "Obvious(ly)" in documentation and ↵Adam Johnson
comments.
2020-04-29Fixed #31356 -- Changed IRC links to the Freenode webchat.Hasan Ramezani
2019-11-18Fixed #30988 -- Deprecated the InvalidQuery exception.Simon Charette
It was barely documented without pointers at its defining location and was abused to prevent misuse of the QuerySet field deferring feature.
2019-09-06Fixed #30573 -- Rephrased documentation to avoid words that minimise the ↵Tobias Kunze
involved difficulty. This patch does not remove all occurrences of the words in question. Rather, I went through all of the occurrences of the words listed below, and judged if they a) suggested the reader had some kind of knowledge/experience, and b) if they added anything of value (including tone of voice, etc). I left most of the words alone. I looked at the following words: - simply/simple - easy/easier/easiest - obvious - just - merely - straightforward - ridiculous Thanks to Carlton Gibson for guidance on how to approach this issue, and to Tim Bell for providing the idea. But the enormous lion's share of thanks go to Adam Johnson for his patient and helpful review.
2019-03-29Removed unnecessary /static from links to PostgreSQL docs.Nick Pope
2018-11-13Fixed #29940 -- Recommended using the ORM rather than raw SQL.Katie McLaughlin
2018-05-17Removed versionadded/changed annotations for 2.0.Tim Graham
2018-04-19Fixed #29337 -- Added __len__() & __bool__() to RawQuerySet.Adnan Umer
2018-04-19Fixed #29339 -- Added result caching to RawQuerySet.Adnan Umer
2017-11-28Fixed #28853 -- Updated connection.cursor() uses to use a context manager.Jon Dufresne
2017-11-07Fixed #28770 -- Warned that quoting a placeholder in a raw SQL string is unsafe.Tim Graham
Thanks Hynek Cernoch for the report and review.
2017-08-12Fixed #23546 -- Added kwargs support for CursorWrapper.callproc() on Oracle.Mariusz Felisiak
Thanks Shai Berger, Tim Graham and Aymeric Augustin for reviews and Renbi Yu for the initial patch.
2017-08-10Fixed #23766 -- Doc'd CursorWrapper.callproc().Mariusz Felisiak
Thanks Tim Graham for the review.
2016-10-25Updated postgresql.org links to https and made them canonical.Marti Raudsepp
2016-09-07Fixed #27172 -- Closed database cursor explicitly in two doc examplesChris Jerdonek
2015-09-24Fixed #25455 -- Optimized dictfetchall() example.Tim Graham
Thanks aklim007 for the suggestion.
2015-09-03Fixed #25326 -- Added namedtuple example for executing custom SQL.Dražen Odobašić
2015-08-08Updated Wikipedia links to use httpsClaude Paroz
2015-03-07Fixed typos and updated spelling wordlist.Floris den Hengst
2015-02-01Removed versionadded/changed notes for 1.7.Tim Graham
2014-12-19Used https for most *.python.org linksClaude Paroz
2014-12-06Cleaned up a note in docs/topics/db/sql.txt.wrwrwr
2014-08-19Removed unnecessary code-block directives.areski
2014-06-12Fixed #22349 -- Added a note clarifying `RawQuerySet` has no `__len__`.Moayad Mardini
Thanks cdestigter for the report.
2014-04-25Fixed #22493 - Added warnings to raw() and extra() docs about SQL injectionMoayad Mardini
Thanks Erik Romijn for the suggestion.
2014-04-21Fixed queries that may return unexpected results on MySQL due to typecasting.Erik Romijn
This is a security fix; disclosure to follow shortly.
2014-03-24Removed versionadded/changed annotations for 1.6.Tim Graham
2014-02-25Fixed docs typos.Szczepan Cieślik
2014-02-20Capitalize SQL keywordsDavid Sanders
2014-02-20Capitalize SQL keywordsDavid Sanders
2014-01-02Fixed typos. Changed grammar.Frank Tobia
Minor typos. Some grammar changes.
2013-09-25Fixed #17671 - Cursors are now context managers.Michael Manfre
2013-06-28Support 'pyformat' style parameters in raw queries, Refs #10070Shai Berger
Add support for Oracle, fix an issue with the repr of RawQuerySet, add tests and documentations. Also added a 'supports_paramstyle_pyformat' database feature, True by default, False for SQLite. Thanks Donald Stufft for review of documentation.
2013-05-05Found a mistake in SQL documentationChristopher Allen-Poole
2013-04-20Adapted uses of versionchanged/versionadded to the new form.Juan Catalano
Refs #20104.
2013-03-23Fixed #9055 -- Standardized behaviour of parameter escaping in db cursorsClaude Paroz
Previously, depending on the database backend or the cursor type, you'd need to double the percent signs in the query before passing it to cursor.execute. Now cursor.execute consistently need percent doubling whenever params argument is not None (placeholder substitution will happen). Thanks Thomas Güttler for the report and Walter Doekes for his work on the patch.