Hi,
When I tested sql of MySQL in Python interactive shell, I got an
error of "not enough arguments for format string". I checked the
arguments however I could not find anything wrong.
Can anybody give me a clue?
Thanks so much.
>>> sql = Template('select dimension1 ,adddate(current_date,-1),current_date,
>>> ifnull(sum(case when date_format(creation_date,\'%Y-%m-%d\') =
>>> adddate(current_date,-1) then ifnull($ss_1,0) end),0) as \'PreviousDay\',
>>> ifnull(sum(case when date_format(creation_date,\'%Y-%m-%d\') = current_date
>>> then ifnull($ss_2,0) end),0) as \'Today\' from message_alert where
>>> dataset_id = $ss_3 and dimension1 in ($ss_4) and hour(creation_date) =
>>> hour(now())-1 group by dimension1 having (ifnull(sum(case when
>>> date_format(creation_date,\'%Y-%m-%d\') = current_date then ifnull($ss_5,0)
>>> end),0) / ifnull(sum(case when date_format(creation_date,\'%Y-%m-%d\') =
>>> adddate(current_date,-1) then ifnull($ss_6,0) end),0)) $ss_7 $ss_8')
>>>
>>> sql = sql.substitute(ss_1='metric1', ss_2='metric1', ss_3=2,
>>> ss_4='557796,558069,558230', ss_5='metric1', ss_6='metric1', ss_7='>=',
>>> ss_8=0.05)
>>>
>>> cursor.execute(sql)
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/usr/lib/python2.5/site-packages/django/db/backends/util.py",
line 22, in execute
sql = self.db.ops.last_executed_query(self.cursor, sql, params)
File "/usr/lib/python2.5/site-packages/django/db/backends/
__init__.py", line 217, in last_executed_query
return smart_unicode(sql) % u_params
TypeError: not enough arguments for format string
>>>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
