-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathneo4j_setup.txt
70 lines (56 loc) · 2.69 KB
/
neo4j_setup.txt
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
LOAD CSV FROM "file:///neo4j_hlasy_nodes.csv" AS row
CREATE (h:Hlasovanie {id: ToInteger(row[1]), start_time: datetime(row[2]), obdobie: ToInteger(row[3]), schodza: ToInteger(row[4]), schodza_h: ToInteger(row[5]), vysledok: row[6], title: row[7], url: row[8]})
LOAD CSV FROM "file:///neo4j_poslanci_kluby_edges.csv" AS row
MERGE (p:Poslanec {name: row[1]})
MERGE (k:Klub {name: row[2]})
CREATE (p)-[:CLEN]->(k)
LOAD CSV FROM "file:///neo4j_zakony_nodes.csv" AS row
CREATE (z:Zakon {id: ToInteger(row[1]), start_time: datetime(row[2]), stav: row[3], vysledok: row[4], url: row[5]})
LOAD CSV FROM "file:///neo4j_zmeny_nodes.csv" AS row
CREATE (z:Zmena {id: ToInteger(row[1]), start_time: datetime(row[2]), document_id: ToInteger(row[3]), url: row[4]})
USING PERIODIC COMMIT 1000
LOAD CSV FROM "file:///neo4j_poslanec_hlasovanie_edges.csv" AS row
MERGE (h:Hlasovanie {id: ToInteger(row[1])})
MERGE (p:Poslanec {name: row[2]})
CREATE (p)-[:HLASOVAL {hlas: row[3]}]->(h)
LOAD CSV FROM "file:///neo4j_zmeny_hlasovania_edges.csv" AS row
MERGE (z:Zmena {id: ToInteger(row[1])})
MERGE (h:Hlasovanie {id: ToInteger(row[2])})
CREATE (h)-[:HLASOVALO_O]->(z)
LOAD CSV FROM "file:///neo4j_zmeny_predkladatel_edges.csv" AS row
MERGE (z:Zmena {id: ToInteger(row[1])})
MERGE (p:Poslanec {name: row[2]})
CREATE (p)-[:NAVRHOL]->(z)
LOAD CSV FROM "file:///neo4j_zmeny_podpis_edges.csv" AS row
MERGE (z:Zmena {id: ToInteger(row[1])})
MERGE (p:Poslanec {name: row[2]})
CREATE (p)-[:PODPISAL]->(z)
LOAD CSV FROM "file:///neo4j_zakon_posledne_edges.csv" AS row
MERGE (z:Zakon {id: ToInteger(row[1])})
MERGE (h:Hlasovanie {id: ToInteger(row[2])})
CREATE (z)-[:DOHLASOVAL]->(h)
LOAD CSV FROM "file:///neo4j_zakon_navrhovatel_edges.csv" AS row
MERGE (z:Zakon {id: ToInteger(row[1])})
MERGE (p:Poslanec {name: row[2]})
CREATE (p)-[:NAVRHOL]->(z)
LOAD CSV FROM "file:///neo4j_hlasy_zakony_edges.csv" AS row
MERGE (h:Hlasovanie {id: ToInteger(row[1])})
MERGE (z:Zakon {id: ToInteger(row[2])})
CREATE (h)-[:HLASOVALO_O]->(z)
LOAD CSV FROM "file:///neo4j_zakony_zmeny_edges.csv" AS row
MERGE (z:Zakon {id: ToInteger(row[1])})
MERGE (z2:Zmena {id: ToInteger(row[2])})
CREATE (z2)-[:NAVRHNUTA]->(z)
LOAD CSV FROM "file:///neo4j_kluby_spektrum_edges.csv" AS row
MERGE (s:Spektrum {name: row[1]})
MERGE (k:Klub {name: row[2]})
CREATE (k)-[:SUCAST]->(s)
MATCH (p:Poslanec {name: "vláda"})
MATCH (s:Spektrum {name: "koalícia"})
CREATE (k:Klub {name: "vláda"})
CREATE (p)-[:CLEN]->(k)
CREATE (k)-[:SUCAST]->(s)
LOAD CSV FROM "file:///neo4j_rozpravy_nodes_edges.csv" AS row
CREATE (r:Rozprava {id: ToInteger(row[0]), start_time: datetime(row[3]), end_time: datetime(row[4]), text: row[5], url: row[6]})
MERGE (p:Poslanec {name: row[1]})
CREATE (p)-[:VYSTUPIL {druh: row[2]}]->(r)