操作符 | 参数个数 | 举例 | 说明 |
---|---|---|---|
in | > 0 | name.in("test", "good") | 在给定数组中 |
notin | > 0 | name.notin('test') | 不在给定数组中 |
between | 2 | created_at.between('2019-12-10', '2020-01-02') | 在两个值之间 |
ge | 1 | created_at.ge('2020-01-01') | 大于或等于给定值 |
gt | 1 | created_at.gt('2020-01-01') | 严格大于给定值 |
le | 1 | created_at.le('2020-01-01') | 小于或等于给定值 |
lt | 1 | sync_seconds.lt(900) | 严格大于给定值 |
like | > 0 | name.like('%test%') | sql字符串匹配任意一个字符串 |
contains | > 0 | name.contains('test') | 包含任意一个给定字符串 |
startswith | > 0 | name.startswith('test') | 以任意一个给定字符串开头 |
endswith | > 0 | name.endswith('test') | 以任意一个给定字符串结尾 |
equals | > 0 | name.equals('test') | 等于任意一个给定值 |
notequals | 1 | name.notequals('test') | 不等于给定值 |
isnull | 0 | name.isnull() | 值为SQL的NULL |
isnotnull | 0 | name.isnotnull() | 值不为SQL的NULL |
isempty | 0 | name.isempty('test') | 值为空字符串 |
isnotempty | 0 | name.isnotempty('test') | 值不是空字符串 |
isnullorempty | 0 | name.isnullorempty('test') | 值为SQL的NULL或者空字符串 |
curl --location --request GET 'https://example.com:30888/configs'
{
"configs": [
{
"attribution": "string",
"can_delete": true,
"can_update": true,
"content": {
"AccessKeyId": "string",
"AccessKeySecret": "string",
"AccessToken": "string",
"AgentId": "string",
"AlertsCode": "string",
"AppId": "string",
"AppKey": "string",
"AppSecret": "string",
"CorpId": "string",
"ErrorCode": "string",
"Hostname": "string",
"Hostport": 0,
"Password": "string",
"PhoneNumber": "string",
"Secret": "string",
"SenderAddress": "string",
"ServiceUrl": "string",
"Signature": "string",
"SmsDriver": "string",
"SslGlobal": true,
"Username": "string",
"VerifiyCode": "string"
},
"created_at": "2019-08-24T14:15:22Z",
"delete_fail_reason": {
"class": "string",
"code": 0,
"details": "string"
},
"deleted": true,
"deleted_at": "2019-08-24T14:15:22Z",
"description": "string",
"domain_id": "string",
"domain_src": "local",
"id": "string",
"is_emulated": true,
"metadata": {
"property1": "string",
"property2": "string"
},
"name": "string",
"project_domain": "string",
"type": "string",
"update_fail_reason": {
"class": "string",
"code": 0,
"details": "string"
},
"update_version": 0,
"updated_at": "2019-08-24T14:15:22Z"
}
],
"limit": 0,
"offset": 0,
"total": 0
}