1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
|
//test comment
START a = node(*)
MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d)
RETURN a.name, m.title, d.name;
START a = node(*)
MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d)
WITH d,m,count(a) as Actors
WHERE Actors > 4
RETURN d.name as Director,m.title as Movie, Actors ORDER BY Actors;
START a=node(*)
MATCH p=(a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d)
return p;
START a = node(*)
MATCH p1=(a)-[:ACTED_IN]->(m), p2=d-[:DIRECTED]->(m)
WHERE m.title="The Matrix"
RETURN p1, p2;
START a = node(*)
MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d)
WHERE a=d
RETURN a.name;
START a = node(*)
MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d)
WHERE a=d
RETURN a.name;
START a=node(*)
MATCH (a)-[:ACTED_IN]->(m)<-[:DIRECTED]-(d)
RETURN a.name, d.name, count(*) as Movies,collect(m.title) as Titles
ORDER BY (Movies) DESC
LIMIT 5;
START keanu=node:node_auto_index(name="Keanu Reeves")
RETURN keanu;
START keanu=node:node_auto_index(name="Keanu Reeves")
MATCH (keanu)-[:ACTED_IN]->(movie)
RETURN movie.title;
START keanu=node:node_auto_index(name="Keanu Reeves")
MATCH (keanu)-[r:ACTED_IN]->(movie)
WHERE "Neo" in r.roles
RETURN DISTINCT movie.title;
START keanu=node:node_auto_index(name="Keanu Reeves")
MATCH (keanu)-[:ACTED_IN]->()<-[:DIRECTED]-(director)
RETURN director.name;
START keanu=node:node_auto_index(name="Keanu Reeves")
MATCH (keanu)-[:ACTED_IN]->(movie)<-[:ACTED_IN]-(n)
WHERE n.born < keanu.born
RETURN DISTINCT n.name, keanu.born ,n.born;
START keanu=node:node_auto_index(name="Keanu Reeves"),
hugo=node:node_auto_index(name="Hugo Weaving")
MATCH (keanu)-[:ACTED_IN]->(movie)
WHERE NOT((hugo)-[:ACTED_IN]->(movie))
RETURN DISTINCT movie.title;
START a = node(*)
MATCH (a)-[:ACTED_IN]->(m)
WITH a,count(m) as Movies
RETURN a.name as Actor, Movies ORDER BY Movies;
START keanu=node:node_auto_index(name="Keanu Reeves"),actor
MATCH past=(keanu)-[:ACTED_IN]->()<-[:ACTED_IN]-(),
actors=(actor)-[:ACTED_IN]->()
WHERE hasnt=actors NOT IN past
RETURN hasnt;
START keanu=node:node_auto_index(name="Keanu Reeves")
MATCH (keanu)-[:ACTED_IN]->()<-[:ACTED_IN]-(c),
(c)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc)
WHERE NOT((keanu)-[:ACTED_IN]->()<-[:ACTED_IN]-(coc))
AND coc > keanu
RETURN coc.name, count(coc)
ORDER BY count(coc) DESC
LIMIT 3;
START kevin=node:node_auto_index(name="Kevin Bacon"),
movie=node:node_auto_index(name="Mystic River")
MATCH (kevin)-[:ACTED_IN]->(movie)
RETURN DISTINCT movie.title;
CREATE (n
{
title:"Mystic River",
released:1993,
tagline:"We bury our sins here, Dave. We wash them clean."
}
) RETURN n;
START movie=node:node_auto_index(title="Mystic River")
SET movie.released = 2003
RETURN movie;
start emil=node:node_auto_index(name="Emil Eifrem") MATCH emil-[r]->(n) DELETE r, emil;
START a=node(*)
MATCH (a)-[:ACTED_IN]->()<-[:ACTED_IN]-(b)
CREATE UNIQUE (a)-[:KNOWS]->(b);
START keanu=node:node_auto_index(name="Keanu Reeves")
MATCH (keanu)-[:KNOWS*2]->(fof)
WHERE keanu <> fof
RETURN distinct fof.name;
START charlize=node:node_auto_index(name="Charlize Theron"),
bacon=node:node_auto_index(name="Kevin Bacon")
MATCH p=shortestPath((charlize)-[:KNOWS*]->(bacon))
RETURN extract(n in nodes(p) | n.name)[1];
START actors=node:
MATCH (alice)-[:`REALLY LIKES`]->(bob)
MATCH (alice)-[:`REALLY ``LIKES```]->(bob)
myFancyIdentifier.`(weird property name)`
"string\t\n\b\f\\\''\""
|
