[Solved] Convert MySQL update query into sequelize query

by


For an async function, this is how you would do it, assuming you’ve set up your User model:

myFunction: async (req, res) => {
    var tempToken = req.body.tempToken // Put whatever your data source is here for tempToken
    var newValue = tempToken - 5
    try {
        await User.update({
            tempToken: newValue
        },
        {
            where: [{
                id: 1
            }]
        })
        res.status(200).send();
    }
    catch (error) {
        res.status(500).send(error);
    }
}

or

myFunction: async (req, res) => {
    try {
        const user = User.findOne({
            where: {
                id: 1
            }
        })
        await user.update({
            tempToken: user.tempToken - 5
        })
        res.status(200).send();
    }
    catch (error) {
        res.status(500).send(error);
    }
}

Also, don’t forget to ‘require’ the user model in the .js file that you use this function in.

5

solved Convert MySQL update query into sequelize query