Study - ArangoDB (二)

最新推荐文章于 2023-03-03 06:30:00 发布

转载最新推荐文章于 2023-03-03 06:30:00 发布 · 186 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://www.arangodb.com/docs/3.4/aql/tutorial-filter.html

文章标签：

#ArangoDB

本文介绍ArangoDB查询语言(AQL)的基础知识，包括如何执行基本的文档操作，如检索、过滤、排序和限制结果集。同时，涵盖了如何使用AQL进行文档更新和替换，以及如何利用各种过滤条件来精确查找所需数据。

阅读文件

COLLECTIONS
QUERIES
执行下列代码⬇️
```
FOR d IN users
    return d
```
结果⬇️

数据库系统的添加属性 ❓
- _key
  用于在集合中进行标识
- _id
  数据库中唯一地标识文档
- _rev
  系统管理的修订版ID

用户可以在创建文档时提供文档密钥，也可以自动分配一个唯一值。以后无法更改。下划线开头的所有三个系统属性_都是只读的

特定文档

第一种	第二种
`RETURN DOCUMENT("Characters", "17489"`)	`RETURN DOCUMENT("Characters/17489")`
`RETURN DOCUMENT("Characters", ["17489", "17521"])`	`RETURN DOCUMENT(["Characters/17489", "Characters/17521"])`

更新文件(替换整个文档内容)

替换整个文档内容，可以使用REPLACE代替UPDATE

REPLACE "17489" WITH {
    name: "ned",
    surname: "stark",
    alive: false,
    age: 41,
    traits: ["A","H","C","N","P"]
} IN Characters

Filter

DOCUMENT	FILTER
通过文档的键或ID查找文档	为文档匹配制定任意条件

FILTER

平等条件

FOR c IN Characters
    FILTER c.name == "Arya"
    RETURN c

范围条件

FOR c IN Characters
    FILTER c.age >= 30
    RETURN c.name

FOR c IN Characters
    FILTER c.age > 30
    RETURN { name: c.name, age: c.age }

多个条件

第一种第二种
FOR c IN Characters
FILTER c.age < 13
FILTER c.age != null
RETURN { name: c.name, age: c.age } FOR c IN Characters
FILTER c.age < 13 AND c.age != null
RETURN { name: c.name, age: c.age }

第一种	第二种
FOR c IN Characters FILTER c.age < 13 FILTER c.age != null RETURN { name: c.name, age: c.age }	FOR c IN Characters FILTER c.age < 13 AND c.age != null RETURN { name: c.name, age: c.age }

替代条件

FOR c IN Characters
    FILTER c.name == "Jon" OR c.name == "Joffrey"
    RETURN { name: c.name, surname: c.surname }

limiting

LIMIT()

FOR c IN Characters
    LIMIT 10
    RETURN c.name

FOR c IN Characters
    LIMIT 2, 6
    RETURN c.name

Sorting

SORT()

按名称排序

FOR c IN Characters
    SORT c.name
    LIMIT 10
    RETURN c.name

FOR c IN Characters
    SORT c.name DESC
    LIMIT 10
    RETURN c.name

按多个属性排序

FOR c IN Characters
    FILTER c.surname
    SORT c.surname, c.name
    LIMIT 10
    RETURN {
        surname: c.surname,
        name: c.name
    }

插入数据

LET data = [
    {"num":"999","hundreds":"900","tens":"90","ones":"9"},
    {"num":"998","hundreds":"900","tens":"90","ones":"8"},
    {"num":"997","hundreds":"900","tens":"90","ones":"7"},
    {"num":"989","hundreds":"900","tens":"80","ones":"9"},
    {"num":"988","hundreds":"900","tens":"80","ones":"8"},
    {"num":"987","hundreds":"900","tens":"80","ones":"7"},
    {"num":"979","hundreds":"900","tens":"70","ones":"9"},
    {"num":"978","hundreds":"900","tens":"70","ones":"8"},
    {"num":"977","hundreds":"900","tens":"70","ones":"7"},
    {"num":"899","hundreds":"800","tens":"90","ones":"9"},
    {"num":"898","hundreds":"800","tens":"90","ones":"8"},
    {"num":"897","hundreds":"800","tens":"90","ones":"7"},
    {"num":"889","hundreds":"800","tens":"80","ones":"9"},
    {"num":"888","hundreds":"800","tens":"80","ones":"8"},
    {"num":"887","hundreds":"800","tens":"80","ones":"7"},
    {"num":"879","hundreds":"800","tens":"70","ones":"9"},
    {"num":"878","hundreds":"800","tens":"70","ones":"8"},
    {"num":"877","hundreds":"800","tens":"70","ones":"7"}
]
FOR d IN data
    INSERT d INTO Numbers

按多个属性排序

FOR c IN Numbers
FILTER c.hundreds
SORT c.hundreds, c.tens, c.ones
RETURN {
    hundreds: c.hundreds,
    tens: c.tens,
    ones: c.ones
}

按年龄排序

FOR c IN Characters
    FILTER c.age
    SORT c.age
    LIMIT 10
    RETURN {
        name: c.name,
        age: c.age
    }

参考文章：https://www.arangodb.com/docs/3.4/aql/tutorial-filter.html