Cypher

• cypher relationships

A pattern matching query language made for graphs

• Declartive
• Expressive
• Pattern Matching

MATCH (b:Brand) WHERE NOT(b) - [] -> () RETURN b

CREATE (j:Person {name: 'Jennifer'}) RETURN j

MATCH (p:Person {name: 'Jennifer'})
SET p.birthdate = date('1980-01-01')

CREATE (j:Person {name: 'Jennifer'})-[rel:IS_FRIENDS_WITH]->(m:Person {name: 'Mark'})

MATCH (b:Brand {name:"Chanel"}) RETURN b

MATCH (p:Person {name: 'Jennifer'}) RETURN p

CREATE INDEX ON :Product(productName);
CREATE INDEX ON :Product(unitPrice);

MATCH (p:Product)
WHERE p.productName IN ['Chocolade','Chai']
RETURN p.productName, p.unitPrice;

CREATE CONSTRAINT ON (n:<LabelName>) ASSERT n.<propertyKey> IS UNIQUE

multiple column

CREATE CONSTRAINT ON (n:Person) ASSERT (n.firstname, n.surname) IS NODE KEY

제약 조회

SHOW CONSTRAINTS

MATCH (n:Person {name: 'UNKNOWN'})
DELETE n

MATCH (n)
DETACH DELETE n

MATCH (n {name: 'Andy'})
DETACH DELETE n

• Cypher Query
• Extend Cypher
• Graph Model