Sequelize is returning integer as string

Question

I using nodejs v4 with sequelize, and I have a model like this:

var Device = sequelize.define('Device', {
id: {
  type: DataTypes.BIGINT,
  primaryKey: true,
  autoIncrement: true
},
tenantId: {
  type: DataTypes.BIGINT,
  allowNull: false
},
token: {
  type: DataTypes.STRING,
  allowNull: false
}
}, {
 tableName: 'devices'
});

When I select a device by id the type of id is a string, exemple:

Device.findById(9).then( function(result) {
  console.log(result.toJSON().id + 10);
});

The output will be 910, rather than 19, so I look at json and a saw this:

{
  id: "9"
  tenantId: "123"
  token: "adsadsdsa"
}

The id in found device is a string, but I defined it as a number...

Doesn't it should be { "id": 9 } ?

How can I select a device with the types that I defined previously?

Mirek Rusin · Accepted Answer · 2015-10-29 22:45:13Z

12

BIGINT maximum value is 2^63-1, javascript can safely represent up to 2^53. To be on the safe side libraries return those numbers as strings.

If you want to have numbers instead of strings, you can use this library https://github.com/mirek/node-pg-safe-numbers which deals with this issue.

answered Oct 29, 2015 at 22:45

Mirek Rusin

19.6k3 gold badges49 silver badges38 bronze badges

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

Comments

Lucas Merencia · Accepted Answer · 2015-09-16 22:47:18Z

10

I found a fix to this problem on sequelize repo.

https://github.com/sequelize/sequelize/issues/4523

The pg module used for sequelize returns bigint as string because bigints are not guaranteed to fit into js numbers. So I change my model to use integer (DataTypes.INTEGER)

answered Sep 16, 2015 at 22:47

Lucas Merencia

8222 gold badges6 silver badges21 bronze badges

1 Comment

backdesk Over a year ago

Correct me if I am wrong but I think you would have to change your DB schema as well for this to work. In my example (postgres) it doesn't fix anything.

Milkncookiez · Accepted Answer · 2016-04-08 07:31:44Z

2

IMO, a smoother solution is to force parsing of int to int, instead of strings. Checkout this issue and comments.

answered Apr 8, 2016 at 7:31

Milkncookiez

7,48913 gold badges70 silver badges112 bronze badges

1 Comment

Oleksandr Hrin Over a year ago

but what will be the result if the int from the string is larger then the biggest safe int in JS?)

nhaht · Accepted Answer · 2021-07-13 05:19:34Z

1

Trying to put this line before your logic code worked for me, this forces parsing of int8 to int, instead of strings:

require("pg").defaults.parseInt8 = true;

...

try {
    const list = await Posts.findAll();
    console.log(JSON.stringify(list));
} catch (e) {
    console.log(e.message);
}

answered Jul 13, 2021 at 5:19

nhaht

1,25714 silver badges22 bronze badges

2 Comments

Scott Stevens Over a year ago

This works for my use case, but worth noting that if you have numbers larger than 2^53 then it may return incorrect values.

Ashu Sahu Over a year ago

Sorry, I made an edit request to your answer by mistake.

Ashu Sahu · Accepted Answer · 2023-08-23 15:39:55Z

0

What I did on my sequelize model was to apply parseFloat in the getter function

Here is a sample typescript code

@Column({
    type: DataType.DECIMAL(9, 2),
    get() {
        return parseFloat(this.getDataValue('amount') as string);
    },
})
amount?: number;

With this, you can apply your logic to deal with small and big int datatypes

answered Aug 23, 2023 at 15:39

Ashu Sahu

6198 silver badges10 bronze badges

Collectives™ on Stack Overflow

Sequelize is returning integer as string

5 Answers 5

Comments

1 Comment

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related