$literal - Amazon DocumentDB

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

$literal

Amazon DocumentDB 中的$literal运算符用于表示聚合管道阶段内的文字值。它允许您包含特定值,例如数字、字符串或布尔值,而无需将其解释为字段引用或表达式。

当您需要将文字值作为更复杂的聚合管道的一部分时,例如在构建动态查询筛选器或执行计算时,此运算符特别有用。

参数

示例(MongoDB 外壳)

以下示例演示了如何使用$literal运算符在聚合管道中包含文字值。该$literal运算符用于将值 18 作为文字值包含在 $gt 表达式中。这允许聚合管道将年龄字段与字面值 18 进行比较,以确定该人是否为成年人。

创建示例文档

db.collection.insertMany([ { "name": "John Doe", "age": 30, "city": "New York" }, { "name": "Jane Doe", "age": 25, "city": "Los Angeles" }, { "name": "Bob Smith", "age": 35, "city": "Chicago" } ]);

查询示例

db.collection.aggregate([ { $project: { name: 1, age: 1, city: 1, isAdult: { $gt: ["$age", { $literal: 18 }] } } } ]);

输出

[ { "_id": ObjectId("601234567890abcdef012345"), "name": "John Doe", "age": 30, "city": "New York", "isAdult": true }, { "_id": ObjectId("601234567890abcdef012346"), "name": "Jane Doe", "age": 25, "city": "Los Angeles", "isAdult": true }, { "_id": ObjectId("601234567890abcdef012347"), "name": "Bob Smith", "age": 35, "city": "Chicago", "isAdult": true } ]

代码示例

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

Node.js
const { MongoClient } = require('mongodb'); async function example() { 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('collection'); const result = await collection.aggregate([ { $project: { name: 1, age: 1, city: 1, isAdult: { $gt: ["$age", { $literal: 18 }] } } } ]).toArray(); console.log(result); client.close(); } example();
Python
from pymongo import MongoClient def example(): 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.collection result = list(collection.aggregate([ { '$project': { 'name': 1, 'age': 1, 'city': 1, 'isAdult': { '$gt': ["$age", { '$literal': 18 }] } } } ])) print(result) client.close() example()