1
-- 开启
2
LOAD 'age';
3
SET search_path = ag_catalog, "$user", public;
4

5

6
SELECT * FROM ag_catalog.drop_graph('geae', true);
7

8

9

10
SELECT create_graph('geae');
11

12

13

14
SELECT * FROM cypher('geae', $$
15

16
CREATE (i1:Invoice {id:'123', name: '发票1', code: 'B1'}),
17

18
(i2:Invoice {name: '发票2', code:'B2'}),
19

20
(f1:Form {name: "单据1", comment: "发票:B1"}),
21

22
(f2:Form {name: "单据2", comment: "发票:B2"}),
23

24
(f3:Form {name: "单据3", comment: "发票:B3"})
25

26
$$) as (a agtype);
27

28

29

30

31

32
SELECT *
33

34
FROM cypher('geae', $$
35

36
MATCH (a:Invoice), (b:Form)
37

38
WHERE b.comment contains a.code AND b.xxx = a.ccc
39

40
CREATE (a)-[e:包含 {property:a.property + '<->' + b.property}]->(b)
41

42
RETURN e
43

44
$$) as (e agtype);
45

46

47

48
SELECT * from cypher('geae', $$
49

50
MATCH (V)-[R:包含]-(V2)
51

52
RETURN V,R,V2
53

54
$$) as (V agtype, R agtype, V2 agtype);