(资料图片)
数据库表中的字段用key代替
"key[]":{}
"key{}":[1,2,3]
"key{}":"<=10;length(key)>1..."
"key<>":38710
"key}{@":{}
"key()":"function(arg0,arg1...)"
"@key()":"function(arg0,arg1...)"
"key@":"key0/key1.../targetKey"
"key@":{ "range":"ALL", "from":"Table", "Table":{ ... }}
"key$":"%abc%"
"key~":"^[0-9]+$"
"key%":"2018-01-01,2018-10-01"
"key+":[1]
"key-":888.88
"key{}":"<=90000"
">" 大于"<" 小于">=" 大于等于"<=" 小于等于"key&{}":">80000,<=90000" // &, |, !
"&" 与(并且)"|" 或(或者)"!" 非(不等于)"key:alias"
"key":Object,key为 "[]":{} 中{}内的关键词,Object的类型由key指定 可以理解为下面这种格式
"[]":{ "User":{}, "query":2, "count":1, ......},
"count":1
"page":1
"query":Integer
0 对象1 总数和分页详情2 数据、总数和分页详情"join":"&/Table0,
"@" APP JOIN"<" LEFT JOIN">" RIGHT JOIN"&" INNER JOIN"|" FULL JOIN"!" OUTER JOIN"*" CROSS JOIN"^" SIDE JOIN"(" ANTI JOIN")" FOREIGN JOIN"otherKey":Object
"@key":Object,@key为 Table:{} 中{}内的关键词,Object的类型由@key指定 下面这种格式
"Table": { "@column":"key,key1",}
"@combine":"key0 | (key1 & (key2 | !key3))..."
"@column":"column;function(arg)..."
"@order":"column0+,column1-..."
"@group":"column0,column1..."
"@having":"function0(...)?value0;function1(...)?value1;function2(...)?value2..."
"@schema":"sys"
"@database":"POSTGRESQL"
"@datasource":"DRUID"
"@json":"key0,key1..."
"@role":"OWNER"
"@explain":true
"@raw":"key0,key1..."
"@otherKey":Object
为最外层对象 {} 内的关键词。
"@schema":"sys"
"@datasource":"DRUID"
"@role":"OWNER"
"@explain":true
"tag":String
"version":Integer
"format":Boolean
APIJSON功能符:https://github.com/Tencent/APIJSON/blob/master/Document.md#32-%E5%8A%9F%E8%83%BD%E7%AC%A6
APIJSON目前实现功能:https://github.com/Tencent/APIJSON/wiki#APIJSON%E7%9B%AE%E5%89%8D%E5%B7%B2%E5%AE%9E%E7%8E%B0
X 关闭