導航

{
"info": {
"_postman_id": "7745c9e1-e87f-4385-adc9-16bc2ea8efc0",
"name": "es7.7.0",
"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json"
},
"item": [
{
"name": "獲取",
"item": [
{
"name": "分頁排序獲取",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n "query": { "match_all": {} },\r\n "sort": [\r\n { "account_number": "asc" }\r\n ],\r\n "from": 1,\r\n "size": 3\r\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_search?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_search"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
},
{
"name": "獲取指定主鍵",
"request": {
"method": "GET",
"header": [],
"body": {
"mode": "raw",
"raw": ""
},
"url": {
"raw": "http://{{http_ip_port}}/customer/_doc/1?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"customer",
"_doc",
"1"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
},
{
"name": "獲取指定單詞",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n "query": {\n "match": {\n "address": "mill lane"\n }\n }\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_search?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_search"
],
"query": [
{
"key": "pretty",
"value": null
}
]
},
"description": "單詞可多個，空格隔開，每個單詞都是獨立搜索"
},
"response": []
},
{
"name": "獲取指定內容",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n "query": {\n "match_phrase": {\n "address": "Kings Place"\n }\n }\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_search?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_search"
],
"query": [
{
"key": "pretty",
"value": null
}
]
},
"description": "match_phrase是查找短語，會將搜索內容作為整體進行匹配，對于field來說仍然是模糊匹配，這個例子類比mysql中的 address like '%mill lane%'"
},
"response": []
},
{
"name": "多條件獲取",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n "query": {\r\n "bool": {\r\n "must": [\r\n { "match": { "age": "40" } }\r\n ],\r\n "must_not": [\r\n { "match": { "state": "ID" } }\r\n ]\r\n }\r\n }\r\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_search?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_search"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
},
{
"name": "多條件獲取1",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n "query": {\r\n "bool": {\r\n "must": [\r\n \t{ "match_phrase": { "address": "mill lane" } }\r\n ],\r\n "must_not": [\r\n { "match": { "age": "40" } }\r\n ],\r\n "filter": {\r\n "range": {\r\n "balance": {\r\n "gte": 40000,\r\n "lte": 50000\r\n }\r\n }\r\n }\r\n }\r\n },\r\n "sort": [\r\n { "account_number": "asc" }\r\n ],\r\n "from": 0,\r\n "size": 2\r\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_search?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_search"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
},
{
"name": "過濾器獲取",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n "query": {\r\n "bool": {\r\n "must": { "match_all": {} },\r\n "filter": {\r\n "range": {\r\n "balance": {\r\n "gte": 20000,\r\n "lte": 30000\r\n }\r\n }\r\n }\r\n }\r\n }\r\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_search?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_search"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
},
{
"name": "聚合查詢",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n "size": 0,\r\n "aggs": {\r\n "group_by_state": {\r\n "terms": {\r\n "field": "state.keyword"\r\n ,"size": 2\r\n }\r\n \r\n }\r\n \r\n }\r\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_search?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_search"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
},
{
"name": "復雜聚合查詢1-分組求和",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n "size": 0,\r\n "aggs": {\r\n "group_by_state": {\r\n "terms": {\r\n "field": "state.keyword"\r\n },\r\n "aggs": {\r\n "average_balance": {\r\n "avg": {\r\n "field": "balance"\r\n }\r\n }\r\n }\r\n }\r\n }\r\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_search?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_search"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
},
{
"name": "復雜聚合查詢2-分組求和排序",
"protocolProfileBehavior": {
"disableBodyPruning": true
},
"request": {
"method": "GET",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\n "size": 0,\n "query": {\n "bool": {\n "filter": {\n "range": {\n "age": {\n "gte": 40\n }\n }\n }\n }\n },\n "aggs": {\n "group_by_state": {\n "terms": {\n "field": "state.keyword",\n "order": {\n "average_balance": "desc"\n },\n "size": 2,\n "shard_size": 4\n },\n "aggs": {\n "average_balance": {\n "avg": {\n "field": "balance"\n }\n },\n "stats_balance": {\n "stats": {\n "field": "balance"\n }\n }\n }\n }\n }\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_search?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_search"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
}
]
},
{
"name": "插入",
"item": [
{
"name": "插入索引",
"request": {
"method": "PUT",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n "name": "John Doe"\r\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/customer/_doc/1?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"customer",
"_doc",
"1"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
},
{
"name": "批量插入索引",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "file",
"file": {}
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_bulk?pretty&refresh",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_bulk"
],
"query": [
{
"key": "pretty",
"value": null
},
{
"key": "refresh",
"value": null
}
]
}
},
"response": []
},
{
"name": "插入指定id數據",
"request": {
"method": "PUT",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{"account_number":1047,"balance":164118,"firstname":"Elinor1","lastname":"Ratliff1","age":38,"gender":"M","address":"283 Kings Place","employer":"Scentric1","email":"elinorratliff@scentric.com","city":"Ribera","state":"WA"}"
},
"url": {
"raw": "http://{{http_ip_port}}/bank/_doc/1047",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"bank",
"_doc",
"1047"
]
}
},
"response": []
},
{
"name": "更新數據",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"value": "application/json",
"type": "text"
}
],
"body": {
"mode": "raw",
"raw": "{\r\n "name": "John Doe"\r\n}"
},
"url": {
"raw": "http://{{http_ip_port}}/customer/_doc?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"customer",
"_doc"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
}
]
},
{
"name": "es信息",
"item": [
{
"name": "查看集群索引信息",
"request": {
"method": "GET",
"header": [],
"body": {
"mode": "raw",
"raw": ""
},
"url": {
"raw": "http://{{http_ip_port}}/_cat/indices?v",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"_cat",
"indices"
],
"query": [
{
"key": "v",
"value": null
}
]
}
},
"response": []
},
{
"name": "查看集群狀態",
"request": {
"method": "GET",
"header": [],
"body": {
"mode": "raw",
"raw": ""
},
"url": {
"raw": "http://{{http_ip_port}}/_cat/health?v",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"_cat",
"health"
],
"query": [
{
"key": "v",
"value": null
}
]
}
},
"response": []
}
]
},
{
"name": "刪除",
"item": [
{
"name": "刪除指定id",
"request": {
"method": "DELETE",
"header": [],
"body": {
"mode": "raw",
"raw": ""
},
"url": {
"raw": "http://{{http_ip_port}}/customer/_doc/1?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"customer",
"_doc",
"1"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
},
{
"name": "刪除索引",
"request": {
"method": "DELETE",
"header": [],
"body": {
"mode": "raw",
"raw": ""
},
"url": {
"raw": "http://{{http_ip_port}}/customer?pretty",
"protocol": "http",
"host": [
"{{http_ip_port}}"
],
"path": [
"customer"
],
"query": [
{
"key": "pretty",
"value": null
}
]
}
},
"response": []
}
]
}
]
}