其实在很多实际开发中都会用到where xxx in (list)的查询语句进行数据查询,一般接口传参为了方便都会直接传递数组,那么该如何快捷的格式化sql语句呢
实例:
SELECT * FROM test where status='SUCESS' and operator_id in ('5122','5123');
前台传给过来的参数:
{
"status": "SUCESS",
"operator_id": ['5122','5123']
}
格式化:
filter_ret = ','.join(["'%s'" % item for item in operator_id])
sql = f"SELECT * FROM test where status='{status}' and operator_id in ({filter_ret})"