Beispiel #1
0
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
Beispiel #2
0
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
Beispiel #3
0
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)