django-devserver icon indicating copy to clipboard operation
django-devserver copied to clipboard

Avoiding TypeError when raw sql and no params

Open ivancrneto opened this issue 11 years ago • 0 comments

sql = u'SELECT (strftime('%Y%W', datetime)) AS "week", AVG("core_expense"."amount") AS "average", SUM("core_expense"."amount") AS "total" FROM "core_expense" GROUP BY strftime('%Y%W', datetime), (strftime('%Y%W', datetime)) ORDER BY "week" ASC'

params = ()

When we try raw SQL queries like the one above, mainly when using builtin sql functions of the dbms, and devserver tries to print the queries, we get a "TypeError: not enough arguments for format string"

ivancrneto avatar Jun 09 '14 04:06 ivancrneto