elasticSearch使用LocaldateTime

elasticSearch版本6.8.12 springboot版本2.2.7 springdataelasticSearch版本3.2.7

使用 

ElasticsearchRepository  向elasticSearch 中添加 时间类型为LocaldateTime 的记录

entity

package com.aila.elasticSearch.POJO;

import com.alibaba.fastjson.annotation.JSONField;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import org.springframework.data.annotation.Id;
import org.springframework.data.elasticsearch.annotations.*;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.time.LocalDateTime;

/**
 * <p>
 * 艾拉项目  音乐表
 * </p>
 *
 * @author chenzhichao
 * @since 2020-12-08
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@Document(indexName = "music",shards=5,replicas = 2)
public class MusicElasticEntity implements Serializable{

    @ApiModelProperty(value = "音乐表主键id")
    @Field(index = true, store = true, type = FieldType.Keyword)
    @Id
    private Long id;

    @ApiModelProperty(value = "音乐名称")
    @Field(index = true, store = true, type = FieldType.Text, analyzer = "ik_smart")
    private String name;

    @ApiModelProperty(value = "歌手名称")
    @Field(index = true, store = true, type = FieldType.Text)
    private String singer;

    @ApiModelProperty(value = "歌曲链接地址")
    @Field(index = false, store = true, type = FieldType.Text)
    private String linkUrl;

    @ApiModelProperty(value = "专辑名称")
    @Field(index = true, store = true, type = FieldType.Text)
    private String albumName;

    @ApiModelProperty(value = "mv链接地址")
    @Field(index = false, store = true, type = FieldType.Text)
    private String mvUrl;

    @ApiModelProperty(value = "封面Url")
    @Field(index = false, store = true, type = FieldType.Text)
    private String cover;

    @ApiModelProperty(value = "状态 1 上架状态  0下架状态 ")
    @Field(index = true, store = true, type = FieldType.Integer)
    private Integer status;

    @ApiModelProperty(value = "删除标志 1删除  0未删除")
    @Field(index = true, store = true, type = FieldType.Integer)
    private Integer deleteFlag;

    @ApiModelProperty(value = "歌词链接Url")
    @Field(index = false, store = true, type = FieldType.Text)
    private String lyricLinkUrl;

    @ApiModelProperty(value = "歌曲时长")
    @Field(index = false, store = true, type = FieldType.Date,format = DateFormat.custom, pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    //@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    //@JSONField(format = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime duration;

    @ApiModelProperty(value = "发行商")
    @Field(index = true, store = true, type = FieldType.Text)
    private String publisher;

    @ApiModelProperty(value = "发行时间")
    @Field(index = false, store = true, type = FieldType.Date)
    private LocalDateTime issueTime;

    @ApiModelProperty(value = "一级分类")
    @Field(index = true, store = true, type = FieldType.Integer)
    private Integer musicTypeId;

    @ApiModelProperty(value = "二级分类")
    @Field(index = true, store = true, type = FieldType.Integer)
    private Integer parentMusicTypeId;

    @ApiModelProperty(value = "三级分类")
    @Field(index = true, store = true, type = FieldType.Integer)
    private Integer grandpaMusicTypeId;

    @ApiModelProperty(value = "创建时间")
    private LocalDateTime createdTime;

    @ApiModelProperty(value = "更新时间")
    private LocalDateTime updateTime;

    @ApiModelProperty(value = "更新人 userId")
    private Long updateBy;

    @ApiModelProperty(value = "创建人 userId")
    private Long createdBy;


}

test类

package com.aila.elasticSearch.service.impl;

import com.aila.elasticSearch.POJO.MusicElasticEntity;
import com.aila.elasticSearch.service.IMusicService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.autoconfigure.web.servlet.AutoConfigureMockMvc;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import javax.annotation.Resource;
import java.time.LocalDateTime;


/**
 * @author chenzhichao
 * @date 2020/12/8 16:38
 * 使用es版本  6-8-12 ik分词器版本6-8-12
 */
@RunWith(SpringRunner.class)
@AutoConfigureMockMvc
@SpringBootTest
public class MusicServiceImplTest {

    @Resource
    private IMusicService iMusicService;
    @Test
    public void add() {
        MusicElasticEntity entity = new MusicElasticEntity();
        entity.setId(16L).setName("亲情式的爱情").setSinger("许嵩")
                .setAlbumName("梦游计").setStatus(1).setDeleteFlag(0).setMusicTypeId(3)
                .setParentMusicTypeId(4).setGrandpaMusicTypeId(5)
                //时间这块没有解决
                .setDuration(LocalDateTime.of(2020,12,8,0,4,44));
                //.setDuration(new Date());
                //.setDuration("2020-12-08 00:04:44");
        iMusicService.add(entity);
    }
    @Test
    public void findByEntityId() {
        //MusicElasticEntity entity = iMusicService.findByEntityId(13L);
        MusicElasticEntity entity = iMusicService.findByEntityId(15L);
        System.out.println(entity);
    }
    @Test
    public void deleteMappingAndIndex() {
        iMusicService.deleteMappingAndIndex("com.aila.elasticSearch.POJO.MusicElasticEntity");
    }
    @Test
    public void createMappingAndIndex() {
        iMusicService.createMappingAndIndex("com.aila.elasticSearch.POJO.MusicElasticEntity");
    }
}

serviceImpl

package com.aila.elasticSearch.service.impl;

import com.aila.elasticSearch.POJO.MusicElasticEntity;
import com.aila.elasticSearch.entity.Music;
import com.aila.elasticSearch.mapper.MusicElasticMapper;
import com.aila.elasticSearch.mapper.MusicMapper;
import com.aila.elasticSearch.service.IMusicService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.google.gson.Gson;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.elasticsearch.core.ElasticsearchTemplate;
import org.springframework.scheduling.annotation.Async;
import org.springframework.stereotype.Service;
import org.springframework.util.Assert;

import javax.annotation.Resource;
import java.util.Optional;

/**
 * <p>
 * 艾拉项目  音乐表 服务实现类
 * </p>
 *
 * @author chenzhichao
 * @since 2020-12-08
 */
@Service
@Slf4j
public class MusicServiceImpl extends ServiceImpl<MusicMapper, Music> implements IMusicService {

    @Autowired
    private MusicElasticMapper musicElasticMapper;
    @Resource
    private ElasticsearchTemplate elasticsearchTemplate;
    @Autowired
    private Gson gson;

    @Override
    public void createMappingAndIndex(String className) {
        Class<?> targetClass = null;
        try {
            targetClass = Class.forName(className);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        Assert.notNull(targetClass,"创建class对象失败");
        elasticsearchTemplate.createIndex(targetClass);
        elasticsearchTemplate.putMapping(targetClass);
    }

    @Override
    public void deleteMappingAndIndex(String className) {
        Class<?> targetClass = null;
        try {
            targetClass = Class.forName(className);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        Assert.notNull(targetClass,"创建class对象失败");
        elasticsearchTemplate.deleteIndex(targetClass);
    }

    @Override
    public void add(MusicElasticEntity entity) {
        log.error("开始添加"+gson.toJson(entity));
        musicElasticMapper.save(entity);
        log.error("结束");
    }

    @Override
    public MusicElasticEntity findByEntityId(Long id) {
        Optional<MusicElasticEntity> optional = musicElasticMapper.findById(id);
        MusicElasticEntity elasticEntity=null;
        if (optional.isPresent()) {
            elasticEntity = optional.get();
        }
        return elasticEntity;
    }
}

配置类

package com.aila.elasticSearch.config;

import com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.datatype.jsr310.JavaTimeModule;
import org.elasticsearch.client.Client;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.elasticsearch.core.ElasticsearchTemplate;
import org.springframework.data.elasticsearch.core.EntityMapper;
import org.springframework.data.elasticsearch.core.geo.CustomGeoModule;
import org.springframework.data.mapping.MappingException;

import java.io.IOException;
import java.util.HashMap;
import java.util.Map;

/**
 * @author chenzhichao
 * @date 2020/12/14 11:15
 */
@Configuration
public class ElasticSearchConfiguration {
    @Bean
    public ElasticsearchTemplate elasticsearchTemplate(Client client) {
        return new ElasticsearchTemplate(client, new CustomEntityMapper());
    }

    public static class CustomEntityMapper implements EntityMapper {

        private final ObjectMapper objectMapper;

        public CustomEntityMapper() {
            objectMapper = new ObjectMapper();
            objectMapper.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false);
            objectMapper.configure(DeserializationFeature.ACCEPT_SINGLE_VALUE_AS_ARRAY, true);
            objectMapper.registerModule(new CustomGeoModule());
            objectMapper.registerModule(new JavaTimeModule());
        }

        @Override
        public String mapToString(Object object) throws IOException {
            return objectMapper.writeValueAsString(object);
        }

        @Override
        public <T> T mapToObject(String source, Class<T> clazz) throws IOException {
            return objectMapper.readValue(source, clazz);
        }

        @Override
        public Map<String, Object> mapObject(Object source) {
            try {
                return objectMapper.readValue(mapToString(source), HashMap.class);
            } catch (IOException e) {
                throw new MappingException(e.getMessage(), e);
            }
        }

        @Override
        public <T> T readObject(Map<String, Object> source, Class<T> targetType) {
            try {
                return mapToObject(mapToString(source), targetType);
            } catch (IOException e) {
                throw new MappingException(e.getMessage(), e);
            }
        }
    }
}

如果没有这个配置类  LocaldateTime 会被转成

一个类似下面的json 串 而elasticSearch 序列化不了这个json

"creationDate": {
    "dayOfYear": 123,
    "dayOfWeek": "FRIDAY",
    "month": "MAY",
    "dayOfMonth": 3,
    "year": 2019,
    "monthValue": 5,
    "hour": 11,
    "minute": 54,
    "second": 12,
    "nano": 238000000,
    "chronology": {
        "id": "ISO",
        "calendarType": "iso8601"
    }
},

所以需要自定义entityMapper的对象使用jackson 来转化 对应的localdateTIme来实现