Import orgs

import.cypher

MATCH n
OPTIONAL MATCH n-[r]->()
DELETE n,r;

LOAD CSV FROM 'https://dl.dropboxusercontent.com/u/67572426/persons.csv' AS line
MERGE (p:Person:Entity {name: line[0]});

LOAD CSV FROM 'https://dl.dropboxusercontent.com/u/67572426/orgs.csv' AS line
MERGE (o:Org:Dept:Entity {name: line[0]});

LOAD CSV FROM 'https://dl.dropboxusercontent.com/u/67572426/depts.csv' AS line
MATCH (d1:Dept {name: line[1]})-[:IS_PART_OF*0..]->(o:Org {name: line[2]})
CREATE (d0:Dept {name: line[0]})-[:IS_PART_OF]->(d1)
MERGE (p:Person:Entity {name: line[3]})
CREATE (p)<-[:LEAD_BY]-(d0);

LOAD CSV FROM 'https://dl.dropboxusercontent.com/u/67572426/depts2.csv' AS line
MATCH (d1:Dept {name: line[1]})-[:IS_PART_OF*0..]->(o:Org {name: line[2]})
CREATE (d0:Dept {name: line[0]})-[:IS_PART_OF]->(d1)
MERGE (p:Person:Entity {name: line[3]})
CREATE (p)<-[:LEAD_BY]-(d0);

LOAD CSV FROM 'https://dl.dropboxusercontent.com/u/67572426/depts-member.csv' AS line
MATCH (d:Dept {name: line[1]})-[:IS_PART_OF*0..]->(o:Org {name: line[2]}), (p:Person {name: line[0]})
CREATE p-[:WORKS_AT {hoursPerWeek: TOINT(line[3])}]->d;

UNWIND [{city: "Berlin", country: "Germany"}, {city: "Cologne", country: "Germany"}, {city: "Munich", country: "Germany"}, {city: "Bordeaux", country: "France"}, {city: "Vienna", country: "Austria"}, {city: "Paris", country: "France"}] as office
MATCH (o:Org {name: "GraphIT"})
MERGE (city:City {name: office.city})
MERGE (country:Country {name: office.country})
CREATE UNIQUE city-[:IS_IN]->country
CREATE (o)-[:HAS_SITE]->(:Office)-[:IS_LOCATED_IN]->(city);

UNWIND [{city: "Rome", country: "Italy"}, {city: "Paris", country: "France"}] as office
MATCH (o:Org {name: "Graphora"})
MERGE (city:City {name: office.city})
MERGE (country:Country {name: office.country})
CREATE UNIQUE city-[:IS_IN]->country
CREATE (o)-[:HAS_SITE]->(:Office)-[:IS_LOCATED_IN]->(city);

UNWIND [{city: "Milano", country: "Italy"}, {city: "Cologne", country: "Germany"}, {city: "Paris", country: "France"}] as office
MATCH (o:Org {name: "Graphisto"})
MERGE (city:City {name: office.city})
MERGE (country:Country {name: office.country})
CREATE UNIQUE city-[:IS_IN]->country
CREATE (o)-[:HAS_SITE]->(:Office)-[:IS_LOCATED_IN]->(city);

UNWIND [{city: "Madrid", country: "Spain"}] as office
MATCH (o:Org {name: "MyGraph"})
MERGE (city:City {name: office.city})
MERGE (country:Country {name: office.country})
CREATE UNIQUE city-[:IS_IN]->country
CREATE (o)-[:HAS_SITE]->(:Office)-[:IS_LOCATED_IN]->(city);

UNWIND [{city: "Berlin", country: "Germany"}] as office
MATCH (o:Org {name: "GraphUniversity"})
MERGE (city:City {name: office.city})
MERGE (country:Country {name: office.country})
CREATE UNIQUE city-[:IS_IN]->country
CREATE (o)-[:HAS_SITE]->(:Office)-[:IS_LOCATED_IN]->(city);

MATCH (d:Dept {name: "IT-Department"})-[:IS_PART_OF*0..]->(o:Org {name: "GraphIT"}), (p:Person {name: "Charlene"})
CREATE (pr:Project {name: "The next big thing"})-[:BELONGS_TO]->(d)
CREATE (pr)-[:HAS_MEMBER {role: "product owner"}]->(p);

MATCH (d:Dept {name: "Mobile Apps"})-[:IS_PART_OF*0..]->(o:Org {name: "GraphIT"}), (p:Person {name: "Evan"})
MERGE (pr:Project {name: "Project X"})-[:BELONGS_TO]->(d)
CREATE (pr)-[:HAS_MEMBER {role: "product owner"}]->(p);
MATCH (d:Dept {name: "Mobile Apps"})-[:IS_PART_OF*0..]->(o:Org {name: "GraphIT"}), (p:Person {name: "Elliot"})
MERGE (pr:Project {name: "Project X"})-[:BELONGS_TO]->(d)
CREATE (pr)-[:HAS_MEMBER {role: "developer"}]->(p);
MATCH (d:Dept {name: "Mobile Apps"})-[:IS_PART_OF*0..]->(o:Org {name: "GraphIT"}), (p:Person {name: "Emma"})
MERGE (pr:Project {name: "Project X"})-[:BELONGS_TO]->(d)
CREATE (pr)-[:HAS_MEMBER {role: "scrum master"}]->(p);
MATCH (d:Dept {name: "Mobile Apps"})-[:IS_PART_OF*0..]->(o:Org {name: "GraphIT"}), (p:Person {name: "Evan"})
MERGE (pr:Project {name: "Project Y"})-[:BELONGS_TO]->(d)
CREATE (pr)-[:HAS_MEMBER {role: "product owner"}]->(p);
MATCH (d:Dept {name: "Mobile Apps"})-[:IS_PART_OF*0..]->(o:Org {name: "GraphIT"}), (p:Person {name: "Elliot"})
MERGE (pr:Project {name: "Project Y"})-[:BELONGS_TO]->(d)
CREATE (pr)-[:HAS_MEMBER {role: "scrum master"}]->(p);

MATCH (d:Dept {name: "Backend"})-[:IS_PART_OF*0..]->(o:Org {name: "Graphora"}), (p:Person {name: "Anna"})
MERGE (pr:Project {name: "Project X"})-[:BELONGS_TO]->(d)
CREATE (pr)-[:HAS_MEMBER {role: "product owner"}]->(p);

MATCH (d:Dept {name: "Backend"})-[:IS_PART_OF*0..]->(o:Org {name: "Graphora"}), (p:Person {name: "Ashton"})
MERGE (pr:Project {name: "Project X"})-[:BELONGS_TO]->(d)
CREATE (pr)-[:HAS_MEMBER {role: "developer"}]->(p);