Skip to content

Instantly share code, notes, and snippets.

@EdWarga
Forked from stardustnrust/lifeyousave
Last active August 29, 2015 14:07
Show Gist options
  • Save EdWarga/36617cd041edaf089482 to your computer and use it in GitHub Desktop.
Save EdWarga/36617cd041edaf089482 to your computer and use it in GitHub Desktop.
= The Life You Save May Be Your Own
== Modeling the Graph
//table
//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
(greyhat:Word{name:'Grey Hat'}),
(grey:Word{name:'Grey'}),
(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'}),
//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),
(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),
(crater)-[:WORE]->(greyhat),
(husband)-[:WAS_MARRIED_TO]->(crater),
(husband2)-[:WAS_MARRIED_TO]->(crater),
(boy2)-[:WORE]->(greyhat),
(greyhat)-[:WAS]->(grey),
(shiflet)-[:WAS]->(grey),
(cloud)-[:WAS]->(grey),
(shiflet)-[:HAS]->(matches),
(aaron)-[:HAS]->(matches),
(chicken)-[:IS_ASSOCIATED_WITH]->(heart),
(chicken)-[:IS_ASSOCIATED_WITH]->(crater2),
(heart)-[:IS_IN]->(atlanta),
(roy)-[:WAS_ON]->(radio)
----
[source, cypher]
----
match (a) -[r] - (b {name:'Tom T. Shiflet'})
return a
----
= 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