summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorMariusz Felisiak <felisiak.mariusz@gmail.com>2023-04-20 12:24:33 +0200
committerGitHub <noreply@github.com>2023-04-20 12:24:33 +0200
commit498195bda492d09ed00d05ab268cad4b8e5c9f21 (patch)
treeec24ed90849a46a02a5e75d847e529c3155a4381 /docs
parent0494efddc422716431b92896899284b6afebb23a (diff)
downloaddjango-498195bda492d09ed00d05ab268cad4b8e5c9f21.tar.gz
Improved examples in docs about raw SQL queries.
Regression in 14459f80ee3a9e005989db37c26fd13bb6d2fab2.
Diffstat (limited to 'docs')
-rw-r--r--docs/topics/db/sql.txt17
1 files changed, 10 insertions, 7 deletions
diff --git a/docs/topics/db/sql.txt b/docs/topics/db/sql.txt
index 47a7ea39e1..42143fd118 100644
--- a/docs/topics/db/sql.txt
+++ b/docs/topics/db/sql.txt
@@ -121,11 +121,13 @@ had ``Person`` data in it, you could easily map it into ``Person`` instances:
.. code-block:: pycon
>>> Person.objects.raw(
- ... """SELECT first AS first_name,
- ... last AS last_name,
- ... bd AS birth_date,
- ... pk AS id,
- ... FROM some_other_table"""
+ ... """
+ ... SELECT first AS first_name,
+ ... last AS last_name,
+ ... bd AS birth_date,
+ ... pk AS id,
+ ... FROM some_other_table
+ ... """
... )
As long as the names match, the model instances will be created correctly.
@@ -175,8 +177,9 @@ fields that are omitted from the query will be loaded on demand. For example:
>>> for p in Person.objects.raw("SELECT id, first_name FROM myapp_person"):
... print(
- ... p.first_name, p.last_name # This will be retrieved by the original query
- ... ) # This will be retrieved on demand
+ ... p.first_name, # This will be retrieved by the original query
+ ... p.last_name, # This will be retrieved on demand
+ ... )
...
John Smith
Jane Jones