Neo4j Data Modeling Training

gistfile1.txt

MERGE (pressly:Person{name:'pressly'})
MERGE (yoom:Person{name:'yoom'})
MERGE (paul:Person{name:'paul'})
MERGE (company:Company{name:'acme'})
MERGE (neo4j:Skill{name:'Neo4j'})
MERGE (rest:Skill{name:'REST'})
MERGE (java:Skill{name:'JAVA'})
MERGE (cpp:Skill{name:'C++'})
MERGE (gremlin:Skill{name:'Gremlin'})
MERGE (ruby:Skill{name:'Ruby'})
MERGE (sql:Skill{name:'SQL'})
MERGE (pressly)-[:HAS_SKILL{level:1}]->(neo4j)
MERGE (pressly)-[:HAS_SKILL{level:1}]->(java)
MERGE (pressly)-[:HAS_SKILL{level:1}]->(cpp)
MERGE (pressly)-[:HAS_SKILL{level:1}]->(sql)
MERGE (pressly)-[:HAS_SKILL{level:1}]->(ruby)
MERGE (yoom)-[:HAS_SKILL{level:1}]->(neo4j)
MERGE (yoom)-[:HAS_SKILL{level:1}]->(java)
MERGE (yoom)-[:HAS_SKILL{level:1}]->(cpp)
MERGE (yoom)-[:HAS_SKILL{level:1}]->(sql)
MERGE (yoom)-[:HAS_SKILL{level:1}]->(gremlin)
MERGE (paul)-[:HAS_SKILL{level:1}]->(neo4j)
MERGE (paul)-[:HAS_SKILL{level:1}]->(java)
MERGE (paul)-[:HAS_SKILL{level:1}]->(cpp)
MERGE (paul)-[:HAS_SKILL{level:1}]->(sql)
MERGE (paul)-[:HAS_SKILL{level:1}]->(rest)
MERGE (pressly)-[:WORKS_FOR]->(company)
MERGE (yoom)-[:WORKS_FOR]->(company)
MERGE (paul)-[:WORKS_FOR]->(company)

MERGE (rob:Person{name:'Rob'})
MERGE (josh:Person{name:'Josh'})
MERGE (steve:Person{name:'Steve'})
MERGE (roger:Person{name:'Roger'})
MERGE (groovy:Skill{name:'Groovy'})
MERGE (csharp:Skill{name:'C#'})
MERGE (gradle:Skill{name:'Gradle'})
MERGE (cypher:Skill{name:'Cypher'})

MERGE (rob)-[:HAS_SKILL{level:3}]->(rest)
MERGE (rob)-[:HAS_SKILL{level:3}]->(java)
MERGE (rob)-[:HAS_SKILL{level:3}]->(groovy)
MERGE (rob)-[:HAS_SKILL{level:1}]->(gradle)
MERGE (rob)-[:HAS_SKILL{level:1}]->(cypher)
MERGE (rob)-[:HAS_SKILL{level:3}]->(sql)

MERGE (steve)-[:HAS_SKILL{level:3}]->(rest)
MERGE (steve)-[:HAS_SKILL{level:3}]->(java)
MERGE (steve)-[:HAS_SKILL{level:2}]->(groovy)
MERGE (steve)-[:HAS_SKILL{level:3}]->(gradle)
MERGE (steve)-[:HAS_SKILL{level:1}]->(cypher)
MERGE (steve)-[:HAS_SKILL{level:1}]->(sql)

MERGE (roger)-[:HAS_SKILL{level:3}]->(rest)
MERGE (roger)-[:HAS_SKILL{level:3}]->(java)
MERGE (roger)-[:HAS_SKILL{level:2}]->(groovy)
MERGE (roger)-[:HAS_SKILL{level:2}]->(gradle)
MERGE (roger)-[:HAS_SKILL{level:1}]->(cypher)
MERGE (roger)-[:HAS_SKILL{level:3}]->(sql)
MERGE (josh)-[:HAS_SKILL{level:2}]->(cypher)
MERGE (josh)-[:HAS_SKILL{level:3}]->(sql)
MERGE (josh)-[:HAS_SKILL{level:3}]->(csharp)

MERGE (Matt:Person {name:"Matt"})
MERGE (Pete:Person{name:"Pete"})
MERGE (Mark:Person{name:"Mark"})
MERGE (Marshall:Person{name:"Marshall"})
MERGE (JS:Skill{name:"JS"})
MERGE (AJAX:Skill{name:"AJAX"})
MERGE (Unix:Skill{name:"Unix"})
MERGE (Python:Skill{name:"Python"})
MERGE (Security:Skill{name:"Security"})
MERGE (Linux:Skill{name:"Linux"})
MERGE (Matt)-[:WORKS_FOR]->(company)
MERGE (Pete)-[:WORKS_FOR]->(company)
MERGE (Mark)-[:WORKS_FOR]->(company)
MERGE (Marshall)-[:WORKS_FOR]->(company)
MERGE (Matt)-[:HAS_SKILL{level:1}]->(java)
MERGE (Matt)-[:HAS_SKILL{level:1}]->(Unix)
MERGE (Matt)-[:HAS_SKILL{level:1}]->(cpp)
MERGE (Pete)-[:HAS_SKILL{level:4}]->(java)
MERGE (Pete)-[:HAS_SKILL{level:7}]->(AJAX)
MERGE (Pete)-[:HAS_SKILL{level:8}]->(JS)
MERGE (Marshall)-[:HAS_SKILL{level:5}]->(Unix)
MERGE (Marshall)-[:HAS_SKILL{level:3}]->(Python)
MERGE (Marshall)-[:HAS_SKILL{level:7}]->(Security)
MERGE (Mark)-[:HAS_SKILL{level:5}]->(Python)
MERGE (Mark)-[:HAS_SKILL{level:4}]->(Linux)