Skip to content

Instantly share code, notes, and snippets.

@Allison-E
Last active July 20, 2023 17:23

Revisions

  1. Allison-E revised this gist Jul 20, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion social_network.sql
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,5 @@
    SELECT * from cypher('social_network', $$
    CREATE (:Person {name: 'Joseph}),
    CREATE (:Person {name: 'Joseph'}),
    (:Person {name: 'Alice'}),
    (:Person {name: 'Ade'}),
    (:Person {name: 'Mariam'}),
  2. Allison-E revised this gist Jul 20, 2023. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion social_network.sql
    Original file line number Diff line number Diff line change
    @@ -9,7 +9,7 @@ $$) 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)
    CREATE (x)-[:Is_friends_with]->(y)-[:Is_friends_with]->(x)
    $$) AS (e agtype);
    SELECT * from cypher('social_network', $$
  3. Allison-E revised this gist Jul 20, 2023. 1 changed file with 6 additions and 6 deletions.
    12 changes: 6 additions & 6 deletions social_network.sql
    Original file line number Diff line number Diff line change
    @@ -14,30 +14,30 @@ $$) AS (e agtype);
    SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Alice' AND y.name = 'Ryan'
    CREATE (x)-[:Is_friend_with]->(y)-[:Is_friend_with]->(x)
    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_friend_with]->(y)-[:Is_friend_with]->(x)
    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_friend_with]->(y)-[:Is_friend_with]->(x)
    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_friend_with]->(y)-[:Is_friend_with]->(x)
    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_friend_with]->(y)-[:Is_friend_with]->(x)
    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_friend_with]->(y)-[:Is_friend_with]->(x)
    CREATE (x)-[:Is_friends_with]->(y)-[:Is_friends_with]->(x)
    $$) AS (e agtype);
  4. Allison-E revised this gist Jul 20, 2023. 1 changed file with 7 additions and 7 deletions.
    14 changes: 7 additions & 7 deletions social_network.sql
    Original file line number Diff line number Diff line change
    @@ -9,35 +9,35 @@ $$) AS (v agtype);
    SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Joseph' AND y.name = 'Alice'
    CREATE (x)-[:Is_friend_of]->(y)<-[:Is_friend_of]-(x)
    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_friend_of]->(y)-[:Is_friend_of]->(x)
    CREATE (x)-[:Is_friend_with]->(y)-[:Is_friend_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_friend_of]->(y)-[:Is_friend_of]->(x)
    CREATE (x)-[:Is_friend_with]->(y)-[:Is_friend_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_friend_of]->(y)-[:Is_friend_of]->(x)
    CREATE (x)-[:Is_friend_with]->(y)-[:Is_friend_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_friend_of]->(y)-[:Is_friend_of]->(x)
    CREATE (x)-[:Is_friend_with]->(y)-[:Is_friend_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_friend_of]->(y)-[:Is_friend_of]->(x)
    CREATE (x)-[:Is_friend_with]->(y)-[:Is_friend_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_friend_of]->(y)-[:Is_friend_of]->(x)
    CREATE (x)-[:Is_friend_with]->(y)-[:Is_friend_with]->(x)
    $$) AS (e agtype);
  5. Allison-E revised this gist Jul 20, 2023. 1 changed file with 6 additions and 6 deletions.
    12 changes: 6 additions & 6 deletions social_network.sql
    Original file line number Diff line number Diff line change
    @@ -14,30 +14,30 @@ $$) AS (e agtype);
    SELECT * from cypher('social_network', $$
    MATCH (x:Person), (y:Person) WHERE x.name = 'Alice' AND y.name = 'Ryan'
    CREATE (x)-[:Is_friend_of]->(y)<-[:Is_friend_of]-(x)
    CREATE (x)-[:Is_friend_of]->(y)-[:Is_friend_of]->(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_friend_of]->(y)<-[:Is_friend_of]-(x)
    CREATE (x)-[:Is_friend_of]->(y)-[:Is_friend_of]->(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_friend_of]->(y)<-[:Is_friend_of]-(x)
    CREATE (x)-[:Is_friend_of]->(y)-[:Is_friend_of]->(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_friend_of]->(y)<-[:Is_friend_of]-(x)
    CREATE (x)-[:Is_friend_of]->(y)-[:Is_friend_of]->(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_friend_of]->(y)<-[:Is_friend_of]-(x)
    CREATE (x)-[:Is_friend_of]->(y)-[:Is_friend_of]->(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_friend_of]->(y)<-[:Is_friend_of]-(x)
    CREATE (x)-[:Is_friend_of]->(y)-[:Is_friend_of]->(x)
    $$) AS (e agtype);
  6. Allison-E created this gist Jul 20, 2023.
    43 changes: 43 additions & 0 deletions social_network.sql
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,43 @@
    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_friend_of]->(y)<-[:Is_friend_of]-(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_friend_of]->(y)<-[:Is_friend_of]-(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_friend_of]->(y)<-[:Is_friend_of]-(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_friend_of]->(y)<-[:Is_friend_of]-(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_friend_of]->(y)<-[:Is_friend_of]-(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_friend_of]->(y)<-[:Is_friend_of]-(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_friend_of]->(y)<-[:Is_friend_of]-(x)
    $$) AS (e agtype);