Neo4j图数据库

开启

1
neo4j console

加载CSV

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
// 导入标题1数据
LOAD CSV WITH HEADERS FROM 'file:///标题1.csv' AS row
MERGE (t1:标题1 {id: row.id, 标题1: row.标题1})

// 导入标题2数据
LOAD CSV WITH HEADERS FROM 'file:///标题2.csv' AS row
MERGE (t2:标题2 {id: row.id, 标题2: row.标题2})

// 导入标题1与标题2的关联数据
LOAD CSV WITH HEADERS FROM 'file:///标题1关联标题2.csv' AS row
MATCH (t1:标题1 {id: row.from_id})
MATCH (t2:标题2 {id: row.to_id})
MERGE (t1)-[:包含1]->(t2)

// 导入标题3数据
LOAD CSV WITH HEADERS FROM 'file:///标题3.csv' AS row
MERGE (t3:标题3 {id: row.id, 标题3: row.标题3})

// 导入标题2与标题3的关联数据
LOAD CSV WITH HEADERS FROM 'file:///标题2关联标题3.csv' AS row
MATCH (t2:标题2 {id: row.from_id})
MATCH (t3:标题3 {id: row.to_id})
MERGE (t2)-[:包含2]->(t3)

// 导入标题4数据
LOAD CSV WITH HEADERS FROM 'file:///标题4.csv' AS row
MERGE (t4:标题4 {id: row.id, 标题4: row.标题4})

// 导入标题3与标题4的关联数据
LOAD CSV WITH HEADERS FROM 'file:///标题3关联标题4.csv' AS row
MATCH (t3:标题3 {id: row.from_id})
MATCH (t4:标题4 {id: row.to_id})
MERGE (t3)-[:包含3]->(t4)

// 导入标题5数据
LOAD CSV WITH HEADERS FROM 'file:///标题5.csv' AS row
MERGE (t5:标题5 {id: row.id, 标题5: row.标题5})

// 导入标题4与标题5的关联数据
LOAD CSV WITH HEADERS FROM 'file:///标题4关联标题5.csv' AS row
MATCH (t4:标题4 {id: row.from_id})
MATCH (t5:标题5 {id: row.to_id})
MERGE (t4)-[:包含4]->(t5)

// 导入标题6数据
LOAD CSV WITH HEADERS FROM 'file:///标题6.csv' AS row
MERGE (t6:标题6 {id: row.id, 标题6: row.标题6})

// 导入标题5与标题6的关联数据
LOAD CSV WITH HEADERS FROM 'file:///标题5关联标题6.csv' AS row
MATCH (t5:标题5 {id: row.from_id})
MATCH (t6:标题6 {id: row.to_id})
MERGE (t5)-[:包含5]->(t6)

删除全部

1
2
MATCH (r)
DETACH DELETE r
1
2
MATCH (n:(`标题1`|`标题2`|`标题3`|`标题4`))
RETURN n