python拼接sql语句,如何在Python的SQL语句中使用变量和/或连接？

我在名为res的列表中有一个ID列表&＃xff0c;在将结果保存到数组中之前&＃xff0c;我希望逐行使用该列表作为SQL查询的WHERE条件&＃xff1a;ids

grupos

0 [160, 161, 365, 386, 471]

1 [296, 306]

下面是我试图在SQL查询中插入的内容&＃xff1a;listado &＃61; [None]*len(res)

# We store the hashtags that describes the best the groups

# We iterate on the people of a group to construct the WHERE condition

print "res : ", res

for i in (0,len(res)):

conn &＃61; psycopg2.connect(**params)

cur &＃61; conn.cursor()

listado &＃61; [None]*len(res)

for i in (0,len(res)):

print "res[i:p] : ", res.iloc[i][&＃39;ids&＃39;]

cur.execute("""SELECT COUNT(swipe.eclipse_id), subscriber_hashtag.hashtag_id FROM subscriber_hashtag

-- join para que las publicidades/eclipses que gusta un usarios estan vinculadas con las de la tabla de correspondencia con los hashtag

INNER JOIN eclipse_hashtag ON eclipse_hashtag.hashtag_id &＃61; subscriber_hashtag.hashtag_id

-- join para que los usarios estan vinculados con los de la tabla de correspondencia con los hashtag

LEFT OUTER JOIN swipe ON subscriber_hashtag.subscriber_id &＃61; swipe.subscriber_id

-- recobremos los "me gusta"

WHERE subscriber_hastag.subscriber_id in (%s)

GROUP BY subscriber_hashtag.hashtag_id

ORDER BY COUNT(swipe.eclipse_id) DESC;""",(res.iloc[i][&＃39;ids&＃39;]))

n &＃61; cur.fetchall()

listado[i] &＃61; [{"count": elem[0], "eclipse_id": elem[1]} for elem in n]

可再现示例的数据

提供进一步的数据信息&＃xff1a;subscriber_id hashtag_id

160 345

160 347

161 345

160 334

161 347

306 325

296 362

306 324

296 326

161 322

160 322

这里的输出应该是&＃xff1a;{0:[324,1],[325,1],[326,1],[362,1], 1 : [345,2],[347,2],[334,1]}

当前错误消息

错误&＃xff1a;标记输入时发生意外错误

以下回溯可能已损坏或无效

错误消息是&＃xff1a;(&＃39;EOF in multi-line string&＃39;&＃xff0c;(1&＃xff0c;50))---------------------------------------------------------------------------

TypeError Traceback (most recent call last)

in ()

39 WHERE subscriber_hastag.subscriber_id in (%s)

40 GROUP BY subscriber_hashtag.hashtag_id

---> 41 ORDER BY COUNT(swipe.eclipse_id) DESC;""",(res.iloc[i][&＃39;ids&＃39;]))

42

43 n &＃61; cur.fetchall()

TypeError:不是所有参数都在字符串格式化期间转换