Skip to main content
100%

Aggregate data from MongoDB with Node.js and mongoose

✓ Published0🌍 Public
Aackuser
Last edited Mar 23, 2014
Created on Dec 21, 2018

This example demonstrates how to calculate an account balance by aggregating embedded financial records in MongoDB using Node.js and Mongoose. It defines Account and Record schemas, inserts sample data, and runs an aggregation pipeline with `$match`, `$unwind`, and `$group` to sum record amounts via `AccountModel.aggregate()`. The code also shows CRUD operations for accounts and records, with results logged to the console.

AI-generated description

Similar vizzes

Loading thumbnail…

MapReduce with MongoDB in NodeJS

This example demonstrates a MapReduce operation in MongoDB, executed from a Node.js application, that aggregates sensor measurements into hourly averages per user and device. The code defines custom `map`, `reduce`, and `finalize` functions to group raw data points by a composite key of user email, device UID, and the hour timestamp, then computes a weighted average value and total weight. The operation queries MongoDB’s `Measure` collection, merges results into an output collection named `measure1hs`, and reports execution statistics via a callback. The implementation uses MongoDB’s native `db.Measure.collection.mapReduce` API directly, bypassing Mongoose, and handles asynchronous completion through a callback function.

Aackuser
70% match
Loading thumbnail…

MongoDB Aggregation Framework way for "select count (distinct fieldName) from someTable" for large collections

This example shows how to compute the equivalent of a SQL “select count (distinct fieldName) from someTable” using MongoDB’s Aggregation Framework for large collections. The code uses the `db.someCollection.aggregate()` method with two `$group` stages: the first groups documents by the distinct value of `fieldName` (assigned to `_id`), and the second groups all results into a single document (`_id: 1`) while summing the number of groups with `$sum: 1` to produce the final count. The snippet is written as a JavaScript gist and relies solely on MongoDB’s native aggregation pipeline, with no external visualization library.

Aackuser
64% match
Loading thumbnail…

Gist 737033

This example demonstrates a MapReduce aggregation over a MongoDB collection of crime records, showing the count of crimes grouped by property name. The code first seeds a `crimes` collection with sample data, then defines a `map` function that emits each property name with a value of 1, and a `reduce` function that sums the emitted values. The MapReduce operation runs via `db.crimes.mapReduce()` and outputs the results as a JSON array using `printjson`. It uses MongoDB’s JavaScript shell API for data insertion, mapping, reduction, and result retrieval.

CCaged
60% match
Loading thumbnail…

Gist 444255

This example demonstrates a Node.js server that queries MongoDB collections and logs their contents to the console, primarily as a backend testing or debugging tool. The code uses the `mongo.Db` and `mongo.Server` APIs to connect to a local MongoDB instance on port 27017, then defines HTTP routes via a `get()` handler. For each route, it retrieves documents from specific collections—`some-collection` and `another-collection` (the latter with a limit of 10)—and prints each item using `sys.puts` and `sys.inspect`. The visualization aspect is absent; the example focuses on database interaction and response handling.

CCaged
60% match
Loading thumbnail…

MongoDB equivalent of an SQL query to get the distinct values of a field in a collection including the count of documents which have each distinct value (distinct with count)

This example demonstrates how to retrieve distinct values of a field in a MongoDB collection along with the document count for each value, mirroring a SQL `GROUP BY` query. It shows two aggregation pipelines using MongoDB’s `aggregate()` method with the `$group` stage to group by the field `_id` and compute a `count` via `$sum:1`, and an optional `$sort` stage to order the results by count descending. The first pipeline returns unsorted counts, while the second sorts them from highest to lowest. No external visualization library is used; the output is raw aggregated data from the database.

Aackuser
58% match
Loading thumbnail…

Some packages needed for reports with Mongo and jsreport, download your reports in xlsx format

This example shows how to generate downloadable xlsx reports from a MongoDB database using jsreport and Express. The code connects to MongoDB via Mongoose, defines a User schema, and queries all user records on an HTTP GET request to `/generate`. It then sends the query results to jsreport’s client API, specifying a template shortid and the `jsreport.excel` recipe for rendering. The setup requires packages like `mongo-xlsx`, `express`, `mongoose`, and `nodemon`, with commands for installation and running the project via `yarn dev`.

MMistyBlunch
58% match
Loading thumbnail…

Mongo Basics Drills

This example shows a series of MongoDB shell commands that demonstrate basic CRUD operations and query patterns against a restaurant dataset. The code performs actions like finding all documents, sorting and limiting results, retrieving documents by `_id` or field values, counting records, deleting single documents, and updating either one or many documents using `updateOne` and `update` with the `$set` operator. It also illustrates how to obtain an `ObjectId` from a query result and use it for subsequent operations. The visualization presents these commands as a linear drill sequence, making the MongoDB query syntax and workflow explicit.

Aarcox80
57% match
Loading thumbnail…

My assessement for underbar part 2

This example demonstrates the transformation of a sales team dataset, showing how names are capitalized and sales figures are averaged and compared. The code uses vanilla JavaScript array methods like `forEach` and `reduce`, along with `JSON.stringify` for assertions, to process the data. It calculates the average team sales rounded up and identifies the highest earner by parsing currency strings with `parseInt`. The visualization relies on console output for testing results, with no external rendering libraries.

Aaajungroth
55% match