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?

Could you show us your code?

PatJ
– PatJ

2015-03-19 16:27:22 +00:00
Commented Mar 19, 2015 at 16:27 — PatJ
– PatJ, Commented Mar 19, 2015 at 16:27
pastebin.com/8sD0Xwv4

Raed
– Raed

2015-03-19 17:12:31 +00:00
Commented Mar 19, 2015 at 17:12 — Raed
– Raed, Commented Mar 19, 2015 at 17:12

Meeker · Accepted Answer · 2015-03-20 13:37:12Z

2

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 . . .

answered Mar 20, 2015 at 13:37

Meeker

5,9792 gold badges23 silver badges38 bronze badges

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

1 Comment

Wulf Solter Over a year ago

Canonical link as file keeps changing :) github.com/balderdashy/sails-postgresql/blob/…

risingStar · Accepted Answer · 2015-12-14 00:02:15Z

1

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.

answered Dec 14, 2015 at 0:02

risingStar

3402 silver badges7 bronze badges

Comments

Wulf Solter · Accepted Answer · 2016-07-30 12:37:37Z

1

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.

answered Jul 30, 2016 at 12:37

Wulf Solter

7146 silver badges19 bronze badges

Comments

user2830432 · Accepted Answer · 2020-03-16 05:01:19Z

0

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

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

answered Mar 16, 2020 at 5:01

user2830432

2222 silver badges4 bronze badges

Collectives™ on Stack Overflow

SailsJs Models long integer support with postgresql

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related