Sequelize Postgres value in raw SQL always throw syntax error during migration

Question

I've tried double quotes, single quotes, escaped quotes, no quotes, around the values in the CASE, but each time I run the migration there is a syntax error at or near "'example'"

'use strict';

module.exports = {
  up: (queryInterface, Sequelize) => {
    return Promise.resolve()
      // ... Removed for brevity
      .then(() => queryInterface
        .addColumn(...)
      )
      .then(() =>
        Sequelize.sequelize.query(
          'UPDATE TableName SET TableName.status=CASE ' +
          'WHEN TableName.status_old IS \'example\' THEN \'example2\' ' +
          'ELSE TableName.status_old END'
        )
      )
      .then(() => queryInterface
        .addColumn(...)
      );
  },

  down: (queryInterface, Sequelize) => {
    // ... Removed for brevity
  }
};

mu is too short · Accepted Answer · 2017-09-14 22:18:23Z

1

Your problem is that IS, PostgreSQL doesn't know what that it is. You want a simple = comparison:

'UPDATE TableName SET TableName.status=CASE ' +
'WHEN TableName.status_old = \'example\' THEN \'example2\' ' +
'ELSE TableName.status_old END'

answered Sep 14, 2017 at 22:18

mu is too short

436k71 gold badges863 silver badges822 bronze badges

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

Collectives™ on Stack Overflow

Sequelize Postgres value in raw SQL always throw syntax error during migration

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