andream7 / apijson-db2

腾讯犀牛鸟开源人才培养计划 APIJSON 接入 db2
1 stars 1 forks source link

@order排序语法测试 #4

Closed andream7 closed 3 years ago

andream7 commented 3 years ago
{
    "[]": {
        "count": 10,
        "User": {
            "@column": "name,id",
            "@order": "id+"
        }
    }
}
andream7 commented 3 years ago

测试通过:

{
"[]":  [
 {
"User":  {
"sql": "SELECT "name","id" FROM "DB2ADMIN"."apijson_user" ORDER BY "id" ASC LIMIT 10" ,
"list":  [
 {
"name": "TommyLemon" ,
"id": 38710
},
 {
"name": "Strong" ,
"id": 70793
},
 {
"name": "测试账号" ,
"id": 82001
},
 {
"name": "Happy~" ,
"id": 82002
},
 {
"name": "Wechat" ,
"id": 82003
},
 {
"name": "Tommy" ,
"id": 82004
},
 {
"name": "Jan" ,
"id": 82005
},
 {
"name": "Meria" ,
"id": 82006
},
 {
"name": "God" ,
"id": 82009
},
 {
"name": "Steve" ,
"id": 82012
}
]
}
}
],
"ok": true ,
"code": 200 ,
"msg": "success" ,
"sql:generate|cache|execute|maxExecute": "0|0|0|200" ,
"depth:count|max": "3|5" ,
"time:start|duration|end": "1628664139711|11|1628664139722"
}