Edit Page
.update()
Purpose
Updates existing records in the database that match the specified criteria.
Overview
Parameters
| Description | Accepted Data Types | Required ? | |
|---|---|---|---|
| 1 | Find Criteria | {}, string, int |
Yes |
| 2 | Updated Values | {} |
Yes |
| 3 | Callback | function |
No |
Callback Parameters
| Description | Possible Data Types | |
|---|---|---|
| 1 | Error | Error |
| 2 | Sucessfully Updated Records | [{}] |
Example Usage
User.update({name:'Walter Jr'},{name:'Flynn'}).exec(function afterwards(err, updated){
if (err) {
// handle error here- e.g. `res.serverError(err);`
return;
}
console.log('Updated all users named "Walter Jr" to have name ' + updated[0].name);
});
Notes
- An array of primary key values passed to
.update()for acollectionassociation will set the association to contain only the records with those primary key values provided. That is- it unlinks all other records from the association.- If you specify a primary key (e.g.
7or"50c9b254b07e040200000028") instead of a criteria object, any.where()filters will be ignored.- Currently, calling
.populate()on an.update()query has no effect. To populate attributes on the results, you should follow up your update with afind().populate()query.
For a better experience on sailsjs.com, update your browser.
Reference
- Application
- Blueprint API
- Command Line Interface
-
Configuration
- sails.config.*
- sails.config.blueprints
- sails.config.bootstrap()
- sails.config.connections
- sails.config.cors
- sails.config.csrf
- sails.config.globals
- sails.config.http
- sails.config.i18n
- sails.config.log
- sails.config.models
- sails.config.policies
- sails.config.routes
- sails.config.session
- sails.config.sockets
- sails.config.views
-
Request (`req`)
- req.accepted
- req.acceptedCharsets
- req.acceptedLanguages
- req.body
- req.cookies
- req.fresh
- req.headers
- req.host
- req.ip
- req.ips
- req.isSocket
- req.method
- req.options
- req.originalUrl
- req.params
- req.path
- req.protocol
- req.query
- req.secure
- req.signedCookies
- req.socket
- req.subdomains
- req.url
- req.wantsJSON
- req.xhr
- req.accepts()
- req.acceptsCharset()
- req.acceptsLanguage()
- req.allParams()
- req.file()
- req.get()
- req.is()
- req.param()
- Response (`res`)
- Waterline (ORM)
- WebSockets
Built with Love
The Sails framework is maintained by a web & mobile studio in Austin, TX, with the help of our contributors. We created Sails in 2012 to assist us on Node.js projects. Naturally we open-sourced it. We hope it makes your life a little bit easier!
© 2012-2018 The Sails Company.
The Sails framework is free and open-source under the MIT License.