SELECT
tid
FROM
record
WHERE
create_time >= CURRENT_TIMESTAMP - 3600000
GROUP BY tid
ORDER BY SUM(point) DESC
LIMIT 3
如果用APIJSON，可以这样请求：
{
"[]": {
"Record": {
"@column": "tid",
"create_time{}": ">=CURRENT_TIMESTAMP-3600000",
"@group": "tid",
"@order": "SUM(point)-"
},
"count": 3
}
}
然后服务器会返回：
{
"[]": [
{
"Record": {
"tid": 82001
}
},
{
"Record": {
"tid": 82002
}
},
{
"Record": {
"tid": 82003
}
}
],
"code": 200,
"msg": "success"
}
可以提取出tid：
{
"Record-tid[]": {
"Record": {
"@column": "tid",
"create_time{}": ">=CURRENT_TIMESTAMP-3600000",
"@group": "tid",
"@order": "SUM(point)-"
},
"count": 3
}
}
然后服务器会返回：
{
"Record-tid[]": [
82001,
82002,
82003
],
"code": 200,
"msg": "success"
}
一个可直接在线测试的demo：
http://39.108.143.172/
{
"Comment-userId[]": {
"Comment": {
"@column": "userId",
"date{}": ">=CURRENT_TIMESTAMP-3600000",
"@group": "userId",
"@order": "SUM(momentId)-"
},
"count": 3
}
}
用APIJSON，后端不用写接口和文档，前端/客户端 定制返回JSON的内容和结构^_^
https://github.com/TommyLemon...
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
