creating a sample graph

create_users.adoc

How to create relatonships between elements in a collection

This GraphGist answers a Stackoverflow question.

Creating A Sample User Graph

We want to create a social network, and have to connect some people. Let’s do that in two steps.

Create a few users

FOREACH (name in ["Amanda","Michael", "Max","Magnus","Mark","Peter","Andres"] |
  CREATE (:User {name:name}))

Connecting users starting with M

MATCH (u:User)
    WHERE u.name =~ 'M.*'
    WITH collect(u) as users
    foreach ( i in range(1,length(users)-1) |
      foreach (u1 in [users[i-1]] | foreach ( u2 in [users[i]] |
        create (u1)-[:knows]-> (u2) ))
    )