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