Neo4J REST API cypher- query Using MERGE Construct

Question

I am trying to create nodes and relationships between them. Below is the code which I have used.

String cypherUri = "http://localhost:7474/" + "cypher";        
JSONObject Neo4jQueryJSON = new JSONObject();
HashMap<String, String> params = new HashMap<String, String>();

params.put("value","H090");
params.put("color","red"); 

String query = "CREATE (n:color {color: {name} }), (m:value {value: {name} }), (n)-[:hasVALUE]->(m)";
Neo4jQueryJSON.put("query", query);
Neo4jQueryJSON.put("params", params);                   


WebResource resource = Client.create().resource( cypherUri );
ClientResponse response =
                   resource.accept(MediaType.APPLICATION_JSON_TYPE)
                           .type(MediaType.APPLICATION_JSON_TYPE)                               
                           .header("X-Stream","true")
                           .post(ClientResponse.class, Neo4jQueryJSON.toJSONString());  
           String result = response.getEntity(String.class);               
           response.close();
           int status = response.getStatus();      

           System.out.printf("POST %s %nstatus code [%d] %nresult %s%n", Neo4jQueryJSON, status, result);
 }

I am trying to check is the node exists, if-not, only then create one aswell as the relationship between them.

String query = "CREATE (n:color {color: {name} }), (m:value {value: {name} }), (n)-[:hasVALUE]->(m)";

Community · Accepted Answer · 2017-05-23 11:46:21Z

1

It was pretty simple, I found the solution based on this SO answer: Check whether a node exists, if not create

   String query = "MERGE (n:color {color: {name} })MERGE (m:value {value: {name} }) MERGE (n)-[:hasVALUE]->(m)";

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Mar 20, 2017 at 14:27

Betafish

1,2703 gold badges22 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Neo4J REST API cypher- query Using MERGE Construct

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related