Mongoose models provide several static helper functions for CRUD operations. Each of these functions returns a mongoose Query
object.
Model.deleteMany()
Model.deleteOne()
Model.find()
Model.findById()
Model.findByIdAndDelete()
Model.findByIdAndRemove()
Model.findByIdAndUpdate()
Model.findOne()
Model.findOneAndDelete()
Model.findOneAndRemove()
Model.findOneAndReplace()
Model.findOneAndUpdate()
Model.replaceOne()
Model.updateMany()
Model.updateOne()
A mongoose query can be executed in one of two ways. First, if you pass in a callback
function, Mongoose will execute the query asynchronously and pass the results to the callback
.
A query also has a .then()
function, and thus can be used as a promise.
When executing a query with a callback
function, you specify your query as a JSON document. The JSON document's syntax is the same as the MongoDB shell.
var Person = mongoose.model('Person', yourSchema);
// find each person with a last name matching 'Ghost', selecting the `name` and `occupation` fields
Person.findOne({ 'name.last': 'Ghost' }, 'name occupation', function (err, person) {
if (err) return handleError(err);
// Prints "Space Ghost is a talk show host".
console.log('%s %s is a %s.', person.name.first, person.name.last,
person.occupation);
});
Mongoose executed the query and passed the results passed to callback
. All callbacks in Mongoose use the pattern: callback(error, result)
. If an error occurs executing the query, the error
parameter will contain an error document, and result
will be null. If the query is successful, the error
parameter will be null, and the result
will be populated with the results of the query.
Anywhere a callback is passed to a query in Mongoose, the callback follows the pattern callback(error, results)
. What results
is depends on the operation: For findOne()
it is a potentially-null single document, find()
a list of documents, count()
the number of documents, update()
the number of documents affected, etc. The API docs for Models provide more detail on what is passed to the callbacks.
Now let's look at what happens when no callback
is passed:
// find each person with a last name matching 'Ghost'
var query = Person.findOne({ 'name.last': 'Ghost' });
// selecting the `name` and `occupation` fields
query.select('name occupation');
// execute the query at a later time
query.exec(function (err, person) {
if (err) return handleError(err);
// Prints "Space Ghost is a talk show host."
console.log('%s %s is a %s.', person.name.first, person.name.last,
person.occupation);
});
In the above code, the query
variable is of type Query. A Query
enables you to build up a query using chaining syntax, rather than specifying a JSON object. The below 2 examples are equivalent.
// With a JSON doc
Person.
find({
occupation: /host/,
'name.last': 'Ghost',
age: { $gt: 17, $lt: 66 },
likes: { $in: ['vaporizing', 'talking'] }
}).
limit(10).
sort({ occupation: -1 }).
select({ name: 1, occupation: 1 }).
exec(callback);
// Using query builder
Person.
find({ occupation: /host/ }).
where('name.last').equals('Ghost').
where('age').gt(17).lt(66).
where('likes').in(['vaporizing', 'talking']).
limit(10).
sort('-occupation').
select('name occupation').
exec(callback);
A full list of Query helper functions can be found in the API docs.
Mongoose queries are not promises. They have a .then()
function for co and async/await as a convenience. However, unlike promises, calling a query's .then()
can execute the query multiple times.
For example, the below code will execute 3 updateMany()
calls, one because of the callback, and two because .then()
is called twice.
const q = MyModel.updateMany({}, { isDeleted: true }, function() {
console.log('Update 1');
});
q.then(() => console.log('Update 2'));
q.then(() => console.log('Update 3'));
Don't mix using callbacks and promises with queries, or you may end up with duplicate operations.
There are no joins in MongoDB but sometimes we still want references to documents in other collections. This is where population comes in. Read more about how to include documents from other collections in your query results here.
You can stream query results from MongoDB. You need to call the Query#cursor() function to return an instance of QueryCursor.
var cursor = Person.find({ occupation: /host/ }).cursor();
cursor.on('data', function(doc) {
// Called once for every document
});
cursor.on('close', function() {
// Called when done
});
Now that we've covered Queries
, let's take a look at Validation.
© 2010 LearnBoost
Licensed under the MIT License.
https://mongoosejs.com/docs/queries.html