Mode:     0644,
			},
			{
				Name:     "gophercolor16x16.png",
				File:     "gophercolor16x16.png",
				Modified: time.Date(2010, 9, 5, 15, 52, 58, 0, timeZone(+10*time.Hour)),
				Mode:     0644,
			},
		},
	},
	{
		Name:    "test-trailing-junk.zip",
		Comment: "This is a zipfile comment.",
		File: []ZipTestFile{
			{
				Name:     "test.txt",

=== "Python 3.10+"

    ```Python hl_lines="58-66  69-74  94"
    {!> ../../../docs_src/security/tutorial003_an_py310.py!}
    ```

=== "Python 3.9+"

    ```Python hl_lines="58-66  69-74  94"
    {!> ../../../docs_src/security/tutorial003_an_py39.py!}
    ```

=== "Python 3.8+"

=== "Python 3.10+"

    ```Python hl_lines="58-66  69-74  94"
    {!> ../../../docs_src/security/tutorial003_an_py310.py!}
    ```

=== "Python 3.9+"

    ```Python hl_lines="58-66  69-74  94"
    {!> ../../../docs_src/security/tutorial003_an_py39.py!}
    ```

=== "Python 3.8+"

* 创建 `FastAPI` 应用
* 创建事件处理器，执行数据库连接与断开操作

```Python hl_lines="42  45-47  50-52"
{!../../../docs_src/async_sql_databases/tutorial001.py!}
```

## 读取笔记

创建读取笔记的*路径操作函数*：

```Python hl_lines="55-58"
{!../../../docs_src/async_sql_databases/tutorial001.py!}
```

!!! Note "笔记"

    注意，本例与数据库通信时使用 `await`，因此*路径操作函数*要声明为异步函数（`asnyc`）。

### 注意 `response_model=List[Note]`

если рабочая нагрузка предполагает **ограничение по процессору**,
как, например, в системах машинного обучения. <!--http://new.gramota.ru/spravka/punctum?layout=item&id=58_329-->

Необходимо также отметить, что Python является главным языком в области
<abbr title="наука о данных (data science)">**дата-сайенс**</abbr>,
машинного обучения и, особенно, глубокого обучения. Всё это делает FastAPI

	_ = x[HandlerGetSysConfig-52]
	_ = x[HandlerGetSysServices-53]
	_ = x[HandlerGetSysErrors-54]
	_ = x[HandlerGetAllBucketStats-55]
	_ = x[HandlerGetBucketStats-56]
	_ = x[HandlerGetSRMetrics-57]
	_ = x[HandlerGetPeerMetrics-58]
	_ = x[HandlerGetMetacacheListing-59]
	_ = x[HandlerUpdateMetacacheListing-60]
	_ = x[HandlerGetPeerBucketMetrics-61]
	_ = x[HandlerStorageInfo-62]
	_ = x[HandlerConsoleLog-63]
	_ = x[HandlerListDir-64]

```Python hl_lines="42  45-47  50-52"
{!../../../docs_src/async_sql_databases/tutorial001.py!}
```

## Read notes

Create the *path operation function* to read notes:

```Python hl_lines="55-58"
{!../../../docs_src/async_sql_databases/tutorial001.py!}
```

!!! note
    Notice that as we communicate with the database using `await`, the *path operation function* is declared with `async`.

	_ = x[ErrRemoteTargetNotVersionedError-54]
	_ = x[ErrReplicationSourceNotVersionedError-55]
	_ = x[ErrReplicationNeedsVersioningError-56]
	_ = x[ErrReplicationBucketNeedsVersioningError-57]
	_ = x[ErrReplicationDenyEditError-58]
	_ = x[ErrRemoteTargetDenyAddError-59]
	_ = x[ErrReplicationNoExistingObjects-60]
	_ = x[ErrReplicationValidationError-61]
	_ = x[ErrReplicationPermissionCheckError-62]
	_ = x[ErrObjectRestoreAlreadyInProgress-63]

使之仅在当前用户为激活状态时，才能获取 `current_user`。

为此，要再创建一个依赖项 `get_current_active_user`，此依赖项以 `get_current_user` 依赖项为基础。

如果用户不存在，或状态为未激活，这两个依赖项都会返回 HTTP 错误。

因此，在端点中，只有当用户存在、通过身份验证、且状态为激活时，才能获得该用户：

```Python hl_lines="58-67  69-72  90"
{!../../../docs_src/security/tutorial003.py!}
```

!!! info "说明"

    此处返回值为 `Bearer` 的响应头 `WWW-Authenticate` 也是规范的一部分。

    任何 401**UNAUTHORIZED**HTTP（错误）状态码都应返回 `WWW-Authenticate` 响应头。

이러한 의존성 모두, 사용자가 존재하지 않거나 비활성인 경우 HTTP 오류를 반환합니다.

따라서 엔드포인트에서는 사용자가 존재하고 올바르게 인증되었으며 활성 상태인 경우에만 사용자를 얻습니다:

=== "파이썬 3.7 이상"

    ```Python hl_lines="58-66  69-72  90"
    {!> ../../../docs_src/security/tutorial003.py!}
    ```

=== "파이썬 3.10 이상"

    ```Python hl_lines="55-64  67-70  88"
    {!> ../../../docs_src/security/tutorial003_py310.py!}
    ```