es操作模板类-封装restHighLevelClient相关操作,数据迁移使用

4 篇文章 0 订阅
3 篇文章 0 订阅
本文档记录了从MongoDB和MySQL数据迁移至Elasticsearch(ES)的过程,包括索引创建、别名管理、数据添加、更新与删除等核心操作。提供了详细的Java代码示例,展示了如何使用RestHighLevelClient进行ES操作。
摘要由CSDN通过智能技术生成

本人在进行数据迁移,主要是从mongo和mysql中的数据迁移到es中,测试了一下,效果还不错,故此记录一下,这篇主要是es的封装相关。
如果想看迁移相关代码,链接如下:从mongo迁移数据到es中

代码如下:

package com.jesse.metadata.utils;

import java.io.IOException;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.stream.Collectors;

import com.jesse.metadata.model.EsDataSync;
import org.apache.commons.lang3.StringUtils;
import org.elasticsearch.action.admin.indices.alias.IndicesAliasesRequest;
import org.elasticsearch.action.admin.indices.alias.get.GetAliasesRequest;
import org.elasticsearch.action.admin.indices.delete.DeleteIndexRequest;
import org.elasticsearch.action.bulk.BulkRequest;
import org.elasticsearch.action.bulk.BulkResponse;
import org.elasticsearch.action.delete.DeleteRequest;
import org.elasticsearch.action.delete.DeleteResponse;
import org.elasticsearch.action.get.GetRequest;
import org.elasticsearch.action.get.GetResponse;
import org.elasticsearch.action.index.IndexRequest;
import org.elasticsearch.action.index.IndexResponse;
import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.action.support.master.AcknowledgedResponse;
import org.elasticsearch.action.update.UpdateRequest;
import org.elasticsearch.action.update.UpdateResponse;
import org.elasticsearch.client.GetAliasesResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.client.indices.CreateIndexRequest;
import org.elasticsearch.client.indices.CreateIndexResponse;
import org.elasticsearch.client.indices.GetIndexRequest;
import org.elasticsearch.cluster.metadata.AliasMetaData;
import org.elasticsearch.common.settings.Settings;
import org.elasticsearch.common.unit.TimeValue;
import org.elasticsearch.common.xcontent.XContentType;
import org.elasticsearch.index.query.FuzzyQueryBuilder;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.builder.SearchSourceBuilder;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.util.CollectionUtils;
import lombok.extern.slf4j.Slf4j;

/**
 * es操作模板类-封装
 * @author jesse
 * @date 2021-9-21 15:24:52
 */
@Component
@Slf4j
public class ElasticsearchTemplate<TEntity extends Serializable> {

    @Autowired
    private RestHighLevelClient restHighLevelClient;

    /**
     * 创建索引(可以指定映射)
     * @param indexName 索引名称;
     * @param mapping 映射;
     * @throws IOException
     */
    public void createIndex(String indexName, String mapping) throws IOException {

        // 1. 查询索引是否存在  hdgp_data_api_index
        GetIndexRequest getIndexRequest = new GetIndexRequest(indexName);
        boolean exists = restHighLevelClient.indices().exists(getIndexRequest, RequestOptions.DEFAULT);
        if(!exists){

            // 2. 执行创建请求 使用默认参数 请求之后获得响应
            CreateIndexRequest createIndexRequest = new CreateIndexRequest(indexName);
            createIndexRequest.settings(Settings.builder()
                    .put("index.number_of_shards", 5)
                    .put("index.number_of_replicas", 1));
            // 添加映射;
           if (StringUtils.isNotBlank(mapping)) {
                createIndexRequest.mapping(mapping, XContentType.JSON);
            }
            CreateIndexResponse createIndexResponse = restHighLevelClient.indices().create(createIndexRequest, RequestOptions.DEFAULT);
            log.info("索引创建成功:{}",createIndexResponse.index());
        }

    }

    /**
     * 根据别名查询索引名称
     * @param aliasName
     * @throws IOException
     */
    public List<String> getIndexListByAlias(String aliasName) throws IOException {
        List<String> indexList = new ArrayList<>();
        GetAliasesRequest getAliasesRequest = new GetAliasesRequest();
        getAliasesRequest.aliases(aliasName);
        GetAliasesResponse getAliasesResponse = restHighLevelClient.indices()
                .getAlias(getAliasesRequest,RequestOptions.DEFAULT);
        Map<String, Set<AliasMetaData>> resultMap =  getAliasesResponse.getAliases();
        if(!CollectionUtils.isEmpty(resultMap)){
            indexList = resultMap.keySet().stream().collect(Collectors.toList());
        }
        return indexList;
    }

    /**
     * 重命名别名,解除旧索引的别名,填加新索引的别名
     * @param oldIndexName
     * @param newIndexName
     * @param aliasName
     * @throws IOException
     */
    public boolean renameAliases(String oldIndexName, String newIndexName, String aliasName) throws IOException {
        IndicesAliasesRequest indicesAliasesRequest = new IndicesAliasesRequest();
        if(StringUtils.isNotBlank(oldIndexName)){
            indicesAliasesRequest
                    .addAliasAction(IndicesAliasesRequest.AliasActions.remove().index(oldIndexName).alias(aliasName));
        }
        indicesAliasesRequest
                .addAliasAction(IndicesAliasesRequest.AliasActions.add().index(newIndexName).alias(aliasName));
        AcknowledgedResponse acknowledgedResponse = restHighLevelClient.indices()
                .updateAliases(indicesAliasesRequest,RequestOptions.DEFAULT);
        return acknowledgedResponse.isAcknowledged();
    }

    /**
     * 移除别名
     * @param indexName
     * @param aliasName
     * @throws IOException
     */
    public boolean removeAliases(String indexName, String aliasName) throws IOException {
        IndicesAliasesRequest indicesAliasesRequest = new IndicesAliasesRequest();
        indicesAliasesRequest.addAliasAction(IndicesAliasesRequest.AliasActions.remove().index(indexName).alias(aliasName));
        AcknowledgedResponse acknowledgedResponse = restHighLevelClient.indices()
                .updateAliases(indicesAliasesRequest,RequestOptions.DEFAULT);
        return acknowledgedResponse.isAcknowledged();
    }

    /**
     * 添加别名
     * @param indexName
     * @param aliasName
     * @throws IOException
     */
    public boolean addAliases(String indexName, String aliasName) throws IOException {
        IndicesAliasesRequest indicesAliasesRequest = new IndicesAliasesRequest();
        indicesAliasesRequest.addAliasAction(IndicesAliasesRequest.AliasActions.add().index(indexName).alias(aliasName));
        AcknowledgedResponse acknowledgedResponse = restHighLevelClient.indices()
                .updateAliases(indicesAliasesRequest,RequestOptions.DEFAULT);
        return acknowledgedResponse.isAcknowledged();
    }


    /**
     * 删除索引
     * @param indexName
     * @throws IOException
     */
    public void deleteIndex(String indexName) throws IOException {
        DeleteIndexRequest deleteIndexRequest = new DeleteIndexRequest(indexName);
        AcknowledgedResponse deleteAcknowledgedResponse = restHighLevelClient.indices().delete(deleteIndexRequest, RequestOptions.DEFAULT);
        log.info((deleteAcknowledgedResponse.isAcknowledged() == true) ? "该索引删除成功!" : "该索引删除失败!");
    }

    /**
     * 添加文档信息
     * @param indexName
     * @param esDataSync
     * @throws IOException
     */
    public void createDocument(String indexName, EsDataSync<TEntity> esDataSync) throws IOException {
        //插入的文档对象
        IndexRequest indexRequest = new IndexRequest(indexName);

        // 创建HTTP请求 PUT hdgp_data_api_index/_doc/1 是Restful的写法
        indexRequest.id(esDataSync.getEsId());
        indexRequest.timeout(TimeValue.timeValueSeconds(1));

        //装入JSON对象数据
        indexRequest.source(JsonUtil.toJsonStr(esDataSync.getData()), XContentType.JSON);

        //发送请求 并拿到结果
        IndexResponse indexResponse = restHighLevelClient.index(indexRequest, RequestOptions.DEFAULT);
        log.info("response status:{},response result:{}" ,indexResponse.status(),indexResponse.toString());
    }

    /**
     * 根据索引名与ID值查询文档内容
     * @param indexName
     * @param documentId
     * @return
     * @throws IOException
     */
    public String queryDocumentById(String indexName, String documentId) throws IOException {
        GetRequest getRequest = new GetRequest(indexName, documentId);
        GetResponse getResponse = restHighLevelClient.get(getRequest, RequestOptions.DEFAULT);
        String document = getResponse.getSourceAsString();
        log.info("response document:{}" ,document);
        return document;
    }

    /**
     * 根据索引名与ID值 更新文档内容
     */
    public void updateDocumentById(String indexName,EsDataSync<TEntity> esDataSync) throws IOException {
        UpdateRequest updateRequest =  new UpdateRequest(indexName, esDataSync.getEsId());
        updateRequest.timeout(TimeValue.timeValueSeconds(1));

        updateRequest.doc(JsonUtil.toJsonStr(esDataSync.getData()), XContentType.JSON);
        UpdateResponse updateResponse = restHighLevelClient.update(updateRequest, RequestOptions.DEFAULT);
        log.info("status:{}", updateResponse.status());
    }

    /**
     * 删除文档记录
     */
    public void deleteDocumentById(String indexName,String documentId) throws IOException {
        DeleteRequest deleteRequest = new DeleteRequest(indexName, documentId);
        DeleteResponse deleteResponse = restHighLevelClient.delete(deleteRequest, RequestOptions.DEFAULT);
        log.info("status:{}",deleteResponse.status());
    }

    /**
     * 批量添加文档记录
     */
    public BulkResponse addBatchDocument(String indexName, List<EsDataSync<TEntity>> list) throws IOException {
        log.info("批量插入,索引:{},数据:{}", indexName, list);

        if(CollectionUtils.isEmpty(list)){
            return null;
        }
        // 创建索引
        createIndex(indexName,null);

        BulkRequest bulkRequest = new BulkRequest();
        list.forEach(esDataSync ->{
            bulkRequest.add(new IndexRequest(indexName)
                    .id(esDataSync.getEsId())
                    .source(JsonUtil.toJsonStr(esDataSync.getData()),XContentType.JSON));
        });

        BulkResponse bulkResponse = restHighLevelClient.bulk(bulkRequest, RequestOptions.DEFAULT);
        log.info("批量插入状态:{}", bulkResponse.status());
        return bulkResponse;
    }
    /**
    * 根据给定的字段设置对应的映射;
    * 这里用的分词器时hanLp;
    */
    public String getMapping(String[] fields) {
        List<String> filedList = Arrays.asList(fields);
        HashMap<String, Object> mapings = new HashMap<>();
        HashMap<String, Object> map = new HashMap<>();
        String analyerString = "{\"type\" : \"text\",\n" +
                "          \"analyzer\" : \"hanlp\",\n" +
                "          \"fields\" : {\n" +
                "            \"keyword\" : {\n" +
                "              \"type\" : \"keyword\",\n" +
                "              \"ignore_above\" : 256\n" +
                "            }\n" +
                "          }}";
        HashMap<String, Object> analyerMap = JsonUtil.readJson(analyerString, HashMap.class);
        filedList.forEach(field->map.put(field,analyerMap));
        mapings.put("properties", map);
        String mappings = JsonUtil.toJsonStr(mapings);
        return mappings;
    }

    /**
     * 测试查询
     */
    public void searchTest() throws IOException {
        //1. 新建一个请求 确定查询哪一个索引
        SearchRequest searchRequest = new SearchRequest("hdgp_*");
        //2. 构建查询体对象
        SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
        //3. 构建精准查询
        FuzzyQueryBuilder termQueryBuilder = QueryBuilders.fuzzyQuery("userName", "峰");
        //查询对象使用这个精确查询
        searchSourceBuilder.query(termQueryBuilder);
        searchSourceBuilder.timeout(TimeValue.timeValueSeconds(60));
        //这个请求使用这个查询体
        searchRequest.source(searchSourceBuilder);

        //通过请求发出 返回的响应中 去取出对应的数据对象
        SearchResponse searchResponse = restHighLevelClient.search(searchRequest, RequestOptions.DEFAULT);

        //对应的数据对象是存储在数组中的 循环遍历即可
        for (SearchHit documentFields : searchResponse.getHits().getHits()) {
            System.out.println(documentFields.getSourceAsMap());
        }
    }
}

EsDataSync类:

package com.jesse.task.domain;

import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;

import java.io.Serializable;

/**
 * @author jesse
 * @date 2021/9/21
 */
@Data
@NoArgsConstructor
@ToString
public class EsDataSync<TEntity extends Serializable> implements Serializable{

    /**
     * es id,同数据的主键id
     */
    private String esId;

    /**
     * 待同步的数据
     */
    private TEntity data;

    /**
     * es索引名称
     */
    private String indexName;


    public EsDataSync(String esId, TEntity data) {
        this.esId = esId;
        this.data = data;
    }
}

JsonUtil类:

package com.jesse.metadata.utils;

import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.DeserializationFeature;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.SerializationFeature;
import com.fasterxml.jackson.datatype.jsr310.JavaTimeModule;

/**
 * @author jesse
 * @date 2021/9/20
 */
public class JsonUtil {

    private static final ObjectMapper objectMapper = new ObjectMapper()
            .registerModule(new JavaTimeModule())
            .disable(SerializationFeature.WRITE_DATE_TIMESTAMPS_AS_NANOSECONDS)
            .configure(SerializationFeature.WRITE_DATES_AS_TIMESTAMPS, true)
            .configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES,false);

    public static String toJsonStr(Object obj) {
        try {
            return objectMapper.writeValueAsString(obj);
        } catch (JsonProcessingException e) {
            throw new RuntimeException(e);
        }
    }

    public static <T> T readJson(String str, Class<T> clazz) {
        try {
            return objectMapper.readValue(str, clazz);
        } catch (JsonProcessingException e) {
            throw new RuntimeException(e);
        }
    }

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值