elasticsearch案例：创建索引及文档请求示例

Myth丶恋晨 2023-10-14 23:13 118阅读 0赞

1、创建索引库

通过elasticsearch-head创建索引库 xc\_course，1个分片，0个副本。

2、使用postman工具创建映射，post请求：http://localhost:9200/xc\_course/doc/\_mapping

内容如下：

{
    "properties" : {
                
                "description" : {
                    "analyzer" : "ik_max_word",
    	       "search_analyzer": "ik_smart",
                   "type" : "text"
                },
                "grade" : {
                   "type" : "keyword"
                },
                "id" : {
                   "type" : "keyword"
                },
                "mt" : {
                   "type" : "keyword"
                },
                "name" : {
                    "analyzer" : "ik_max_word",
    	       "search_analyzer": "ik_smart",
                   "type" : "text"
                },
    	     "users" : {
                   "index" : false,
                   "type" : "text"
                },
    			"charge" : {
                   "type" : "keyword"
                },
                "valid" : {
                   "type" : "keyword"
                },
                "pic" : {
                   "index" : false,
                   "type" : "keyword"
                },
    		 "qq" : {
                   "index" : false,
                   "type" : "keyword"
                },
                "price" : {
                   "type" : "float"
                },
    		 "price_old" : {
                   "type" : "float"
                },
                "st" : {
                   "type" : "keyword"
                },
                "status" : {
                   "type" : "keyword"
                },
                "studymodel" : {
                   "type" : "keyword"
                },
    	    "teachmode" : {
                   "type" : "keyword"
                },
                "teachplan" : {
                    "analyzer" : "ik_max_word",
    	       "search_analyzer": "ik_smart",
                   "type" : "text"
                },
    
    	    "expires" : {
                   "type" : "date",
    		"format": "yyyy-MM-dd HH:mm:ss"
                },
    	    "pub_time" : {
                   "type" : "date",
    		 "format": "yyyy-MM-dd HH:mm:ss"
                },
    	    "start_time" : {
                   "type" : "date",
    		"format": "yyyy-MM-dd HH:mm:ss"
                },
    	   "end_time" : {
                   "type" : "date",
    		"format": "yyyy-MM-dd HH:mm:ss"
                }
             }
     }

使用postman向elasticsearch添加初始数据

Post http://localhost:9200/xc\_course/doc/4028858162e0bc0a0162e0bfdf1a0000

{
    
    "pub_time":"2018-07-02 19:12:55",
    
    "expires":null,
    
    "mt":"1-3",
    
    "description":"课程大纲： 第一章： Python 介绍、基础语法、流程控制 第二章：Python 数据类型、字符编码学习 第三章： Python 文件操作、函数、装饰器第四章： Python 学用模块、开发规范学习",
    
    "@timestamp":"2018-07-02T11:13:00.274Z",
    
    "grade":"200002",
    
    "charge":"203001",
    
    "start_time":null,
    
    "timestamp":"2018-07-02T11:12:56.000Z",
    
    "qq":"45323453",
    
    "valid":"204001",
    
    "end_time":null,
    
    "name":"Python开发入门",
    
    "users":"零基础，多次从入门到放弃的小白，想要深入学习python的同学",
    
    "id":"4028858162e0bc0a0162e0bfdf1a0000",
    
    "teachplan":"{\"children\":[{\"children\":[{\"grade\":\"3\",\"id\":\"8a7e867a645aa7c801645aad506a0001\",\"pname\":\"Python\u4e0e\u5176\u4ed6\u8bed\u8a00\u7684\u533a\u522b\"}],\"grade\":\"2\",\"id\":\"8a7e867a645aa7c801645aace1f20000\",\"pname\":\"Python\u4ecb\u7ecd\u3001\u57fa\u7840\u8bed\u6cd5\u3001\u6d41\u7a0b\u63a7\u5236\"},{\"children\":[{\"grade\":\"3\",\"id\":\"8a7e867a645aa7c801645aae02090003\",\"pname\":\"\u4e8c\u8fdb\u5236\u8f6c\u6362\"},{\"grade\":\"3\",\"id\":\"8a7e867a645aa7c801645aae5c4b0004\",\"pname\":\"ASCII\u7801\u4e0e\u4e8c\u8fdb\u5236\"}],\"grade\":\"2\",\"id\":\"8a7e867a645aa7c801645aadc16c0002\",\"pname\":\"Python\u6570\u636e\u7c7b\u578b\u3001\u5b57\u7b26\u7f16\u7801\u5b66\u4e60\"},{\"children\":[{\"grade\":\"3\",\"id\":\"8a7e867a645aa7c801645aaf0cbd0006\",\"pname\":\"\u51fd\u6570-\u51fd\u6570\u8fdb\u9636-\u95ed\u5305\"}],\"grade\":\"2\",\"id\":\"8a7e867a645aa7c801645aaed7dc0005\",\"pname\":\"Python\u6587\u4ef6\u64cd\u4f5c\u3001\u51fd\u6570\u3001\u88c5\u9970\u5668\"}],\"grade\":\"1\",\"id\":\"4028858162e0bc0a0162e0bfdf2b0001\",\"pname\":\"\u4eba\u5de5\u667a\u80fd+python\"}",
    
    "st":"1-3-6",
    
    "@version":"1",
    
    "price":0.009999999776482582,
    
    "pic":"group1/M00/00/00/rBEAa1s96cOAaglmAAAfBQbuVNA131.jpg",
    
    "studymodel":"201001",
    
    "teachmode":null,
    
    "price_old":null
    
    }

post

http://49.4.87.154:30968/xc\_course/doc/4028e58161bd22e60161bd23672a0001

{
    
    "pub_time":"2018-07-02 19:18:37",
    
    "expires":null,
    
    "mt":"1-1",
    
    "description":"如果你之前已经习惯了用jQuery操作DOM，学习Vue.js时请先抛开手动操作DOM的思维，因为Vue.js是数据驱动的，你无需手动操作DOM。 它通过一些特殊的HTML语法，将DOM和数据绑定起来。 一旦你创建了绑定，DOM将和数据保持同步，每当变更了数据，DOM也会相应地更新。",
    
    "@timestamp":"2018-07-02T11:19:00.203Z",
    
    "grade":"200002",
    
    "charge":"203001",
    
    "start_time":null,
    
    "timestamp":"2018-07-02T11:18:38.000Z",
    
    "qq":"4324322",
    
    "valid":"204002",
    
    "end_time":null,
    
    "name":"vue2.0高级教程",
    
    "users":"有一定的css，html，和js基础开发者，前端开发，传统web开发。",
    
    "id":"4028e58161bd22e60161bd23672a0001",
    
    "teachplan":"{\"children\":[{\"children\":[{\"grade\":\"3\",\"id\":\"4028e58161bd269f0161bd2778750001\",\"pname\":\"第一节 vue基础\"},{\"grade\":\"3\",\"id\":\"4028e58161bd269f0161bd27d7c50002\",\"pname\":\"第二节属性和事件、模板、交互、案例\"}],\"grade\":\"2\",\"id\":\"4028e58161bd269f0161bd270a340000\",\"pname\":\"Vuejs第一讲\"},{\"children\":[{\"grade\":\"3\",\"id\":\"4028e58161bd269f0161bd2877740005\",\"pname\":\"第一节计算属性的使用、vue实例的简单方法\"},{\"grade\":\"3\",\"id\":\"4028e58161bd269f0161bd293df90006\",\"pname\":\"第二节自定义过滤器、自定义指令\"}],\"grade\":\"2\",\"id\":\"4028e58161bd269f0161bd281bde0003\",\"pname\":\"Vuejs第二讲\"},{\"children\":[],\"grade\":\"2\",\"id\":\"4028e58161bd269f0161bd284bad0004\",\"pname\":\"Vuejs第三讲\"}],\"grade\":\"1\",\"id\":\"4028e58161bd22e60161bd2366fb0000\",\"pname\":\"Javascript之VueJS\"}",
    
    "st":"1-1-9",
    
    "@version":"1",
    
    "price":0.009999999776482582,
    
    "pic":"group1/M00/00/00/rBEAa1s-JPyATixdAABhNYbB2oM761.jpg",
    
    "studymodel":"201001",
    
    "teachmode":null,
    
    "price_old":null
    
    }

post

http://49.4.87.154:30968/xc\_course/doc/402885816243d2dd016243f24c030002

{
    
    "pub_time":"2018-04-25 19:11:35",
    
    "expires":null,
    
    "mt":"1-3",
    
    "description":"Bos物流项目2.0是传智播客推出的高级项目课程，课程包括了项目概述、系统管理、用户管理、运单管理、统计分析等模块，深入浅出的讲解了当前的流行技术。",
    
    "@timestamp":"2018-07-02T11:26:00.058Z",
    
    "grade":"200001",
    
    "charge":"203001",
    
    "start_time":null,
    
    "timestamp":"2018-07-03T10:28:58.000Z",
    
    "qq":null,
    
    "valid":"204002",
    
    "end_time":null,
    
    "name":"Bos物流项目2.0",
    
    "users":"本项目适应于具有一定java基础的开发人员。",
    
    "id":"402885816243d2dd016243f24c030002",
    
    "teachplan":"{\"children\":[{\"children\":[{\"grade\":\"3\",\"id\":\"297e02f7639af61a01639afd3a7b0000\",\"pname\":\"业务需求分析\"},{\"grade\":\"3\",\"id\":\"8a7e867a6459d24c016459e507260000\",\"pname\":\"订单业务分析\"}],\"grade\":\"2\",\"id\":\"402885816243d2dd016243f24c040003\",\"pname\":\"项目概述\"},{\"children\":[{\"grade\":\"3\",\"id\":\"8a7e867a6459d24c016459e745410001\",\"pname\":\"ElasticSearch下载安装\"},{\"grade\":\"3\",\"id\":\"8a7e867a6459d24c016459e7cac90002\",\"pname\":\"ElasticSearch入门案例\"}],\"grade\":\"2\",\"id\":\"1011\",\"pname\":\"运单管理\"}],\"grade\":\"1\",\"id\":\"1012\",\"pname\":\"Bos物流项目课程\"}",
    
    "st":"1-3-2",
    
    "@version":"1",
    
    "price":98,
    
    "pic":"group1/M00/00/00/rBEAa1s-JKqAGRsQAAJx5ZjNDEM811.jpg",
    
    "studymodel":"201001",
    
    "teachmode":null,
    
    "price_old":199
    
    }

Post http://localhost:9200/xc\_course\_media/doc/40281f8164553706016455390e140001

{
    "courseid": "297e7c7c62b8aa9d0162b8ab56ba0001",
    "media_id": "595e4d0fca23387ca9b5ded130630909",
    "media_url": "5/9/595e4d0fca23387ca9b5ded130630909/hls/595e4d0fca23387ca9b5ded130630909.m3u8",
    "teachplan_id": "40281f8164553706016455390e140001",
    "timestamp": "2018-07-07T15:51:59.000Z",
    "media_fileoriginalname": "01Vue基础- MVVM模式讲解.avi"
    }

Post http://localhost:9200/xc\_course\_media/doc/40281f81645537060164553a783f0005

{
    "courseid": "297e7c7c62b8aa9d0162b8ab56ba0001",
    "media_id": "53ac4cca3ddf386c21f4f1cbb4dc9876",
    "media_url": "5/3/53ac4cca3ddf386c21f4f1cbb4dc9876/hls/53ac4cca3ddf386c21f4f1cbb4dc9876.m3u8",
    "teachplan_id": "40281f81645537060164553a783f0005",
    "timestamp": "2018-07-07T15:51:59.000Z",
    "media_fileoriginalname": "3.avi"
    }

Post http://localhost:9200/xc\_course\_media/doc/40281f81645537060164553a29d80004

{
    "courseid": "297e7c7c62b8aa9d0162b8ab56ba0001",
    "media_id": "809694a6a974c35e3a36f36850837d7c",
    "media_url": "8/0/809694a6a974c35e3a36f36850837d7c/hls/809694a6a974c35e3a36f36850837d7c.m3u8",
    "teachplan_id": "40281f81645537060164553a29d80004",
    "timestamp": "2018-07-07T15:51:59.000Z",
    "media_fileoriginalname": "1.avi"
    }

Post http://localhost:9200/xc\_course\_media/doc/40281f81645537060164553972790002

{
    "courseid": "297e7c7c62b8aa9d0162b8ab56ba0001",
    "media_id": "1cfabb64792eaf2a0d9d72d237e07256",
    "media_url": "1/c/1cfabb64792eaf2a0d9d72d237e07256/hls/1cfabb64792eaf2a0d9d72d237e07256.m3u8",
    "teachplan_id": "40281f81645537060164553972790002",
    "timestamp": "2018-07-07T15:51:59.000Z",
    "media_fileoriginalname": "03Vue基础 - 系统指令v-on注册事件.avi"
    }