Question

-3

rated 0 times [ 0] [ 3] / answers: 1 / hits: 21595 / 7 Years ago, tue, may 9, 2017, 12:00:00

I'm writing my service to update a row using sequelize for PostGres. When I try out my query using a PSequel it works fine:

UPDATE test_table SET test_col=NULL WHERE id= '2'

But using sequelize it throws a 500 error:

db.TestTable.update({ testCol: NULL }, { where: { id: id } })

  .then((count) => {

    if (count) {

      return count;

    }

  });

My model does allowNull which I believe is what allows null values to be the default as well as set:

testCol: {

  type: DataTypes.INTEGER,

  allowNull: true,

  defaultValue: null,

  field: 'test_col'

},

Any other value but NULL works as expected. Is there a different method for setting null values?

Only authorized users can answer the question. Please sign in first, or register a free account.

Total Points: 320

Total Questions: 94

Total Answers: 94

Location: Moldova

Member since Sat, Aug 6, 2022

2 Years ago

cristinadomoniquel questions

Wed, Apr 7, 21, 00:00, 3 Years ago

Tue, Dec 1, 20, 00:00, 4 Years ago

Mon, Nov 23, 20, 00:00, 4 Years ago

Mon, Aug 17, 20, 00:00, 4 Years ago

Fri, Jul 31, 20, 00:00, 4 Years ago

answered 7 Years ago madalynn · Accepted Answer

From the looks of it, I think your issue is that you are using SQL's syntax for a null value ('NULL') where you should be using JS syntax ('null').

db.TestTable.update({ testCol: null }, { where: { id: id } })

  .then((count) => {

    if (count) {

      return count;

    }

  });

should work.