def deletePost(message):
result = None
db = conn.getDBConnection()
query = 'MATCH (p:Post) WHERE p.message = "{0}" DELETE p'.format(message)
db.query(query)
return result
def deletePage(name):
result = None
db = conn.getDBConnection()
query = 'MATCH (p:Page) WHERE p.name = "{0}" DELETE p'.format(name)
db.query(query)
return result
def addPost(name, post):
result = None #True/False
db = conn.getDBConnection()
query = 'MATCH (u:User),(p:Post) WHERE u.name = "{0}" AND p.message = "{1}" CREATE (u)-[r:post]->(p)'.format(name, post)
db.query(query)
return result
def removeFriend(name, friendName):
result = None #True/False
db = conn.getDBConnection()
query = 'MATCH (u1:User)-[r:friend]-(u2:User) WHERE u1.name = "{0}" AND u2.name = "{1}" DELETE r'.format(name, friendName)
db.query(query)
return result
def removeLike(name, pageName):
result = None #True/False
db = conn.getDBConnection()
query = 'MATCH (u:User)-[r:like]-(p:Page) WHERE u.name = "{0}" AND p.name = "{1}" DELETE r'.format(name, pageName)
db.query(query)
return result
def addLike(name, pageName):
result = None #True/False
db = conn.getDBConnection()
query = 'MATCH (u:User),(p:Page) WHERE u.name = "{0}" AND p.name = "{1}" CREATE (u)-[r:like]->(p)'.format(name, pageName)
db.query(query)
return result
def addFriend(name, friendName):
result = None #True/False
db = conn.getDBConnection()
query = 'MATCH (u1:User),(u2:User) WHERE u1.name = "{0}" AND u2.name = "{1}" CREATE (u1)-[r:friend]->(u2)'.format(name, friendName)
db.query(query)
return result
def getByName(name):
db = conn.getDBConnection()
query = 'MATCH (u:User) WHERE u.name = "{0}" RETURN u'.format(name)
user = db.query(query, returns = (client.Node))
return user
def getAll():
db = conn.getDBConnection()
query = 'MATCH (u:User) RETURN u'
users = db.query(query, returns = (client.Node))
return users
def deletePost(name, post):
result = None #True/False
db = conn.getDBConnection()
query = 'MATCH (u:User)-[r:post]-(p:Post) WHERE u.name = "{0}" AND p.message = "{1}" DELETE r'.format(name, post)
db.query(query)
return result
def deleteUser(name):
result = None #True/False
db = conn.getDBConnection()
query = 'MATCH (u:User) WHERE u.name = "{0}" DELETE u'.format(name)
db.query(query)
return result
def createPage(name):
#Implement other attributes
result = None #True/False
db = conn.getDBConnection()
query = 'CREATE (p:Page {{name: "{0}"}})'.format(name)
db.query(query)
return result
def getAllPosts():
db = conn.getDBConnection()
query = 'MATCH (u:User)-[r:post]-(p:Post) RETURN u, type(r), p'
posts = db.query(query, returns=(client.Node, str, client.Node))
return posts
def getAllLikes(name):
db = conn.getDBConnection()
query = 'MATCH (u:User)-[r:like]-(p:Page) WHERE u.name = "{0}" RETURN u, type(r), p'.format(name)
likes = db.query(query, returns = (client.Node, str, client.Node))
return likes
def getAllFriends(name):
db = conn.getDBConnection()
query = 'MATCH (u1:User)-[r:friend]-(u2:User) WHERE u1.name = "{0}" RETURN u1, type(r), u2'.format(name)
friends = db.query(query, returns = (client.Node, str, client.Node))
return friends
def getAllPosts(name):
db = conn.getDBConnection()
query = 'MATCH (u:User)-[r:post]-(p:Post) WHERE u.name = "{0}" RETURN u, type(r), p'.format(name)
posts = db.query(query, returns = (client.Node, str, client.Node))
return posts
