# 切换到fgedudb数据库
127.0.0.1:8529@_system> db._useDatabase(“fgedudb”);
true

# 创建文档集合
127.0.0.1:8529@fgedudb> db._create(“fgedu_users”);

# 输出示例：
[ArangoCollection 123456789, “fgedu_users” (type document, status loaded)]

# 创建边集合
127.0.0.1:8529@fgedudb> db._createEdgeCollection(“fgedu_relations”);

# 输出示例：
[ArangoCollection 123456790, “fgedu_relations” (type edge, status loaded)]

# 查看所有集合
127.0.0.1:8529@fgedudb> db._collections();
[
[ArangoCollection 1, “_graphs” (type document, status loaded)],
[ArangoCollection 2, “_aqlfunctions” (type document, status loaded)],
[ArangoCollection 123456789, “fgedu_users” (type document, status loaded)],
[ArangoCollection 123456790, “fgedu_relations” (type edge, status loaded)]
]

# 输出示例：
{
“_id” : “fgedu_users/user001”,
“_key” : “user001”,
“_rev” : “_abcdefgh”
}

# 批量插入
127.0.0.1:8529@fgedudb> db.fgedu_users.save([
… { “_key”: “user002”, “name”: “李四”, “age”: 28, “city”: “上海” },
… { “_key”: “user003”, “name”: “王五”, “age”: 35, “city”: “广州” }
… ]);

# 查询文档
127.0.0.1:8529@fgedudb> db.fgedu_users.document(“user001”);
{
“_id” : “fgedu_users/user001”,
“_key” : “user001”,
“_rev” : “_abcdefgh”,
“name” : “张三”,
“age” : 30,
“city” : “北京”,
“email” : “zhangsan@fgedu.net.cn”
}

# 更新文档
127.0.0.1:8529@fgedudb> db.fgedu_users.update(“user001”, { “age”: 31 });

# 删除文档
127.0.0.1:8529@fgedudb> db.fgedu_users.remove(“user001”);

# 条件查询
127.0.0.1:8529@fgedudb> db._query(‘
… FOR doc IN fgedu_users
… FILTER doc.age > 25
… RETURN { name: doc.name, age: doc.age }
… ‘).toArray();

# 排序和分页
127.0.0.1:8529@fgedudb> db._query(‘
… FOR doc IN fgedu_users
… SORT doc.age DESC
… LIMIT 0, 10
… RETURN doc
… ‘).toArray();

# 聚合查询
127.0.0.1:8529@fgedudb> db._query(‘
… FOR doc IN fgedu_users
… COLLECT city = doc.city WITH COUNT INTO count
… RETURN { city: city, count: count }
… ‘).toArray();

# 图遍历查询
127.0.0.1:8529@fgedudb> db._query(‘
… FOR v, e, p IN 1..3 OUTBOUND “fgedu_users/user001” fgedu_relations
… RETURN { vertex: v, edge: e }
… ‘).toArray();

# 添加顶点集合
127.0.0.1:8529@fgedudb> graph._addVertexCollection(“fgedu_users”);

# 定义边关系
127.0.0.1:8529@fgedudb> graph._extendEdgeDefinitions({
… collection: “fgedu_relations”,
… from: [“fgedu_users”],
… to: [“fgedu_users”]
… });

# 创建边
127.0.0.1:8529@fgedudb> graph.fgedu_relations.save(“fgedu_users/user001”, “fgedu_users/user002”, {
type: “friend” });

# 图遍历
127.0.0.1:8529@fgedudb> db._query(‘
… FOR v, e IN 1..2 OUTBOUND “fgedu_users/user001” GRAPH “fgedu_social”
… RETURN { name: v.name, relation: e.type }
… ‘).toArray();