movie import.cypher;

gistfile1.txt

create index on :Movie(movieId);

create index on :Person(personId);

load csv with headers from 'file:///people.csv' as record
merge (p:Person {personId:record.personId})
set p = record;

load csv with headers from 'file:///movies.csv' as record
merge (m:Movie {movieId:record.movieId})
set m = record;

load csv with headers from 'file:///directors.csv' as record
match (p:Person), (m:Movie)
where p.personId = record.personId
  and m.movieId = record.movieId
merge (p)-[:DIRECTED]->(m);

load csv with headers from 'file:///actors.csv' as record
match (p:Person), (m:Movie)
where p.personId = record.personId
  and m.movieId = record.movieId
merge (p)-[:ACTED_IN {roles:coalesce(record.characters, "")}]->(m);