upsert using sequelize model

Question

I tried upsert data using sequelize mode but it will be created duplicated.

what i want if row is not exists insert and if exists update the row.

here is my sequelize model :

module.exports = (sequelize, DataTypes) => {
    return sequelize.define('Contact', {
        id: {
            type: DataTypes.UUID,
            field: 'id',
            allowNull: false,
            autoIncrement: true,
            primaryKey: true
        },
        first_name: {
            type: DataTypes.STRING(100),
            field: 'first_name',
            allowNull: true
        },
        external_id: {
            type: DataTypes.STRING(255),
            field: 'external_id',
            allowNull: false,
            primaryKey: true
        }
    }, {
        schema: 'ec3owner',
        tableName: 'contact',
        timestamps: false
    });
};

and Sequelize method for upsert :

function upsertRow(bodyParams) {
    console.log('bodyParams', bodyParams);
    Contact.upsert(bodyParams, {
            where: {
                external_id: bodyParams.external_id
            },
            individualHooks: true
        })
        .then(function(row) {
            console.log('row', row);
        })
}

Version used :

postgres : 9.6

package.json

"sequelize": "^3.30.4"
"pg": "^6.1.0",

Have you looked up insert / on conflict yet? https://www.postgresql.org/docs/9.6/static/sql-insert.html#SQL-ON-CONFLICT — Scott Marlowe, Oct 11 '17 at 16:53
See question here: https://stackoverflow.com/questions/40647600/postgresql-multi-value-upserts — Scott Marlowe, Oct 11 '17 at 17:15

score 0 · Answer 1 · answered Jan 16 '19 at 07:00

0

Refer sequelize docs : http://docs.sequelizejs.com/class/lib/model.js~Model.html#static-method-upsert

you must not be providing the id value that's the reason its creating a new record instead of updating .

answered Jan 16 '19 at 07:00

supravi

59
5

upsert using sequelize model

1 Answers1