%% change <login>  to your login name

neo4j-shell --path /home/<login>/neo4j

MATCH (n)
DETACH DELETE n;

CREATE (n);

CREATE (a {name : 'Andres'}) RETURN a;

CREATE (n  {name : 'Andres', title : 'Developer'}) return n;

MATCH (n) RETURN n;

MATCH  (a {name:"Andres"})
CREATE (a)-[r:FRIEND]->(b {name:"Jana"} )
RETURN r;

MATCH (n) RETURN n;

MATCH (n)-[r]-() RETURN n, r;

MATCH (a {name:"Andres"}) 
MATCH (b {name:"Jana"})
CREATE (a)-[r:RELTYPE {name : a.name + '<->' + b.name }]->(b)
RETURN r;

MATCH (andres {name:'Andres'})
CREATE p = (andres)-[:WORKS_AT]->(neo)<-[:WORKS_AT]-(michael {name:'Michael'})
RETURN p;

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

MATCH (n)
DETACH DELETE n;


CREATE
  (m1:MOVIE { id: "vratnelahve", title: "Vratne lahve", year: 2006 }),
  (m2:MOVIE { id: "samotari", title: "Samotari", year: 2000 }),
  (m3:MOVIE { id: "medvidek", title: "Medvidek", year: 2007 }),
  (m4:MOVIE { id: "stesti", title: "Stesti", year: 2005 }),
  (a1:ACTOR { id: "trojan", name: "Ivan Trojan", year: 1964 }),
  (a2:ACTOR { id: "machacek", name: "Jiri Machacek", year: 1966 }),
  (a3:ACTOR { id: "schneiderova", name: "Jitka Schneiderova", year: 1973 }),
  (a4:ACTOR { id: "sverak", name: "Zdenek Sverak", year: 1936 }),
  (m1)-[c1:PLAY { role: "Robert Landa" }]->(a2),
  (m1)-[c2:PLAY { role: "Josef Tkaloun" }]->(a4),
  (m2)-[c3:PLAY { role: "Ondrej" }]->(a1),
  (m2)-[c4:PLAY { role: "Jakub" }]->(a2),
  (m2)-[c5:PLAY { role: "Hanka" }]->(a3),
  (m3)-[c6:PLAY { role: "Ivan" }]->(a1),
  (m3)-[c7:PLAY { role: "Jirka", award: "Czech Lion" }]->(a2),
  (a1)-[f1:KNOW]->(a2),
  (a1)-[f2:KNOW]->(a3),
  (a2)-[f3:KNOW]->(a3),
  (a4)-[f4:KNOW]->(a2);
  
MATCH (m:MOVIE)
RETURN m.title;  
                             
MATCH (m:MOVIE {id: "medvidek"})
RETURN m;
             
MATCH (a:ACTOR)
  WHERE a.year >= 1965
RETURN a.name, a.year 
  ORDER BY a.year DESC, a.name ASC;

MATCH (:ACTOR {name: "Jiri Machacek"})<-[:PLAY]-(n:MOVIE)
RETURN n.title;
    
MATCH (m:MOVIE)-[:PLAY]->(:ACTOR)
RETURN DISTINCT m;
                     
MATCH
  (s:ACTOR {name: "Ivan Trojan"})
    <-[:PLAY]-(m:MOVIE)-[:PLAY]->
  (a:ACTOR)
RETURN DISTINCT a;

MATCH (s:ACTOR {name: "Ivan Trojan"})-[:KNOW *]-(a:ACTOR)
  WHERE s <> a
RETURN DISTINCT a.name;