MovieLens database insert

insert.txt

LOAD CSV WITH HEADERS FROM 'file:///movies.clean.csv' as l
CREATE (m:Movie{movieId:toInteger(l.movieId), tmdbId:l.tmdbId, imdbId:l.imdbId, title:l.title, year:date(l.year)})

CREATE INDEX ON :Movie(movieId)

LOAD CSV WITH HEADERS FROM 'file:///users.csv' as l
CREATE (u:User{userId:toInteger(l.userId)})

CREATE INDEX ON :User(userId)

LOAD CSV WITH HEADERS FROM 'file:///genres.csv' as l
MERGE (g:Genre{name:l.genre})
WITH g,l.movieId as movieId
MATCH (m:Movie{movieId:toInteger(movieId)})
MERGE (m)-[:IsGenre]->(g)

LOAD CSV WITH HEADERS FROM 'file:///ratings.csv' as l
MATCH (m:Movie{movieId:toInteger(l.movieId)})
MATCH (u:User{userId:toInteger(l.userId)})
CREATE (u)-[:Rates{rating:toFloat(l.rating), time:datetime(l.time)}]->(m)

LOAD CSV WITH HEADERS FROM 'file:///tags.csv' as l
MATCH (m:Movie{movieId:toInteger(l.movieId)})
MATCH (u:User{userId:toInteger(l.userId)})
CREATE (u)-[:Tags{tag:l.tag, time:datetime(l.time)}]->(m)