create_address.adoc

Create unique address patterns

For an explaination of the problem, see http://stackoverflow.com/questions/18740104/neo4jclient-create-unique-results-in-multiple-duplicate-nodes

CREATE CONSTRAINT ON (city:City) ASSERT city.name IS UNIQUE

CREATE CONSTRAINT ON (p:Person) ASSERT p.name IS UNIQUE

Now, add two addresses in Berlin for the same person by merging the nodes.

MERGE (berlin:City{name:'Berlin'})
MERGE (joe:City{name:'Joe'})
CREATE joe-[:LIVES]->({name:'Address1'})-[:IN]->berlin
CREATE joe-[:LIVES]->({name:'Address2'})-[:IN]->berlin