Sequelize js: update / save in model's method

Question

How to update a record inside model's method like 'node orm-2' In 'Sequelize'

In orm-2, Just use this.save()

var users = db.define('users',
    {
        id          : { type: 'serial', key: true },
        username    : { type: 'text', size: 25, unique: true, required: true },
        balance     : { type: 'integer', defaultValue: 0 },
    }, {
        timestamp: true,
        methods: {
            addBalance: function (howMany) {
                howMany = Math.abs(howMany);
                this.balance += howMany;
                this.save(function (err) {
                    console.log("added money to "+this.username+" : "+howMany);
                });
            }
        }
    });

But in Sequelize, I don't know yet

var wallet = sequelize.define('wallet', {
    balance : { type: Sequelize.INTEGER, defaultValue: 0, validate: { min: 0 } }
}, {
    timestamps: true,
    classMethods: {
        addBalance: function (howMany) {
            howMany = Math.abs(howMany);
            this.balance += howMany;
            //UPDATE Or SAVE HERE...
        }
    }
});

Is it have simple command or prefer another methods?

piotrbienias · Accepted Answer · 2017-02-15 16:19:11Z

1

You should place the addBalance method inside instanceMethods, not in classMethods, because you want to operate on a single instance of specified model

instanceMethods: {
    addBalance: function(howMany) {
        howMany = Math.abs(howMany);
        return this.set('balance', this.get('balance') + howMany).save();
    }
}

This method would return Promise resolving to current instance of model.

EDIT

Even better solution would be to use instance.increment method

addBalance: function(howMany) {
    howMany = Math.abs(howMany);
    return this.increment('balance', { by: howMany });
}

It would return the same as the option above.

edited Feb 15, 2017 at 16:19

answered Feb 15, 2017 at 16:07

piotrbienias

7,4211 gold badge32 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sequelize js: update / save in model's method

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related