sql - Django Raw SQL给我TypeError没有足够的参数

Question

代码:

 diary=models.SablogArticles.objects.raw("SELECT articleid,DATE_FORMAT(from_unixtime(dateline),'%Y-%m')\
 as newtime,count(*) as howmany   FROM sablog_articles group by newtime")

结果给了我:

In template d:\python\project\tpl\base.html, error at line 68 Caught TypeError while rendering: not enough arguments for format string

Answer 1

原始SQL是带有格式设置参数的字符串，这表示％表示要设置格式的参数。您的字符串中包含％。您需要将它们加倍以保护它们免受解释:

diary = models.SablogArticles.objects.raw("""
    SELECT 
        articleid, 
        DATE_FORMAT(from_unixtime(dateline),'%%Y-%%m') as newtime,
        count(*) as howmany
    FROM sablog_articles group by newtime
    """)