summaryrefslogtreecommitdiff
path: root/docs/topics/db/sql.txt
AgeCommit message (Collapse)Author
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.
2013-03-18Fixed #19968 -- Dropped support for PostgreSQL < 8.4.Aymeric Augustin
2013-03-11Enabled database-level autocommit for all backends.Aymeric Augustin
This is mostly a documentation change. It has the same backwards-incompatibility consequences as those described for PostgreSQL in a previous commit.
2013-01-02Fixed #19516 - Fixed remaining broken links.Tim Graham
Added -n to sphinx builds to catch issues going forward.
2012-09-20Fixed #18934 - Removed versionadded/changed annotations for Django 1.3Tim Graham
2012-06-07Removed references to changes made in 1.2.Aymeric Augustin
Thanks Florian Apolloner for the patch.
2012-04-30Replaced print statement by print function (forward compatibility syntax).Claude Paroz
2012-04-06Fixed #16233 -- Added link to multiple databases docs from custom sql alias ↵Claude Paroz
section. Thanks charlax for the report. git-svn-id: http://code.djangoproject.com/svn/django/trunk@17872 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-09-30Fixed doc references to `django.db.models.query.QuerySet` and converted some ↵Jannis Leidel
tabs that were introduced in r16699 to spaces. git-svn-id: http://code.djangoproject.com/svn/django/trunk@16915 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-09-11Fixed #16293: Document a way to return dicts with column names from a DB cursor.James Bennett
git-svn-id: http://code.djangoproject.com/svn/django/trunk@16808 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-09-04Converted links to external topics so they use intersphinx extension markup.Ramiro Morales
This allows to make these links more resilent to changes in the target URLs. Thanks Jannis for the report and Aymeric Augustin for the patch. Fixes #16586. git-svn-id: http://code.djangoproject.com/svn/django/trunk@16720 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-06-10Fixed #14201 - Add a "security overview" page to the docsLuke Plant
Thanks to davidfischer for the initial patch! git-svn-id: http://code.djangoproject.com/svn/django/trunk@16360 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-05-30Fixed #16093 - Typo in "Performing raw SQL queries"; thanks direvus.Timo Graham
git-svn-id: http://code.djangoproject.com/svn/django/trunk@16293 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-03-14Fixed #14733: no longer "validate" .raw() queries.Jacob Kaplan-Moss
Turns out that a lot more than just SELECT can return data, and this list is very hard to define up front in a cross-database manner. So let's just assume that anyone using raw() is at least halfway competant and can deal with the error messages if they don't use a data-returning query. Thanks to Christophe Pettus for the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@15803 bcc190cf-cafb-0310-a4f2-bffc1f526a37
generated by cgit v1.3 (git 2.53.0) at 2026-07-07 16:50:43 +0000