def printList():
query = """
MATCH (user:User)-->(skill:Skill)
RETURN user.userId, skill.skill
"""
pairs = db.mapArray(db.cypherQuery(query))
skillset = {}
for pair in pairs:
if pair[0] not in skillset:
skillset.update({pair[0]: pair[1]})
else:
skillset[pair[0]] = skillset[pair[0]] + ', ' + pair[1]
query = """
MATCH (user:User) --> (cluster:Cluster)
RETURN DISTINCT user.userId, user.firstName, user.lastName, id(cluster)
ORDER BY id(cluster)
"""
table = db.mapArray(db.cypherQuery(query))
for row in table:
row.append(skillset[row[0]] if row[0] in skillset else None)
print(row)
return table
def printList() :
query = """
MATCH (user:User)-->(skill:Skill)
RETURN user.userId, skill.skill
"""
pairs = db.mapArray(db.cypherQuery(query))
skillset = {}
for pair in pairs :
if pair[0] not in skillset :
skillset.update({pair[0]: pair[1]})
else :
skillset[pair[0]] = skillset[pair[0]] + ', ' + pair[1]
query = """
MATCH (user:User) --> (cluster:Cluster)
RETURN DISTINCT user.userId, user.firstName, user.lastName, id(cluster)
ORDER BY id(cluster)
"""
table = db.mapArray(db.cypherQuery(query))
for row in table :
row.append(skillset[row[0]] if row[0] in skillset else None)
print(row)
return table
def weight (userId) :
query = """
MATCH (user:User {{userId: "{userId}"}})-->(:Stack)-[r]->(other:User)
WITH other, r
MATCH (other)-[:HAS_SKILL]->(s:Skill)
RETURN other, r, collect(skill)
""".format(userId)
results = db.mapArray(db.cypherQuery(query))
print(results)