操作符 | 参数个数 | 举例 | 说明 |
---|---|---|---|
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/guest_images'
json:"status"
{
"guest_images": [
{
"can_delete": true,
"can_update": true,
"created_at": "2019-08-24T14:15:22Z",
"data_images": [
{
"created_at": "2019-08-24T14:15:22Z",
"disable_delete": true,
"disk_format": "string",
"encrypt_key_id": "string",
"id": "string",
"min_disk_mb": 0,
"name": "string",
"size": 0,
"status": "string"
}
],
"delete_fail_reason": {
"class": "string",
"code": 0,
"details": "string"
},
"deleted": true,
"deleted_at": "2019-08-24T14:15:22Z",
"description": "string",
"disable_delete": true,
"disk_format": "string",
"domain_id": "string",
"encrypt_alg": "string",
"encrypt_key": "string",
"encrypt_key_id": "string",
"encrypt_key_user": "string",
"encrypt_key_user_domain": "string",
"encrypt_key_user_domain_id": "string",
"encrypt_key_user_id": "string",
"freezed": true,
"id": "string",
"is_emulated": true,
"is_public": true,
"is_system": true,
"metadata": {
"property1": "string",
"property2": "string"
},
"min_ram_mb": 0,
"name": "string",
"os_arch": "x86 arm",
"pending_deleted": true,
"pending_deleted_at": "2019-08-24T14:15:22Z",
"progress": 0,
"project": "string",
"project_domain": "string",
"project_id": "string",
"project_metadata": {
"property1": "string",
"property2": "string"
},
"project_src": "local",
"properties": {},
"protected": true,
"public_scope": "string",
"public_src": "local",
"root_image": {
"created_at": "2019-08-24T14:15:22Z",
"disable_delete": true,
"disk_format": "string",
"encrypt_key_id": "string",
"id": "string",
"min_disk_mb": 0,
"name": "string",
"size": 0,
"status": "string"
},
"shared_domains": [
{
"id": "string",
"name": "string"
}
],
"shared_projects": [
{
"domain": "string",
"domain_id": "string",
"id": "string",
"name": "string"
}
],
"size": 0,
"status": "string",
"tenant": "string",
"tenant_id": "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
}