social_network.sql

SELECT * from cypher('social_network', $$
    CREATE (:Person {name: 'Joseph'}),
    (:Person {name: 'Alice'}),
    (:Person {name: 'Ade'}),
    (:Person {name: 'Mariam'}),
    (:Person {name: 'Ryan'}),
    (:Person {name: 'Fred'})
$$) AS (v agtype);

SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Joseph' AND y.name = 'Alice'
    CREATE (x)-[:Is_friends_with]->(y)-[:Is_friends_with]->(x)
$$) AS (e agtype);

SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Alice' AND y.name = 'Ryan'
    CREATE (x)-[:Is_friends_with]->(y)-[:Is_friends_with]->(x)
$$) AS (e agtype);

SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Alice' AND y.name = 'Mariam'
    CREATE (x)-[:Is_friends_with]->(y)-[:Is_friends_with]->(x)
$$) AS (e agtype);

SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Joseph' AND y.name = 'Fred'
    CREATE (x)-[:Is_friends_with]->(y)-[:Is_friends_with]->(x)
$$) AS (e agtype);

SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Fred' AND y.name = 'Mariam'
    CREATE (x)-[:Is_friends_with]->(y)-[:Is_friends_with]->(x)
$$) AS (e agtype);

SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Fred' AND y.name = 'Ryan'
    CREATE (x)-[:Is_friends_with]->(y)-[:Is_friends_with]->(x)
$$) AS (e agtype);

SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Ryan' AND y.name = 'Ade'
    CREATE (x)-[:Is_friends_with]->(y)-[:Is_friends_with]->(x)
$$) AS (e agtype);