Login

Custom SQL Function; Outputs Template-Friendly Content

Author:
hotani
Posted:
April 28, 2007
Language:
Python
Version:
.96
Tags:
templates custom-sql
Score:
4 (after 4 ratings)

This will return a template-friendly list of dictionaries when using custom SQL. The dictionary can be accessed just as a normal model/queryset.

Example of use (in view):

qkeys = ['artist','album']
query = """
    SELECT "artist","album" FROM "music"
    """ 
new_list = csql(request,query,qkeys)

(in template)

{% for row in new_list %}
    {{ row.artist }} {{ row.album }}
{% endfor %}
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
# custom query function:
def csql(self,query,qkeys):
    from django.db import connection
    cursor = connection.cursor()
    cursor.execute(query)
    rows = cursor.fetchall()
    
    # build dict for template:
    fdicts = []
    for row in rows:
        i = 0
        cur_row = {}
        for key in qkeys:
            cur_row[key] = row[i]
            i = i+1
        fdicts.append(cur_row)
    return fdicts

More like this

  1. View decorator to automate templates. by jafo 5 years, 2 months ago
  2. Last.fm Charts by sedden 6 years, 9 months ago
  3. Output sql_queries in Firebug console when in debug mode by wojas 5 years, 1 month ago
  4. Improved generic foreign key manager 2 by Nomalz 5 years, 6 months ago
  5. Debug middleware for displaying sql queries and template loading info when ?debug=true by SEJeff 4 years ago

Comments

Please login first before commenting.