The Game of Thrones Graph

GoT.sql

start westeros=node(0)

set westeros.name = "Westeros"

create targaryen={house:"Targaryen"},
stark={house:"Stark"},
lannister={house:"Lannister"},
baratheon={house:"Baratheon"},
tully={house:"Tully"}

foreach (house in [stark,lannister,baratheon,targaryen,tully] : 
create house-[:HOUSE]->westeros)


create 
danaerys={name:"Danaerys"},
danaerys-[:OF_HOUSE]->targaryen,
drogo={name:"Khal Drogo"},
danaerys-[:MARRIED_TO]->drogo,
tywin={name:"Tywin"},
tywin-[:OF_HOUSE]->lannister,
steffon={name:"Steffon"},
steffon-[:OF_HOUSE]->baratheon,
rickard={name:"Rickard"},
rickard-[:OF_HOUSE]->stark,
ned={name:"Eddard"},
ned-[:CHILD_OF]->rickard,
catelyn={name:"Catelyn"},
catelyn-[:MARRIED_TO]->ned,
catelyn-[:OF_HOUSE]->tully,
jon={name:"Jon"},
jon-[:CHILD_OF]->ned

foreach (child in ["Robb", "Bran","Arya","Sansa","Rickon"] : 
   
CREATE UNIQUE ned<-[:CHILD_OF]-({name:child})-[:CHILD_OF]->catelyn
)

foreach (child in ["Cersei", "Jamie","Tyrion"] : 
   
CREATE UNIQUE tywin<-[:CHILD_OF]-({name:child})
)

foreach (brother in ["Robert", "Renly","Stannis"] : 
   
CREATE UNIQUE steffon<-[:CHILD_OF]-({name:brother})
)

foreach (child in ["Joffrey", "Myrcella","Tommen"] : 
   
CREATE UNIQUE tywin<-[:CHILD_OF]-(jamie {name:"Jamie"})<-[:CHILD_OF]-({name:child})-[:CHILD_OF]->(cersei {name:"Cersei"})-[:CHILD_OF]->tywin
)


CREATE UNIQUE steffon<-[:CHILD_OF]-(robert {name:"Robert"})<-[:MARRIED_TO]-(cersei {name:"Cersei"})-[:CHILD_OF]->tywin

CREATE UNIQUE ned<-[:CHILD_OF]-(sansa {name:"Sansa"})-[:PROMISED_TO]->(joffrey {name:"Joffrey"})-[:CHILD_OF]->cersei

CREATE UNIQUE ned<-[:CHILD_OF]-(sansa)-[:MARRIED_TO]->(tyrion {name:"Tyrion"})-[:CHILD_OF]->steffon