summaryrefslogtreecommitdiff
path: root/docs/topics/db/sql.txt
AgeCommit message (Collapse)Author
2019-03-29[2.2.x] Removed unnecessary /static from links to PostgreSQL docs.Nick Pope
Backport of 198a2a9381a415f76c3170753270f5087ce4475a from master.
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
2011-02-12Fixed #9964 -- Ensure that all database operations make transactions dirty, ↵Russell Keith-Magee
not just write operations. Many thanks to Shai Berger for his work and persistence on this issue. This is BACKWARDS INCOMPATIBLE for anyone relying on the current behavior that allows manually managed read-only transactions to be left dangling without a manual commit or rollback. git-svn-id: http://code.djangoproject.com/svn/django/trunk@15493 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2011-02-11Fixed #15243 -- More clearly document that the transaction functions needs ↵Alex Gaynor
to be called with a using parameter to work with a non-default database. Thanks to Jason Kotenko for the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@15489 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2010-11-09Fixed typo in raw SQL docs example.Ramiro Morales
git-svn-id: http://code.djangoproject.com/svn/django/trunk@14501 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2010-08-19Fixed #14141: docs now use the :doc: construct for links between documents.Jacob Kaplan-Moss
Thanks, Ramiro Morales. git-svn-id: http://code.djangoproject.com/svn/django/trunk@13608 bcc190cf-cafb-0310-a4f2-bffc1f526a37
2010-08-07Fixed #11800 -- Updated Sphinx metadata in queryset docs. Thanks to timo for ↵Russell Keith-Magee
the patch. git-svn-id: http://code.djangoproject.com/svn/django/trunk@13548 bcc190cf-cafb-0310-a4f2-bffc1f526a37