MongoDB insert from NODEJS converts data type of value from int to string

Question

I am trying to update an integer from NodeJS to a MongoDB collection, and however ways I have tried it always converts the integer into a string in the collection.

Please note, I cannot have a strict mongoose schema.

Here's my update function:

 _getModel("envSettings").update(query, toUpdate , {upsert: insertIfNotFound}, function(err, docs){
   _prepResponse(err, docs, callback);
 });

The inputs to this piece of code is like this:

insertIfNotFound: false
query: {'_id':'somekey'}

And here are the variety of toUpdate I have tried:

toUpdate: {$set:{value: 70}}
toUpdate: {$set:{value: parseInt(70)}}
toUpdate: {$set:{value: mongodb.Long(70).toInt()}}

When printing any of the above toUpdate to console, the output is always the same:

{'$set':{value:70}}

I am unsure of how can I save the type of field, please?

I have a mongoose schema, but the "value" field can be of two different kinds - integer, string. Hence, the schema is loosely coupled (strict is false) — swateek
– swateek, Commented Jun 8, 2016 at 8:04
To check all three variation use typeofbecause display in print function will be same always. It is my personal preference to Insert all as string and while displaying check for numeric value, if you find value to be numeric then process it accordingly. Also storing all data as string will help you in making your queries as well — shahmanthan9
– shahmanthan9, Commented Jun 8, 2016 at 8:08
There's a python script that reads certain properties from this collection, and it expects this form as int. I am avoiding to change code there. — swateek
– swateek, Commented Jun 8, 2016 at 8:14

swateek · Accepted Answer · 2016-06-09 05:30:39Z

1

To check all three variation use typeof because display in print function will be same always. It is my personal preference to Insert all as string and while displaying check for numeric value, if you find value to be numeric then process it accordingly.

Also storing all data as string will help you in making your queries as well.

Edit - I used the second approach for my problem.

edited Jun 9, 2016 at 5:30

swateek

7,7189 gold badges38 silver badges51 bronze badges

answered Jun 9, 2016 at 5:26

shahmanthan9

5331 gold badge3 silver badges16 bronze badges

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

Comments

robertklep · Accepted Answer · 2016-06-08 09:58:59Z

0

It sounds like you have a property value declared in your schema of type String:

value : String

This will make Mongoose cast values to string, regardless of the strict setting (which is not related to casting but whether or not to allow undeclared properties in your documents).

You should declare it as a Number instead, because you're writing "there's a python script that reads certain properties from this collection, and it expects this form as int". In other words: you want documents in the database to have a numerical value field.

This will still allow string valued value fields serving as input to Mongoose operations, because Mongoose will cast them to numbers before writing to the database.

If you want to allow both strings and numbers to be written as-is to the database, you need to use mongoose.Schema.Types.Mixed. This basically means that Mongoose will allow anything as input, and it will write the value as-is to the database (no casting). However, since you're saying that the Python tool expects numbers, I'd expect that you want to make sure that numbers are written to the database.

edited Jun 8, 2016 at 9:58

answered Jun 8, 2016 at 9:35

robertklep

205k38 gold badges421 silver badges412 bronze badges

2 Comments

swateek Over a year ago

I cannot do this one, as there are string values too in the collection. Just that I am using mongoose in my node app, I am obligated to have a collection.

robertklep Over a year ago

Mongoose doesn't mind if there are strings in the collection already, it will cast them to Number when creating the document instance (for instance, when querying the collection). But if you really want to allow both strings and numbers to end up in the database, see my edit.

Collectives™ on Stack Overflow

MongoDB insert from NODEJS converts data type of value from int to string

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related