Sails Waterline Model - attribute parsed as string for postgres bigint column

Question

I am using Sails alongside its Waterline ORM for PostgreSQL. I am having an issue with the defaultsTo parameter in model attribute definition.

Here is a part of my Model definition:

module.exports = {
  tableName: 'table',

  attributes: {
    [...]
    reach: {
      type: 'number',
      defaultsTo: 0,
    }
    [...]
  }
}

When using Model.create(), I get this console warning:

Warning: After transforming columnNames back to attribute names for model `model`,
 a record in the result has a value with an unexpected data type for property `reach`.
The corresponding attribute declares `type: 'number'` but instead
of that, the actual value is:
` ` `
'0'
` ` `

I have a bunch of number type attributes so this leads to a lot of warnings in my console.

At this point, I believe this is a waterline issue but do you have a workaround to avoid this warning?

Edit

My warning is only appearing for Postgres "BIGINT" column I am starting to undersand that JS cannot handle postgres BIGINT as number so it must be converted to string.

benomite · Accepted Answer · 2019-04-05 10:01:53Z

1

I found a way to avoid warning : set attribute a different way:

attributes: {
  [...]
  reach: {
    type: 'ref',
    columnType: 'bigint',
    isNumber: true,
    defaultsTo: 0
  },
  [...]
}

answered Apr 5, 2019 at 10:01

benomite

8788 silver badges25 bronze badges

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

3 Comments

Noitidart Over a year ago

I was having this problem too! Thank you I will try this!!

Noitidart Over a year ago

My thing is I need to create time fields, like the createdAt and updatedAt fields, is this the way you found to accomplish this?

Noitidart Over a year ago

I tried this, however the number is still coming back as string :(

Collectives™ on Stack Overflow

Sails Waterline Model - attribute parsed as string for postgres bigint column

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related