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
- Template tag - list punctuation for a list of items by shapiromatron 3 months, 1 week ago
- JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 3 months, 2 weeks ago
- Serializer factory with Django Rest Framework by julio 10 months, 1 week ago
- Image compression before saving the new model / work with JPG, PNG by Schleidens 11 months ago
- Help text hyperlinks by sa2812 11 months, 3 weeks ago
Comments
Please login first before commenting.