how can I update existing data using upsert sequelize cli

Viewed 684

I want to update some data using migrations, I have a table with this info:

id userName
1 User1
2 User2
3 User3
4 User4

Following the docs:

https://sequelize.org/master/class/lib/query-interface.js~QueryInterface.html#instance-method-addColumn

I made this:

 const db = require('../src/models');
'use strict';

module.exports = {
  up: (queryInterface, Sequelize) => {
    return Promise.all(
    [
      queryInterface.upsert('Users',{userName:'User1 Updated'},{userName:'User1 Updated'},{userName:'User1'},db.Users,{}),
      queryInterface.upsert('Users',{userName:'User2 Updated'},{userName:'User2 Updated'},{userName:'User2'},db.Users,{}),
      queryInterface.upsert('Users',{userName:'User3 Updated'},{userName:'User3 Updated'},{userName:'User3'},db.Users,{}),
      queryInterface.upsert('Users',{userName:'User4 Updated'},{userName:'User4 Updated'},{userName:'User4'},db.Users,{}),
    ]
    )
  },

  down: (queryInterface, Sequelize) => {
    ...
  }
};

But im getting an error:

ERROR: Incorrect syntax near the keyword 'WHEN'.

0 Answers
Related