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.

score 1 · Answer 1 · answered Apr 05 '19 at 10:01

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 05 '19 at 10:01

benomite

848
7
23

I was having this problem too! Thank you I will try this!! – Noitidart Sep 24 '19 at 18:01
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 Sep 24 '19 at 21:41
I tried this, however the number is still coming back as string :( – Noitidart Sep 25 '19 at 01:24

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

1 Answers1