def get_friends_from_my_friends(self, personId):
#Consulta los amigos de los amigos de un nodo
with driver.session() as session:
result = session.run(
"MATCH (n:Person{id:$id})-[:FRIEND]->(myFriends)-[:FRIEND]->(othersFriends) RETURN othersFriends.id as id",
id=int(personId)).data()
return result
def delete_relationship(self, personId1, personId2):
with driver.session() as session:
result = session.run(
"MATCH (n:Person{id:$id1})-[r1:FRIEND]->(m:Person{id:$id2})-[r2:FRIEND]->(n)\n"
"DELETE r1, r2",
id1=int(personId1),
id2=int(personId2))
return result
def get_friends(self, personId):
#Consulta los amigos de un nodo
with driver.session() as session:
result = session.run(
"MATCH (n:Person{id:$id})-[:FRIEND]->(fof) RETURN fof.id as id",
id=int(personId)).data()
print(str(result))
return result
def add_new_relationship(self, personId1, personId2):
with driver.session() as session:
result = session.run(
"MATCH (n:Person{id:$id1})\n"
"MATCH (m:Person{id:$id2})\n"
"MERGE (n)-[:FRIEND]->(m)-[:FRIEND]->(n)",
id1=int(personId1),
id2=int(personId2)).data()
return result
def add_person(self, id, name, email, login, password):
with driver.session() as session:
result = session.run(
"CREATE (n:Person{id:$_id, name:$_name, email:$_email, login:$_login, password:$_password})",
_id=id,
_name=name,
_email=email,
_login=login,
_password=password).value()
return result
def get_person_by_name(self, name):
with driver.session() as session:
result = session.run("MATCH (p:Person{name:'{0}'}) RETURN p.name as name".format(name)).data()
return result
def get_all_persons(self):
with driver.session() as session:
result = session.run("MATCH (n:Person) RETURN n.name as name LIMIT 25").data()
return result
def get_person_by_name(self, name):
#Consulta un nodo por su nombre, actualmente no se debe usar
with driver.session() as session:
result = session.run("MATCH (n:Person{name:'" + name +
"'})").data()
return result
def delete_new_relationship(self, name1, name2):
with driver.session() as session:
result = session.run("Match (p1:Person{name:$name1}) -[r:FRIEND]->(p2:Person{name:$name2})"
"DELETE r",name1=name1, name2=name2).value()
return result
def make_friend(self, name1, name2):
with driver.session() as session:
result = session.run("MATCH (p1:Person{name:'" + name1 + "'})\nMATCH (p2:Person{name:'" + name2 + "'})\nCREATE (p1)-[:FRIEND]->(p2)").data()
return result
def get_friends_from_my_friends(self, personId):
with driver.session() as session:
result = session.run(
"MATCH (n:Person{id:$id})-[:FRIEND]->(myFriends)-[:FRIEND]->(othersFriends) RETURN othersFriends.name as name",
id=int(personId)).data()
return result
def get_friends(self, personId):
with driver.session() as session:
result = session.run(
"MATCH (n:Person{id:$id})-[:FRIEND]->(fof) RETURN fof.name as name",
id=int(personId)).data()
return result
def get_person_by_name(self, name):
with driver.session() as session:
result = session.run(
"MATCH (n:Person{name:'" + name +
"'}) RETURN n.name as name, n.age as age").data()
return result
def add_person(self, name, edad):
with driver.session() as session:
result = session.run("CREATE (n:Person{name:$_name, edad:$_edad})",
_name=name, _edad=edad).value()
return result
def get_friends_from_my_friends(self, name):
with driver.session() as session:
result = session.run("MATCH (n {name: $name})-[:FRIEND]->()-[:FRIEND]->(fof) RETURN fof.edad as age, fof.name as name",name=name).data()
return result
def get_friends_from_my_friends(self, name):
with driver.session() as session:
result = session.run("MATCH (p:Person{name:'" + name + "'})-[:FRIEND]->(f)-[:FRIEND]->(fof) RETURN fof.name as name, fof.age as age").data()
return result
def delete_from_my_friends(self, name1, name2):
with driver.session() as session:
result = session.run("MATCH (p1:Person{name:'" + name1 + "'})-[f:FRIEND]->(p2:Person{name:'" + name2 + "'}) DELETE f").data()
return result
def get_all_persons(self):
#Consulta todos los nodos de la base de datos
with driver.session() as session:
result = session.run(
"MATCH (n:Person) RETURN n.id as id LIMIT 25").data()
return result
def add_person(self, name, age):
with driver.session() as session:
result = session.run("CREATE (p:Person{name:'" + name + "', age:" + str(age) + "}) RETURN p.name as name, p.age as age").data()
return result
def add_new_relationship(self, name1, name2):
with driver.session() as session:
result = session.run("Match (p1:Person{name:$name1})"
"Match (p2:Person{name:$name2})"
"Create (p1)-[:FRIEND]->(p2)",name1=name1, name2=name2).value()
return result
