我想通过flask-peewee运行以下查询,merchant_name
像“海边%”
SELECT *
FROM `merchant_details`
WHERE `merchant_name` LIKE 'seaside%'
这是以下URL的返回JSON,我需要过滤merhcnat_name
http://www.XXXXX.com/api/merchant_details/
http://www.XXXXX.com/api/merchant_details/?merchant_name__like=seaside(这不起作用)
{
"meta": {
"model": "merchant_details",
"next": "",
"page": 1,
"previous": ""
},
"objects": [
{
"merchant_name": "Seaside Grill",
"city": "Santa Monica ",
"zipcode": "90401",
"long": "-118.4884742",
"phone": "3102399844",
"state": "CA",
"updated_on": "2013-11-07 01:14:42",
"lat": "34.0189893",
"street_1": "406 Broadway",
"street_2": "1",
"merchant_id": "1",
"id": "2"
},
{
"merchant_name": "Jack n' Jill's",
"city": "Santa Monica",
"zipcode": "90401",
"long": "-118.4937635",
"phone": "3109873733",
"state": "CA",
"updated_on": "2013-11-08 08:20:29",
"lat": "34.0173215",
"street_1": "510 Santa Monica Blvd",
"street_2": "1",
"merchant_id": "48",
"id": "32"
}
]
}
最佳答案
您应该像这样编码网址:
?merchant_name__like=seaside%25
您可以通过
urllib.urlencode({'merchant_name__like': 'seaside%'})
获得编码的查询字符串,在SQL中?merchant_name__like=seaside
表示LIKE seaside
。