# 前置依賴 JRE(Java Runtime Environment)
$ cd <NEO4J_HOME>
$ vim ./conf/neo4j.conf
# The name of the default database
dbms.default_database=sanguo
# Bolt connector
dbms.connector.bolt.enabled=true
dbms.connector.bolt.tls_level=DISABLED
dbms.connector.bolt.listen_address=:7687
# HTTP Connector. There can be zero or one HTTP connectors.
dbms.connector.http.enabled=true
dbms.connector.http.listen_address=:7474
$ ./bin/neo4j console
2021-02-27 02:45:15.154+0000 INFO Starting...
2021-02-27 02:45:21.637+0000 INFO ======== Neo4j 4.2.3 ========
2021-02-27 02:45:26.105+0000 INFO Performing postInitialization step for component 'security-users' with version 2 and status CURRENT
2021-02-27 02:45:26.106+0000 INFO Updating the initial password in component 'security-users'
2021-02-27 02:45:34.404+0000 INFO Bolt enabled on localhost:7687.
2021-02-27 02:45:35.254+0000 INFO Remote interface available at http://localhost:7474/
2021-02-27 02:45:35.255+0000 INFO Started
終端 Shell 通路
$ ./bin/cypher-shell -a 127.0.0.1 -u neo4j -p 123456
Connected to Neo4j using Bolt protocol version 4.2 at neo4j://127.0.0.1:7687 as user neo4j.
Type :help for a list of available commands or :exit to exit the shell.
Note that Cypher queries must end with a semicolon.
[email protected]> MATCH (n) RETURN n;
+------------------------+
| n |
+------------------------+
| (:Country {name: "魏"}) |
| (:Country {name: "吳"}) |
| (:Country {name: "蜀"}) |
+------------------------+
浏覽器通路：
輸入資料庫名（sanguo），預設使用者名及密碼（neo4j）
Neo4j 示例：三國志人物關系圖譜
Neo4j 示例：三國志人物關系圖譜
導入資料
準備資料集
# 檢視資料導入的目錄
$ less ./conf/neo4j.conf
# This setting constrains all `LOAD CSV` import files to be under the `import` directory. Remove or comment it out to
# allow files to be loaded from anywhere in the filesystem; this introduces possible security problems. See the
# `LOAD CSV` section of the manual for details.
dbms.directories.import=import
# 将資料集（csv）下載下傳至 import 目錄
$ wget -O ./import/sanguo.csv 'https://raw.githubusercontent.com/wangfangye/kg-hongloumeng/master/data/data/三國演義/triples.csv'
--2021-02-26 19:21:46-- https://raw.githubusercontent.com/wangfangye/kg-hongloumeng/master/data/data/%E4%B8%89%E5%9B%BD%E6%BC%94%E4%B9%89/triples.csv
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 185.199.109.133, 185.199.110.133, 185.199.111.133, ...
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|185.199.109.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5926 (5.8K) [text/plain]
Saving to: ‘import/sanguo.csv’
import/sanguo.csv 100%[======================================================================================>] 5.79K --.-KB/s in 0s
2021-02-26 19:21:47 (26.6 MB/s) - ‘import/sanguo.csv’ saved [5926/5926]
$ ls ./import/
sanguo.csv
$ head ./import/sanguo.csv
"head","tail","relation","label"
"關羽","劉備","younger_sworn_brother","義弟"
"張飛","劉備","younger_sworn_brother","義弟"
"關羽","張飛","elder_sworn_brother","義兄"
"張苞","張飛","son","兒子"
"關興","關羽","son","兒子"
"關平","張苞","sworn","結拜"
"關平","關羽","adopted_son","義子"
"盧植","劉備","master","師傅"
"公孫瓒","劉備","friend","朋友"
建立節點
LOAD CSV WITH HEADERS FROM ‘file:///sanguo.csv’ AS line FIELDTERMINATOR ‘,’
MERGE (:Hero { name: line.tail});
LOAD CSV WITH HEADERS FROM ‘file:///sanguo.csv’ AS line FIELDTERMINATOR ‘,’
# (變量别名:節點)-[關系别名:關系]->(變量别名2:節點2)-[:關系2]->()-[*..N]->(:節點3)
# 查找
match p=shortestPath((m:Hero{name:"曹操"})-[*]-(n:Hero{name:"袁紹"})) return p;
MATCH (n:Hero) WHERE id(n)= 121 RETURN n;
MATCH (n:Hero) WHERE n.name="劉備" RETURN n;
MATCH (n:Hero{name:"劉備"}) RETURN n;
MATCH (n:Hero) WHERE n.name IN ["曹操", "劉備", "孫權"] RETURN n AS result;
MATCH (n:Hero) WHERE n.name STARTS WITH "曹" RETURN n;
MATCH (n:Hero) WHERE n.name <> "劉備" AND n.name STARTS WITH "劉" RETURN n;
MATCH (n:Hero) WHERE n.name STARTS WITH "劉" RETURN n.name UNION MATCH (n:Hero) WHERE n.name STARTS WITH "曹" RETURN n.name;
MATCH (m:Hero{name:"曹操"})-[:大王]->(n) WHERE n.name STARTS WITH "夏侯" WITH m, COUNT(n) AS count_n RETURN count_n
# 更新
match (n:Hero{name:"超昂"}) set n.name = "曹昂"
# 建立
WITH ["魏", "吳", "蜀"] as col FOREACH (v IN col | CREATE (:Country{name:v}))
match (n:Hero{name:"甄氏"}) return n;
create (:Hero{name:"甄氏"});
match (m:Hero{name:"袁熙"}),(n:Hero{name:"曹丕"}) create (o:Hero{name:"甄氏"}), (o)-[:妻子]->(m),(o)-[:妾]->(n);
match (m:Hero{name:"黃月英"}), (n:Hero{name:"諸葛亮"}) create (m)-[:妻子]->(n);
match (m:Hero{name:"張飛"}), (n:Hero{name:"劉禅"}) create (m)-[:嶽父]->(n);
match p=((n:Hero{name:"孫權"})-[*..4]-(m:Hero)) return p;
match (m:Hero{name:"孫堅"}),(n:Hero{name:"袁術"}) create (m)-[:臣]->(n);
match (m:Hero{name:"曹嵩"}) create (:Hero{name:"曹騰"})-[:義父]->(m);
match (:Hero{name:"曹騰"})-[r:義父]-(:Hero{name:"曹嵩"}) delete r;
match (m:Hero{name:"曹騰"}) delete m;
# 删除
match (m:Hero{name:"甄氏"}) detach delete m
match (m:Hero)-[r:主公]->(n:Hero) create (m)-[:大王]->(n)
match (m:Hero)-[r:主公]->(n:Hero) delete r
用戶端驅動
Neo4j 示例：三國志人物關系圖譜
https://neo4j.com/download-center/#community
以 Node.js 為例
npm install neo4j-driver
const neo4j = require("neo4j-driver")
var driver = neo4j.driver("bolt://localhost:7687", neo4j.auth.basic("neo4j", "123456"))
var session = driver.session();
session.run("MATCH (h:Hero) WHERE h.name STARTS WITH '曹' RETURN h")
.then(function(result) {
var records = result.records
records.forEach((val, idx) => {
console.log(val._fields[0].properties)
})
}, function (err) {
console.log(err)
})
