Author: ubernostrum
Date: 2011-09-10 22:37:55 -0700 (Sat, 10 Sep 2011)
New Revision: 16808
Modified:
django/trunk/docs/topics/db/sql.txt
Log:
Fixed #16293: Document a way to return dicts with column names from a DB cursor.
Modified: django/trunk/docs/topics/db/sql.txt
===================================================================
--- django/trunk/docs/topics/db/sql.txt 2011-09-11 05:32:14 UTC (rev 16807)
+++ django/trunk/docs/topics/db/sql.txt 2011-09-11 05:37:55 UTC (rev 16808)
@@ -240,6 +240,30 @@
# Your code here...
transaction.commit_unless_managed(using='my_db_alias')
+By default, the Python DB API will return results without their field
+names, which means you end up with a ``list`` of values, rather than a
+``dict``. At a small performance cost, you can return results as a
+``dict`` by using something like this::
+
+ def dictfetchall(cursor):
+ "Returns all rows from a cursor as a dict"
+ desc = cursor.description
+ return [
+ dict(zip([col[0] for col in desc], row))
+ for row in cursor.fetchall()
+ ]
+
+Here is an example of the difference between the two::
+
+ >>> cursor.execute("SELECT id, parent_id from test LIMIT 2");
+ >>> cursor.fetchall()
+ ((54360982L, None), (54360880L, None))
+
+ >>> cursor.execute("SELECT id, parent_id from test LIMIT 2");
+ >>> dictfetchall(cursor)
+ [{'parent_id': None, 'id': 54360982L}, {'parent_id': None, 'id':
54360880L}]
+
+
.. _transactions-and-raw-sql:
Transactions and raw SQL
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
