Skip to content

Instantly share code, notes, and snippets.

@suellenstringer-hye
Forked from stardustnrust/lifeyousave
Last active August 29, 2015 14:07
Show Gist options
  • Save suellenstringer-hye/3775cf12f473866affcf to your computer and use it in GitHub Desktop.
Save suellenstringer-hye/3775cf12f473866affcf to your computer and use it in GitHub Desktop.
= The Life You Save May Be Your Own
== Modeling the Graph
//graph
=== OUR DATASET
[source, cypher]
----
CREATE
//People
(shiflet:Person{name:'Tom T. Shiflet'}),
(crater:Person{name:'Lucynell Crater'}),
(crater2:Person{name:'Lucynell Crater'}),
//Second People
(roy:Person2{name:'Uncle Roy and his Red Creek Wranglers'}),
(duchessor:Person2{name:'Duchesser Windsor'}),
(oldmother:Person2{name:'My Old Mother'}),
(boy:Person2{name:'Boy Behind the Counter'}),
(boy2:Person2{name:'Boy on Road'}),
(husband:Person2{name:'Dead Husband'}),
//Alias
(angel: Alias {name:'Angel of Gawd'}),
(sugarbaby:Alias {name:'Sugarbaby'}),
(baby:Alias {name:'Baby Girl'}),
(aaron:Alias {name:'Aaron Sparks'}),
(george:Alias {name:'George Speeds'}),
(thompson:Alias {name:'Thompson Bright'}),
//Family Ties
(mother:Family {name:'Mother'}),
(daughter:Family{name:'Daughter'}),
(son:Family{name:'Son'}),
(husband2:Family{name:'Husband'}),
//Professions
(singer:Profession{name:'Gospel Singer'}),
(foreman:Profession{name:'Foreman on the Railroad'}),
(undertaker:Profession{name:'Assistant in an Undertaking Parlor'}),
(carpenter:Profession{name:'Carpenter'}),
(radio:Profession{name:'On the Radio'}),
(illiterate:Profession{name:'Illiterate'}),
//Locations
(atlanta:Location{name:'Atlanta'}),
(tarwater:Location{name:'Tarwater, Tennessee'}),
(singleberry:Location{name:'Singleberry, Georgia'}),
(lucy:Location{name:'Lucy, Alabama'}),
(toolafalls:Location{name:'Toolafalls, Missippi'}),
(mobile:Location{name:'Mobile'}),
(hotspot:Location{name:'Hot Spot'}),
//Words
(hat:Word{name:'Hat'}),
(heart:Word{name:'Heart'}),
(chicken:Word{name:'Chicken'}),
(matches:Word{name:'Matches'}),
(hitchhiker:Word{name:'Hitchhiker'}),
(cloud:Word{name:'Cloud'}),
(arm:Word{name:'Arm Service'}),
(smoke:Word{name:'Smoke'}),
(moon:Word{name:'Moon'}),
(car:Word{name:'Car'}),
(dress:Word{name:'Dress'}),
(hair:Word{name:'Hair'}),
(eyes:Word{name:'Eyes'}),
(sky:Word{name:'Sky'}),
//Colors
(gray:Color{name:'gray'}),
(yellow:Color{name:'yellow'}),
(pinkgold:Color{name:'pinkgold'}),
(white:Color{name:'white'}),
(blue:Color{name:'blue'}),
//Relationships
(shiflet)-[:KNEW]->(crater),
(shiflet)-[:KNEW]->(crater2),
(shiflet)-[:KNEW]->(boy2),
(shiflet)-[:KNEW]->(oldmother),
(shiflet)-[:KNEW]->(boy),
(shiflet)-[:WAS]->(singer),
(shiflet)-[:WAS]->(foreman),
(shiflet)-[:WAS]->(undertaker),
(shiflet)-[:WAS]->(carpenter),
(shiflet)-[:WAS]->(radio),
(shiflet)-[:WAS]->(illiterate),
(duchessor)-[:IS]->(illiterate),
(arm)-[:IS]->(illiterate),
(shiflet)-[:AKA]->(aaron),
(shiflet)-[:AKA]->(george),
(shiflet)-[:AKA]->(thompson),
(shiflet)-[:WAS_FROM]->(tarwater),
(shiflet)-[:WENT_TO]->(hotspot),
(shiflet)-[:WAS_GOING_TO]->(mobile),
(aaron)-[:AKA]->(george),
(george)-[:AKA]->(thompson),
(george)-[:WAS_FROM]->(lucy),
(aaron)-[:WAS_FROM]->(singleberry),
(thompson)-[:WAS_FROM]->(toolafalls),
(crater2)-[:WENT_TO]->(hotspot),
(crater2)-[:KNEW]->(boy),
(crater2)-[:AKA]->(angel),
(crater2)-[:AKA]->(sugarbaby),
(crater2)-[:AKA]->(baby),
(crater2)-[:WAS]->(hitchhiker),
(crater2)-[:WORE]->(dress),
(crater2)-[:HAD]->(hair),
(crater2)-[:HAD]->(eyes),
(boy2)-[:WAS]->(hitchhiker),
(oldmother)-[:WAS]->(angel),
(oldmother)-[:WAS]->(mother),
(oldmother)-[:WAS_MOTHER_OF]->(shiflet),
(shiflet)-[:WAS_SON_OF]->(oldmother),
(crater)-[:WAS]->(mother),
(crater)-[:WAS_MOTHER_OF]->(crater2),
(crater2)-[:WAS_DAUGHTER_OF]->(crater),
(crater2)-[:WAS]->(daughter),
(boy2)-[:WAS]->(son),
(shiflet)-[:WAS]->(son),
(husband)-[:WAS_MARRIED_TO]->(crater),
(husband2)-[:WAS_MARRIED_TO]->(crater),
(crater)-[:WORE]->(hat),
(boy2)-[:WORE]->(hat),
(hat)-[:WAS]->(gray),
(smoke)-[:WAS]->(gray),
(cloud)-[:WAS]->(gray),
(shiflet)-[:BLEW]->(gray),
(moon)-[:WAS]->(yellow),
(car)-[:WAS]->(yellow),
(dress)-[:WAS]->(white),
(dress)-[:WAS]->(blue),
(hair)-[:WAS]->(pinkgold),
(sky)-[:WAS]->(blue),
(eyes)-[:WERE]->(blue),
(aaron)-[:HAS]->(matches),
(chicken)-[:IS_ASSOCIATED_WITH]->(heart),
(chicken)-[:IS_ASSOCIATED_WITH]->(crater2),
(heart)-[:IS_IN]->(atlanta),
(roy)-[:WAS_ON]->(radio),
(boy)-[:WORKED_AT]->(hotspot)
----
=== Who are the main characters?
[source, cypher]
----
MATCH (a:Person)
RETURN a
----
//graph_result
=== Who are all the characters?
[source, cypher]
----
MATCH (a:Person),(b:Person2)
RETURN a,b
----
//graph_result
=== Who went to the Hot Spot?
[source, cypher]
----
MATCH (a)-[r]-(hotspot:Location{name:'Hot Spot'})
RETURN a,r,hotspot
----
//graph_result
=== What is blue?
[source, cypher]
----
MATCH (a)-[r]-(blue:Color{name:'blue'})
RETURN a,r,blue
----
//graph_result
=== What is related to blue?
[source, cypher]
----
MATCH (bluething)-[r]-(blue:Color{name:'blue'})
WITH bluething
MATCH (bluething)-[r]-(anything)
RETURN bluething,r,anything
----
//graph_result
= More themes that could be graphed
Light, Sun, Blue, White, Devil, Christ, God, Bright, Tools, Fire, Moon, Yellow, Sugar, Metal, Birds, Coffins, Car, Spirit, Speed, Mobility, Children, Body, Spirit, Law, Money, Blood, Berries, Tears, Children, Parents, Delusion,
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment