SailsJs Models long integer support with postgresql

Question

I'm having issues with a Sails application running with a PostgreSQL database. I needed to insert an 11 digits integer, but I can't find a simple way to tweak my models for this.

Edit 1 here is an example of a model :

/**
 * Phone.js
 *
 * @docs        :: http://sailsjs.org/#!documentation/models
 */

module.exports = {

    attributes: {
        number: {
            type: 'integer',
            required: true,
            minLength: 9
        }
    }
};

Is there a way (using the ORM) to change that integer into a BIGINT in Postgre so I don't get ERROR: integer out of rage when inserting?

Answer 1

According to this, yo should just be able to define "bigint" as the type

https://github.com/balderdashy/sails-postgresql/blob/master/lib/utils.js#L241

also supports float, real, smallint ect . . .

Answer 2

Defining type as bigint didn't work in my case. I was getting an error in validation while creating an entry in the model.

However, I gave the following properties,

type: string,
numeric: true,
minLength: 10

It was good enough but not exactly what I wanted.

Answer 3

The reason your value is returned as a string is because PostgreSQL's maximum value for BIGINT (2^63-1 = 9223372036854775807) is considerably bigger than Javascript's Number.MAX_SAFE_INTEGER (2^53 - 1 = 9007199254740991) so if Sails / Waterline ORM were to cast your returned value as an integer all the time there is a possibility of breaking things.

So, it's safer to return a string every time.

Answer 4

I was able to get it to work by setting the attributes with the following:

type: 'ref',
columnType: 'int8',