我在用python参数化sql查询时遇到了一些麻烦。不完全知道为什么会发生此错误...如果元组有两个成员,而我在sql中使用两个参数,我该如何下一个错误呢?
错误信息:
File "...\app.py", line 27, in main
rows = User.daily_users_by_pool_name('2016-08-01', '2016-08-02')
File "...\user.py", line 48, in daily_users_by_pool_name
cursor.execute(query, (start_date, end_date))
IndexError: tuple index out of range
在main中调用函数:
rows = User.daily_users_by_pool_name('2016-08-01', '2016-08-02')
类User中的方法:
from database import ConnectionFromPool
from datetime import datetime
import pandas as pd
import numpy as np
import psycopg2
...
@classmethod #static
def daily_users_by_pool_name(cls, start_date, end_date):
'''returns a Pandas.DataFrame of results'''
query = """
Select foo.dos::date, foo.cust_id
from foo f
join customer c on f.id = c.id
where foo.dos >= %s::DATE
and foo.dos < %s::DATE
and c.cust_name ilike '%_bar'
and c.baz not ilike 'test%' """
with ConnectionFromPool() as cursor:
cursor.execute(query, (start_date, end_date))
return pd.DataFrame(cursor.fetchall(), columns=['foo', 'cust_id'])
再逃脱一个%
字符%
and c.cust_name ilike '%%_bar'
and c.baz not ilike 'test%%' """
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句