Login

custom sql without table names

Author:
robharvey
Posted:
May 18, 2007
Language:
Python
Version:
.96
Score:
1 (after 5 ratings)

Keeps database table names out of custom SQL code, but still allows for correct parameter passing in the execute function. (psycopg doesn't substitute table or field names, only data, in the execute function)

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
    # dict indexed to model names
    tables = {'str':'%s'}
    for x in ModelOne, ModelTwo:
        tables[x._meta.object_name] = x._meta.db_table

    cursor = connection.cursor()
    ex_str =  """\
    select field1, field2, sum(field3) from %(ModelOne)s where date between %(str)s and %(str)s 
    group by field1, field2
    """ % tables
    cursor.execute(ex_str, dates)
    sumt = cursor.fetchall()

More like this

  1. Mask sensitive data from logger by agusmakmun 1 week, 4 days ago
  2. Template tag - list punctuation for a list of items by shapiromatron 1 year, 2 months ago
  3. JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 1 year, 2 months ago
  4. Serializer factory with Django Rest Framework by julio 1 year, 9 months ago
  5. Image compression before saving the new model / work with JPG, PNG by Schleidens 1 year, 10 months ago

Comments

Please login first before commenting.