my requirement is to return the updated data after updating the data
but sequlize only returns an array in update (), indicating the number of updates.
has to check and return it once after the update. Is there a way for sequlize to return updated data directly after update ()?
you can first use findOne () to find the data to be updated, and then call the model.save () method to update. In this way, you can get the data before and after the update. If you want to ensure data consistency, add a transaction . You don't need to use the update () method.
Previous: Why paragraphs are separated by p tags when writing rich text boxes
Next: Vue encapsulates a search component, there is a problem
how to convert field hump type and underscore type by adding, deleting, modifying and searching operation by Sequelize ...
ask for help. The company s project is divided into libraries according to business. After establishing a connection using sequelize, the connection cache is saved in memory. When there are many sub-libraries, the memory occupation is too high, is there...
< hr > how can this method be changed to sequelize syntax? Multiple table associations urgent. makeupUpdateAccountInfo: function (data) { var companyCode = "" if (data && data.companyCode) { companyCode = ...
Can the sequelize.query () native query use the replacements parameter to prevent sql injection? sequelize.query( SELECT * FROM projects WHERE status = ? , { replacements: [ active ], type: sequelize.QueryTypes.SELECT } ).then(projects => { ...
use strict ; module.exports = appInfo => { const config = {}; should change to your own config.keys = appInfo.name + _sequelize-example ; config.sequelize = { dialect: mssql , support: mysql, mariadb, postgres, mssql ...
at present, if you encounter such a problem of using mysql, first describe the scenario (some simplifications have been made to facilitate the answer): now there are two machines that use the same database account and access and operate a mysql addres...
problem description uses node.js s ORM framework Sequelize to operate the database, defines the model model through sequelize.define () , and then sets the data type of the column data field to DataType to Sequelize.JSON,. After setting it to sequ...
the koa + sequelize, used will leave new sequelize, as soon as it enters the project. It s normal locally, but it won t work online. It s always adjusted for the first time, and it will make mistakes later. Later, it will be changed to go to new seque...
let pets=await ctx.model.Pet.findAndCount({ offset:offset, limit:query.limit, order: [ [ctx.model.User,ctx.model.Shop, userId , ASC ], [ createdAt , DESC ] ], ...