Styjun

I am using sequelize with MySQL. For example if I do:

models.People.update(OwnerId: peopleInfo.newuser,
 where: id: peopleInfo.scenario.id)
 .then(function (result) 
 response(result).code(200);

 ).catch(function (err) 
 request.server.log(['error'], err.stack);
 ).code(200);
 );

I am not getting information back if the people model was succesfully updated or not. Variable result is just an array with one element, 0=1

How can I know for certain that the record was updated or not.

Here's what I think you're looking for.

db.connections.update(
 user: data.username,
 chatroomID: data.chatroomID
, 
 where: socketID: socket.id ,
 returning: true,
 plain: true
)
.then(function (result) 
 console.log(result); 
 // result = [x] or [x, y]
 // [x] if you're not using Postgres
 // [x, y] if you are using Postgres
);

From Sequelize docs:
The promise returns an array with one or two elements. The first element x is always the number of affected rows, while the second element y is the actual affected rows (only supported in postgres with options.returning set to true.)

Assuming you are using Postgres, you can access the updated object with result[1].dataValues.

You must set returning: true option to tell Sequelize to return the object. And plain: true is just to return the object itself and not the other messy meta data that might not be useful.

Update function of sequelize returns a number of affected rows (first parameter of result array).

You should call find to get updated row

models.People.update(OwnerId: peopleInfo.newuser,
 where: id: peopleInfo.scenario.id)
 .then(function (result) 
 models.People.findById(peopleInfo.scenario.id)
 .then(function(user)
 response(user).code(200);
 ).catch(function (err) 
 request.server.log(['error'], err.stack);
 ).code(200);
 );
 ).catch(function (err) 
 request.server.log(['error'], err.stack);
 ).code(200);
);

same thing you can do with async-await, especially to avoid nested Promises
You just need to create async function :)

const asyncFunction = async function(req, res) 
 try 
 //update 
 const updatePeople = await models.People.update(OwnerId: peopleInfo.newuser,
 where: id: peopleInfo.scenario.id)
 if (!updatePeople) throw ('Error while Updating');
 // fetch updated data
 const returnUpdatedPerson = await models.People.findById(peopleInfo.scenario.id)
 if(!returnUpdatedPerson) throw ('Error while Fetching Data');
 res(user).code(200);
 catch (error) 
 res.send(error)
 
 

You can just find the item and update its properties and then save it.
The save() results in a UPDATE query to the db

 const job = await Job.findOne(where: id, ownerId: req.user.id);
 if (!job) 
 throw Error(`Job not updated. id: $id`);
 

 job.name = input.name;
 job.payload = input.payload;
 await job.save();

On Postgres:

Executing (default): UPDATE "jobs" SET "payload"=$1,"updatedAt"=$2 WHERE "id" = $3

Simple snipet to update and get updated result

models.People.findOne(
 where: id: peopleInfo.scenario.id
)
.then((people) => 
 if(people == null) console.log("invalid people");
 people.fieldOne = currentValue;
 people.fieldtwo = currentValue;
 return people.save()
)