文档CURD操作
1、document数据格式
面向文档的搜索分析引擎,其实就是json格式(1)应用系统的数据结构都是面向对象的,复杂的(2)对象数据存储到数据库中,只能拆解开来,变为扁平的多张表,每次查询的时候还得还原回对象格式,相当麻烦(3)ES是面向文档的,文档中存储的数据结构,与面向对象的数据结构是一样的,基于这种文档数据结构,es可以提供复杂的索引,全文检索,分析聚合等功能(4)es的document用json数据格式来表达public class Employee { private String email; private String firstName; private String lastName; private EmployeeInfo info; private Date joinDate;}private class EmployeeInfo { private String bio; // 性格 private Integer age; private String[] interests; // 兴趣爱好}EmployeeInfo info = new EmployeeInfo();info.setBio("curious and modest");info.setAge(30);info.setInterests(new String[]{"bike", "climb"});Employee employee = new Employee();employee.setEmail("zhangsan@sina.com");employee.setFirstName("san");employee.setLastName("zhang");employee.setInfo(info);employee.setJoinDate(new Date());
employee对象:里面包含了Employee类自己的属性,还有一个EmployeeInfo对象
两张表:employee表,employee_info表,将employee对象的数据重新拆开来,变成Employee数据和EmployeeInfo数据employee表:email,first_name,last_name,join_date,4个字段employee_info表:bio,age,interests,3个字段;此外还有一个外键字段,比如employee_id,关联着employee表{ "email": "zhangsan@sina.com", "first_name": "san", "last_name": "zhang", "info": { "bio": "curious and modest", "age": 30, "interests": [ "bike", "climb" ] }, "join_date": "2017/01/01"}
我们就明白了es的document数据格式和数据库的关系型数据格式的区别
2、商品的CRUD操作(document CRUD操作)
(1)新增商品:新增文档,建立索引
PUT /index/type/id{ "json数据"}PUT /ecommerce/product/1{ "name" : "gaolujie yagao", "desc" : "gaolujie meibai", "price" : 30, "producer" : "gaolujie producer", "tags" : ["meibai","fangzhu"]}结果:{ "_index": "ecommerce", "_type": "product", "_id": "1", "_version": 1, "result": "created", "_shards": { "total": 2, "successful": 1, "failed": 0 }, "created": true}
PUT /ecommerce/product/2{ "name" : "jiajieshi yagao", "desc" : "youxiao fangzhu", "price" : 25, "producer" : "jiajieshi producer", "tags" : ["fangzhu"]}PUT /ecommerce/product/3{ "name" : "zhonghua yagao", "desc" : "caoben zhiwu", "price" : 40, "producer" : "zhonghua producer", "tags" : ["qinxin"]}***ES会自动建立index和type,不需要提前创建,而且es默认会对document每个field都建立倒排索引,让其可以被搜索
(2)查询商品:检索文档
GET /index/type/id
GET /ecommerce/product/3结果:{ "_index": "ecommerce", "_type": "product", "_id": "3", "_version": 1, "found": true, "_source": { "name": "zhonghua yagao", "desc": "caoben zhiwu", "price": 40, "producer": "zhonghua producer", "tags": [ "qinxin" ] }}
(3)修改商品:替换文档
PUT /ecommerce/product/1{ "name" : "jiaqiangban gaolujie yagao", "desc" : "gaolujie meibai", "price" : 30, "producer" : "gaolujie producer", "tags" : ["meibai","fangzhu"]}{ "_index": "ecommerce", "_type": "product", "_id": "1", "_version": 2, "result": "updated", "_shards": { "total": 2, "successful": 1, "failed": 0 }, "created": false}替换方式的缺点:即使必须带上所有的field,才能去进行信息的修改
(4)修改商品:更新文档
POST /ecommerce/product/1/_update{ "doc" : { "name" : "gaolujie yagao" }}{ "_index": "ecommerce", "_type": "product", "_id": "1", "_version": 3, "result": "updated", "_shards": { "total": 2, "successful": 1, "failed": 0 }}GET /ecommerce/product/1{ "_index": "ecommerce", "_type": "product", "_id": "1", "_version": 3, "found": true, "_source": { "name": "gaolujie yagao", "desc": "gaolujie meibai", "price": 30, "producer": "gaolujie producer", "tags": [ "meibai", "fangzhu" ] }}
(5)删除商品:删除文档
DELETE /ecommerce/product/1{ "found": true, "_index": "ecommerce", "_type": "product", "_id": "1", "_version": 4, "result": "deleted", "_shards": { "total": 2, "successful": 1, "failed": 0 }}GET /ecommerce/product/1{ "_index": "ecommerce", "_type": "product", "_id": "1", "found": false}
最后: 补回去,后面学习有用
PUT /ecommerce/product/1{ "name" : "gaolujie yagao", "desc" : "gaoxiao meibai", "price" : 30, "producer" : "gaolujie producer", "tags" : ["meibai","fangzhu"]}