nodejs+mongodb aggregate cascade query operation example
This article mainly introduces the nodejs mongodb aggregate cascade query operation, and analyzes the related operation skills of the nodejs-based mongodb database cascade query in the form of examples. Friends in need can refer to the following
The examples in this article describe nodejs mongodb aggregate cascade query operation. Share it with everyone for your reference, the details are as follows:
I recently completed a nodejs mongoose project and encountered the cascade query operation of mongodb. The situation is to implement a ranking list to view the top ten people who have published the most valid articles among the customers of a certain company (organization).
Account table: Company information exists in a separate account table.
var AccountSchema = new Schema({
loginname: {type: String},
password: {type: String},
/**
* 联系方式
*/
//账户公司名
comName: {type: String},
//地址
address: {type: String},
//公司介绍
intro: {type: String}
});
mongoose.model('Account', AccountSchema);Cusomer table: The company's customer base.
var CustomerSchema = new Schema({
/**
* 基本信息
*/
//密码
password: {type: String},
//归属于哪个Account
belongToAccount: {type: ObjectId, ref: 'Account'},
//手机号，登录用
mobile: {type: String},
//真实姓名
realname: {type: String}
});
CustomerSchema.index({belongToAccount: 1, mobile: 1}, {unique: true});
mongoose.model('Customer', CustomerSchema);article table
var articleSchema= new Schema({
belongToAccount: {type: ObjectId, ref: 'Account'},
title: {type: String},
text: {type: String},
createTime: {type: Date, default: Date.now},
author: {type: ObjectId, ref: 'Customer'},
//0,待确认,1 有效 ,-1 无效
status: {type: Number, default: 0}
});
articleSchema.index({belongToAccount: 1, createTime:-1,author: 1}, {unique: false});
mongoose.model('article', articleSchema);What we need to do here is to organize and sort the soft articles by accountId→aggregate→cascade author to find the author's name and other information.
The code is as follows:
exports.getRankList = function (accountid, callback) {
AticleModel.aggregate(
{$match: {belongToAccount: mongoose.Types.ObjectId(accountid), status: 1}},
{$group: {_id: {customerId: "$author"}, number: {$sum: 1}}},
{$sort: {number: -1}}).limit(10).exec(function (err, aggregateResult) {
if(err){
callback(err);
return;
}
var ep = new EventProxy();
ep.after('got_customer', aggregateResult.length, function (customerList) {
callback(null, customerList);
});
aggregateResult.forEach(function (item) {
Customer.findOne({_id: item._id.customerId}, ep.done(function (customer) {
item.customerName = customer.realname;
item.customerMobile=cusomer.mobile;
// do someting
ep.emit('got_customer', item);
}));
})
});
};The returned result format (there are only two records here, actually the top ten):
[ { _id: { customerId: 559a5b6f51a446602032fs21 }, number: 5,
customerName: 'test2',
mobile:22 } ，
{ _id: { customerId: 559a5b6f51a446602041ee6f }, number: 1,
customerName: 'test1',
mobile: 11 } ]The above is what I compiled for everyone, I hope It will be helpful to everyone in the future.
Related articles:
E-mail address format verification in JavaScript
How to introduce the icon icon into the Vue project
Vue.js implementation of configurable login form code details
The above is the detailed content of nodejs+mongodb aggregate cascade query operation example. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What is the use of net4.0
May 10, 2024 am 01:09 AM
.NET 4.0 is used to create a variety of applications and it provides application developers with rich features including: object-oriented programming, flexibility, powerful architecture, cloud computing integration, performance optimization, extensive libraries, security, Scalability, data access, and mobile development support.
How to configure MongoDB automatic expansion on Debian
Apr 02, 2025 am 07:36 AM
This article introduces how to configure MongoDB on Debian system to achieve automatic expansion. The main steps include setting up the MongoDB replica set and disk space monitoring. 1. MongoDB installation First, make sure that MongoDB is installed on the Debian system. Install using the following command: sudoaptupdatesudoaptinstall-ymongodb-org 2. Configuring MongoDB replica set MongoDB replica set ensures high availability and data redundancy, which is the basis for achieving automatic capacity expansion. Start MongoDB service: sudosystemctlstartmongodsudosys
How to ensure high availability of MongoDB on Debian
Apr 02, 2025 am 07:21 AM
This article describes how to build a highly available MongoDB database on a Debian system. We will explore multiple ways to ensure data security and services continue to operate. Key strategy: ReplicaSet: ReplicaSet: Use replicasets to achieve data redundancy and automatic failover. When a master node fails, the replica set will automatically elect a new master node to ensure the continuous availability of the service. Data backup and recovery: Regularly use the mongodump command to backup the database and formulate effective recovery strategies to deal with the risk of data loss. Monitoring and Alarms: Deploy monitoring tools (such as Prometheus, Grafana) to monitor the running status of MongoDB in real time, and
Navicat's method to view MongoDB database password
Apr 08, 2025 pm 09:39 PM
It is impossible to view MongoDB password directly through Navicat because it is stored as hash values. How to retrieve lost passwords: 1. Reset passwords; 2. Check configuration files (may contain hash values); 3. Check codes (may hardcode passwords).
How to Get Started with NodeJS – a Handbook for Beginners
Oct 09, 2024 am 10:44 AM
Node is an environment in which you can run JavaScript code "Outside the web browser". Node be like – "Hey y'all, you give your JS code to me and I'll run it ". It uses Google's V8 Engine to convert the JavaScript code to Machine Code. Since Node runs JavaScript code outside the web browser, this means that it doesn't have access to certain features that are only available in the browser, like the DOM or the window object or even the localStorage.
How to split a recorded blob stream into multiple 5 second WAV files using JavaScript and make sure it plays normally?
Apr 04, 2025 pm 02:39 PM
When recording using JavaScript, we encountered a requirement: the recorded blob stream needs to be...
Use Composer to solve the dilemma of recommendation systems: andres-montanez/recommendations-bundle
Apr 18, 2025 am 11:48 AM
When developing an e-commerce website, I encountered a difficult problem: how to provide users with personalized product recommendations. Initially, I tried some simple recommendation algorithms, but the results were not ideal, and user satisfaction was also affected. In order to improve the accuracy and efficiency of the recommendation system, I decided to adopt a more professional solution. Finally, I installed andres-montanez/recommendations-bundle through Composer, which not only solved my problem, but also greatly improved the performance of the recommendation system. You can learn composer through the following address:
MongoDB and relational database: a comprehensive comparison
Apr 08, 2025 pm 06:30 PM
MongoDB and relational database: In-depth comparison This article will explore in-depth the differences between NoSQL database MongoDB and traditional relational databases (such as MySQL and SQLServer). Relational databases use table structures of rows and columns to organize data, while MongoDB uses flexible document-oriented models to better suit the needs of modern applications. Mainly differentiates data structures: Relational databases use predefined schema tables to store data, and relationships between tables are established through primary keys and foreign keys; MongoDB uses JSON-like BSON documents to store them in a collection, and each document structure can be independently changed to achieve pattern-free design. Architectural design: Relational databases need to pre-defined fixed schema; MongoDB supports
