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:
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'.