java调用Neo4j和ES接口的一些使用笔记

场景：从neo4j中获取数据，更新同步到Es中。
1.从neo4j中获取数据。

org.neo4j.driver.v1.Driver driver = GraphDatabase.driver( "bolt://192.168.2.74:7687",AuthTokens.basic( "neo4j", "Neo4j" ));//配置驱动Session session = driver.session();//建立连接StatementResult result = session.run( "MATCH (a:"+label+") return a.name as name");//获取结果集

2.用delete-by-query方法删除ES中原有数据

//打开client        esAPI.OpenClient2();        TransportClient client=esAPI.get_Client();        //删除ES原有数据        //创建查询条件语句        QueryBuilder queryBuilder1 = QueryBuilders.matchQuery("field", "name");        QueryBuilder queryBuilder2 = QueryBuilders.matchQuery("type", type);          QueryBuilder queryBuilder3 = QueryBuilders.matchQuery("label", label);        QueryBuilder queryBuilder4 = QueryBuilders.typeQuery(_type);        //满足查询条件          BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery();         boolQueryBuilder.must(queryBuilder1);          boolQueryBuilder.must(queryBuilder2);         boolQueryBuilder.must(queryBuilder3);         boolQueryBuilder.must(queryBuilder4);         //执行删除操作        BulkIndexByScrollResponse response=  DeleteByQueryAction.INSTANCE.newRequestBuilder(client).source(_index).refresh(true).filter(boolQueryBuilder).execute().actionGet();        System.out.println(response.getDeleted());//删除条数

值得说明的是，在ES-5.02中支持delete by query，如果ES2.X之前，还需要特意安装delete-by-query插件，而且删除语句和ES-5.02有很大差别。执行删除时，建议用 refresh（true），否则，ES中数据会隔一段时间才会刷新
。
3.将数据批量更新到ES中

      //更新数据到ES        int i=0;        BulkRequestBuilder bulkRequest = client.prepareBulk();        while ( result.hasNext() )        {            i=i+1;            Record record = result.next();//读取Neo4j结果集的数据            String id=UUID.randomUUID().toString();            Map<String, String> ret=new HashMap<>();            ret.put("label", label);            ret.put("field", "name");            ret.put("type", "e");            ret.put("value", record.get("name").asString());            bulkRequest.add(client.prepareIndex(_index, _type).setId(id).setSource(ret));            if(i%100000==0) {//每100000条更新一次                System.out.println(i);                bulkRequest.execute().actionGet();                bulkRequest = client.prepareBulk();//置空            }        }System.out.println(i);        bulkRequest.execute().actionGet();

特别说明：参数_index 代表ES中索引，_type代表ES中type