$$DESCEND - Amazon DocumentDB

本文属于机器翻译版本。若本译文内容与英语原文存在差异,则一律以英文原文为准。

$$DESCEND

Amazon DocumentDB 中的$$DESCEND运算符是管道阶段中使用的特殊位置数组运算符。$redact它指示聚合管道进入当前文档并处理所有字段,无论其嵌套级别如何。

$redact舞台遇到$$DESCEND操作员时,它将保持当前文档中的所有字段可见,并在管道中进一步处理它们。当你想根据条件有选择地编辑或修剪某些字段,同时保留文档的结构时,这很有用。

参数

无。

示例(MongoDB 外壳)

在此示例中,我们将使用带有$$DESCEND运算符的$redact舞台来有选择地显示code字段等于 “Reg” 的文档。

创建示例文档

db.patient.insertMany([ { "_id": 1, "code": "Emp", "patient": "John Doe", "DOB": "1/1/1980", "Hospital": "Main" }, { "_id": 2, "code": "Reg", "patient": "Jane Doe", "DOB": "3/27/1989", "Hospital": "Cherry Hill" }, { "_id": 3, "code": "Emp", "patient": "Bob Smith", "DOB": "6/15/1975", "Hospital": "Downtown" } ]);

查询示例

db.patient.aggregate([ { $redact: { $cond: { if: { $eq: ["Reg", "$code"] }, then: "$$DESCEND", else: "$$PRUNE" } }} ]);

输出

{ "_id": 2, "code": "Reg", "patient": "Jane Doe", "DOB": "3/27/1989", "Hospital": "Cherry Hill" }

代码示例

要查看使用该$$DESCEND命令的代码示例,请选择要使用的语言的选项卡:

Node.js
const { MongoClient } = require('mongodb'); async function redactPatients() { const client = await MongoClient.connect('mongodb://<username>:<password>@<cluster-endpoint>:27017/?tls=true&tlsCAFile=global-bundle.pem&replicaSet=rs0&readPreference=secondaryPreferred&retryWrites=false'); const db = client.db('test'); const collection = db.collection('patient'); const result = await collection.aggregate([ { $redact: { $cond: { if: { $eq: ["Reg", "$code"] }, then: "$$DESCEND", else: "$$PRUNE" } }} ]).toArray(); console.log(result); client.close(); } redactPatients();
Python
from pymongo import MongoClient def redact_patients(): client = MongoClient('mongodb://<username>:<password>@<cluster-endpoint>:27017/?tls=true&tlsCAFile=global-bundle.pem&replicaSet=rs0&readPreference=secondaryPreferred&retryWrites=false') db = client.test collection = db.patient result = list(collection.aggregate([ { "$redact": { "$cond": { "if": { "$eq": ["Reg", "$code"] }, "then": "$$DESCEND", "else": "$$PRUNE" } }} ])) print(result) client.close() redact_patients()