Description
In this lab, we will query a Neo4j graph database using with Cypher language and Python. Neo4j
is a highly scalable, native graph database purpose-built to leverage not only data but also its relationships. Cypher is a declarative graph query language that allows for expressive and efficient
querying and updating of the graph store.
In [1]: # Use the following to get the neo4j database password from the user
import getpass
print (“Give me your neo4j password:”)
neopass = getpass.getpass()
#print (“You typed:”, neopass)
Give me your neo4j password:
········
In [2]: from neo4j import GraphDatabase
# More information on neo4j python API at:
# http://neo4j.com/docs/api/python-driver/current/
#Connect to the database
uri = “bolt://localhost:7687”
#auth=(“neo4j”, neopass)
driver = GraphDatabase.driver(uri, auth=(“neo4j”, neopass))
#Start new session
session = driver.session()
#Start new transaction
transaction = session.begin_transaction()
1.2.1 Queries
Q1) Find the actor named “Tom Hanks”.
In [ ]: result = transaction.run(“””
MATCH (tom:Actor {name: ‘Tom Hanks’})
RETURN tom
;”””)
for record in result:
print (record)
1
1.2.2 Tasks
Q2) Find the movie with title “Avatar”.
Q3) Find movies released in the 1990s.
Q4) List all Tom Hanks movies.
Q5) Who directed “Avatar”.
Q6) Tom Hanks’ co-actors.
Q7) How people are related to “Avatar”.
Q8) Extend Tom Hanks co-actors, to find co-co-actors who haven’t worked with Tom Hanks.
Q9) Find someone to introduce Tom Hanks to Tom Cruise.
Let’s close the session and the transaction.
In [ ]: transaction.close()
session.close()
2
