Mongodb

最新推荐文章于 2024-10-07 09:09:54 发布

小盐同学Coding笔记

最新推荐文章于 2024-10-07 09:09:54 发布

阅读量86

点赞数

文章标签： mongodb 数据库 database

本文链接：https://blog.csdn.net/a13682008296/article/details/122409097

版权

$in: 和sql中的in一样

cursor = models.UserGroup.aggregate([
        MatchStage(params),
        LookupStage(Group, 'groupID', '_id', 'group'),
        MatchStage({'group.status': GROUP_STATUS_ACTIVATED}),
        UnwindStage('group')])

cusor:光标

aggregate:聚合函数

Match:筛选，相当于where

Lookup:join

unwind:将文档中的某一个数组类型字段拆分成多条，每条包含数组中的一个值。

需求：

{
"_id" : ObjectId("5951c5de567ebff0d5011fba"),
"name" : "陈晓婵",
"address" : "北京朝阳区",
"weekday" : [
1,
2,
3,
4,
5
]
}

对weekday进行拆分:

db.getCollection('chenxiaochantest').aggregate(
[
{
$unwind:"$weekday"
}
]
)

拆分结果:

/* 1 */
{
"_id" : ObjectId("5951c5de567ebff0d5011fba"),
"name" : "陈晓婵",
"address" : "北京朝阳区",
"weekday" : 1
}

/* 2 */
{
"_id" : ObjectId("5951c5de567ebff0d5011fba"),
"name" : "陈晓婵",
"address" : "北京朝阳区",
"weekday" : 2
}

/* 3 */
{
"_id" : ObjectId("5951c5de567ebff0d5011fba"),
"name" : "陈晓婵",
"address" : "北京朝阳区",
"weekday" : 3
}

/* 4 */
{
"_id" : ObjectId("5951c5de567ebff0d5011fba"),
"name" : "陈晓婵",
"address" : "北京朝阳区",
"weekday" : 4
}

/* 5 */
{
"_id" : ObjectId("5951c5de567ebff0d5011fba"),
"name" : "陈晓婵",
"address" : "北京朝阳区",
"weekday" : 5
}