# 登录信息
# 用户名: root
# 密码: YourSecurePassword123!

# ArangoDB Web界面功能：
# – 数据库管理
# – 集合管理
# – AQL查询编辑器
# – 图可视化
# – 用户管理
# – 服务监控

使用arangosh连接

# 输出示例如下：
Please specify a password:

_
__ _ _ __ __ _ _ __ __ _ ___ ___| |__
/ _` | ‘__/ _` | ‘_ \ / _` |/ _ \/ __| ‘_ \
| (_| | | | (_| | | | | (_| | (_) \__ \ | | |
\__,_|_| \__,_|_| |_|\__, |\___/|___/_| |_|
|___/

arangosh (ArangoDB 3.12.4 [linux] 64bit)
Connected to ArangoDB ‘http+tcp://192.168.1.51:8529’, database: ‘_system’, username: ‘root’
Type ‘tutorial’ for a tutorial or ‘help’ to see common examples

127.0.0.1@_system>

# 查看版本
127.0.0.1@_system> db._version();

3.12.4

# 查看数据库
127.0.0.1@_system> db._databases();

[
“_system”
]

# 查看服务器状态
127.0.0.1@_system> require(“internal”).statistics();

{
“server” : {
“version” : “3.12.4”,
“mode” : “server”,
“uptime” : 3600
},
“client” : {
“httpConnections” : 1,
“totalTime” : 0.001
}
}

创建数据库和集合

true

# 使用数据库
127.0.0.1@_system> db._useDatabase(“testdb”);

true

# 创建文档集合
127.0.0.1@testdb> db._create(“users”);

[ArangoCollection 100, “users” (type document, status loaded)]

# 创建边集合
127.0.0.1@testdb> db._createEdgeCollection(“follows”);

[ArangoCollection 101, “follows” (type edge, status loaded)]

# 查看集合
127.0.0.1@testdb> db._collections();

[
[ArangoCollection 100, “users” (type document, status loaded)],
[ArangoCollection 101, “follows” (type edge, status loaded)]
]

插入和查询数据

{
“_id” : “users/102”,
“_key” : “102”,
“_rev” : “_abc123–”
}

127.0.0.1@testdb> db.users.insert({name: “Li Si”, age: 28, city: “Shanghai”});

{
“_id” : “users/103”,
“_key” : “103”,
“_rev” : “_def456–”
}

127.0.0.1@testdb> db.users.insert({name: “Wang Wu”, age: 32, city: “Guangzhou”});

{
“_id” : “users/104”,
“_key” : “104”,
“_rev” : “_ghi789–”
}

# 插入边数据
127.0.0.1@testdb> db.follows.insert({_from: “users/102”, _to: “users/103”, since: 2018});

{
“_id” : “follows/105”,
“_key” : “105”,
“_rev” : “_jkl012–“,
“_from” : “users/102”,
“_to” : “users/103”,
“since” : 2018
}

# 使用AQL查询文档
127.0.0.1@testdb> db._query(“FOR u IN users RETURN u.name”);

[
“Zhang San”,
“Li Si”,
“Wang Wu”
]

# 使用AQL查询带条件
127.0.0.1@testdb> db._query(“FOR u IN users FILTER u.age > 29 RETURN u”);

[
{
“_key” : “102”,
“_id” : “users/102”,
“_rev” : “_abc123–“,
“name” : “Zhang San”,
“age” : 30,
“city” : “Beijing”
},
{
“_key” : “104”,
“_id” : “users/104”,
“_rev” : “_ghi789–“,
“name” : “Wang Wu”,
“age” : 32,
“city” : “Guangzhou”
}
]

# 使用AQL查询图遍历
127.0.0.1@testdb> db._query(“FOR v, e, p IN 1..2 OUTBOUND ‘users/102’ follows RETURN p”);

[
{
“vertices” : [
{
“_key” : “102”,
“_id” : “users/102”,
“name” : “Zhang San”,
“age” : 30,
“city” : “Beijing”
},
{
“_key” : “103”,
“_id” : “users/103”,
“name” : “Li Si”,
“age” : 28,
“city” : “Shanghai”
}
],
“edges” : [
{
“_key” : “105”,
“_id” : “follows/105”,
“_from” : “users/102”,
“_to” : “users/103”,
“since” : 2018
}
]
}
]

# 退出
127.0.0.1@testdb> exit

REST API测试

# 输出示例如下：
{
“server”: “arango”,
“version”: “3.12.4”,
“license”: “community”,
“details”: {
“architecture”: “64bit”,
“server-version”: “3.12.4”
}
}

# 查询数据
$ curl -X POST “http://192.168.1.51:8529/_api/cursor” \
-u root:YourSecurePassword123! \
-H “Content-Type: application/json” \
-d ‘{“query”: “FOR u IN users RETURN u.name”}’

# 输出示例如下：
{
“result”: [“Zhang San”, “Li Si”, “Wang Wu”],
“hasMore”: false,
“cached”: false,
“extra”: {
“stats”: {
“writesExecuted”: 0,
“writesIgnored”: 0,
“scannedFull”: 3,
“scannedIndex”: 0
},
“warnings”: []
},
“error”: false,
“code”: 201
}