Skip to content

Instantly share code, notes, and snippets.

@Pimsepinnen
Last active July 26, 2016 16:47
Show Gist options
  • Save Pimsepinnen/8007635 to your computer and use it in GitHub Desktop.
Save Pimsepinnen/8007635 to your computer and use it in GitHub Desktop.
People, books and cities - recommend your book
= People, books and cities
=== “Those who find ugly meanings in beautiful things are corrupt without being charming. This is a fault. Those who find beautiful meanings in beautiful things are the cultivated. For these there is hope. They are the elect to whom beautiful things mean only Beauty. There is no such thing as a moral or an immoral book. Books are well written, or badly written. That is all.”
― Oscar Wilde, The Picture of Dorian Gray
image::http://i.imgur.com/425PvXE.jpg[]
== Modeling the Graph
Let's take a look at the domain model:
image::http://i.imgur.com/vKO4V8s.png?1[]
=== OUR DATASET
[source, cypher]
----
CREATE
//People
(jane:Person{name:'Jane'}),
(mike:Person{name:'Mike'}),
(steve:Person{name:'Steve'}),
(lisa:Person{name:'Lisa'}),
(stella:Person{name:'Stella'}),
(jim:Person{name:'Jim'}),
(pernilla:Person{name:'Pernilla'}),
(kim:Person{name:'Kim'}),
//Books
(pride_and_prejudice:Book:Classic {title:'Pride and Prejudice'}),
(_1984:Book:Fantasy {title:'1984'}),
(emma:Book:Classic {title:'Emma'}),
(sofies_world:Book:Philosophy {title:'Sofies World'}),
(dracula:Book:Horror {title:'Dracula'}),
(of_mice_and_men:Book:Classic {title:'Of mice and men'}),
(les_miserable:Book:Classic {title:'Les Miserable'}),
(life_of_pi:Book:Animee {title:'Life of Pi'}),
//Cities
(malmo:City{name:'Malmo'}),
(stockholm:City{name:'Stockholm'}),
(san_francisco:City{name:'San Francisco'}),
(london:City{name:'London'}),
(paris:City{name:'Paris'}),
//Read
(pernilla)-[:READ]->(pride_and_prejudice),
(pernilla)-[:READ]->(dracula),
(pernilla)-[:READ]->(les_miserable),
(pernilla)-[:READ]->(of_mice_and_men),
(pernilla)-[:READ]->(sofies_world),
(pernilla)-[:READ]->(emma),
(pernilla)-[:READ]->(_1984),
(pernilla)-[:READ]->(life_of_pi),
(lisa)-[:READ]->(pride_and_prejudice),
(lisa)-[:READ]->(sofies_world),
(lisa)-[:READ]->(dracula),
(mike)-[:READ]->(dracula),
(kim)-[:READ]->(emma),
(mike)-[:READ]->(emma),
(lisa)-[:READ]->(les_miserable),
(steve)-[:READ]->(of_mice_and_men),
(jim)-[:READ]->(of_mice_and_men),
(kim)-[:READ]->(life_of_pi),
(mike)-[:READ]->(sofies_world),
(stella)-[:READ]->(dracula),
(stella)-[:READ]->(sofies_world),
(jim)-[:READ]->(emma),
(jim)-[:READ]->(les_miserable),
(jim)-[:READ]->(_1984),
(stella)-[:READ]->(_1984),
(jim)-[:READ]->(life_of_pi),
//LIVES_IN
(lisa)-[:LIVES_IN]->(paris),
(mike)-[:LIVES_IN]->(stockholm),
(stella)-[:LIVES_IN]->(san_francisco),
(jane)-[:LIVES_IN]->(malmo),
(jim)-[:LIVES_IN]->(london),
//RELATIONSHIPS
(jim)-[:KNOW]->(jane),
(jim)<-[:KNOW]-(jane),
(stella)-[:FRIEND_WITH]->(jane),
(stella)<-[:FRIEND_WITH]-(jane),
(stella)<-[:FATHER_OF]-(steve),
(mike)<-[:MARRIED_TO]-(steve),
(mike)-[:MARRIED_TO]->(steve),
(mike)<-[:SISTER_TO]-(lisa)
RETURN london as node
----
//table
//graph
=== Which person had read which book?
[source, cypher]
----
MATCH (person)-[:READ]->(book)
RETURN person.name, book.title;
----
//table
//graph
=== Which books have Jim read?
[source, cypher]
----
MATCH (jim:Person)-[:READ]->(book:Book)
WHERE jim.name="Jim"
RETURN book.title;
----
//table
//graph
=== Which books has Jim and Stella read?
[source, cypher]
----
MATCH (jim:Person)-[:READ]->(book),
(stella:Person)-[:READ]->(book)
WHERE jim.name="Jim" AND
stella.name="Stella"
RETURN DISTINCT book.title;
----
//table
//graph
=== Who is the reader in our graph?
[source, cypher]
----
MATCH (person:Person)-[:READ]->()
RETURN person.name, count(*) AS count
ORDER BY count DESC
LIMIT 5;
----
//table
//graph
=== Who read the same book as Jim?
[source, cypher]
----
MATCH (jim:Person)-[:READ]->(book)<-[:READ]-(fof)
WHERE jim.name="Jim"
RETURN fof.name, collect(book.title);
----
//table
//graph
== “If I'm honest I have to tell you I still read fairy-tales and I like them best of all." - Audrey Hepburn
image::http://i.imgur.com/TJCNW0b.jpg?1[]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment