github.com/vescale/zgraph@v0.0.0-20230410094002-959c02d50f95/tests/testdata/logic_test/simple (about)

     1  statement ok
     2  CREATE GRAPH student_network
     3  
     4  statement ok
     5  USE student_network
     6  
     7  statement ok
     8  CREATE LABEL Person
     9  
    10  statement ok
    11  CREATE LABEL University
    12  
    13  statement ok
    14  CREATE LABEL knows
    15  
    16  statement ok
    17  CREATE LABEL studentOf
    18  
    19  statement ok
    20  INSERT VERTEX x LABELS (Person) PROPERTIES (x.name = 'Kathrine', x.dob = DATE '1994-01-15')
    21  
    22  statement ok
    23  INSERT VERTEX x LABELS (Person) PROPERTIES (x.name = 'Riya', x.dob = DATE '1995-03-20')
    24  
    25  statement ok
    26  INSERT VERTEX x LABELS (Person) PROPERTIES (x.name = 'Lee', x.dob = DATE '1996-01-20')
    27  
    28  statement ok
    29  INSERT VERTEX x LABELS (University) PROPERTIES (x.name = 'UC Berkeley')
    30  
    31  statement ok
    32  INSERT EDGE e BETWEEN x AND y LABELS ( knows ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Kathrine' AND y.name = 'Lee'
    33  
    34  statement ok
    35  INSERT EDGE e BETWEEN x AND y LABELS ( knows ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Kathrine' AND y.name = 'Riya'
    36  
    37  statement ok
    38  INSERT EDGE e BETWEEN x AND y LABELS ( knows ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Lee' AND y.name = 'Kathrine'
    39  
    40  statement ok
    41  INSERT EDGE e BETWEEN x AND y LABELS ( studentOf ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Kathrine' AND y.name = 'UC Berkeley'
    42  
    43  statement ok
    44  INSERT EDGE e BETWEEN x AND y LABELS ( studentOf ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Riya' AND y.name = 'UC Berkeley'
    45  
    46  statement ok
    47  INSERT EDGE e BETWEEN x AND y LABELS ( studentOf ) FROM MATCH (x), MATCH (y) WHERE x.name = 'Lee' AND y.name = 'UC Berkeley'
    48  
    49  query TT rowsort
    50  SELECT a.name AS a, b.name AS b FROM MATCH (a:Person) -[e:knows]-> (b:Person)
    51  ----
    52  Kathrine Lee
    53  Kathrine Riya
    54  Lee Kathrine
    55  
    56  query TT rowsort label1
    57  SELECT p2.name AS friend, u.name AS university
    58  FROM MATCH (u:University) <-[anon1:studentOf]- (p1:Person) -[anon2:knows]-> (p2:Person) -[anon3:studentOf]-> (u)
    59  WHERE p1.name = 'Lee'
    60  ----
    61  Kathrine UC Berkeley
    62  
    63  query TTT rowsort
    64  SELECT p1.name AS p1, p2.name AS p2, p3.name AS p3
    65  FROM MATCH (p1:Person) -[anon1:knows]-> (p2:Person) -[anon2:knows]-> (p3:Person)
    66  WHERE p1.name = 'Lee';
    67  ----
    68  Lee Kathrine Lee
    69  Lee Kathrine Riya
    70  
    71  query TT rowsort label1
    72  SELECT p2.name AS friend, u.name AS university
    73  FROM MATCH (u:University) <-[anon1:studentOf]- (p1:Person) -[anon2:knows]-> (p2:Person) -[anon3:studentOf]-> (u)
    74  WHERE p1.name = 'Lee'