CODEWITHSUNDEEP
pythonmongodbnumbersdecimalpymongo
Creative crypter
Creative crypter

Reputation: 1516

Python - Pymongo MongoDB 3.4 - NumberDecimal

i am using mongodb 3.4 in order to insert proper prices to my database..

According to:

https://github.com/mongodb/specifications/blob/master/source/bson-decimal128/decimal128.rst#reading-from-extended-json

i used this in my python code:

'credits': {'$numberDecimal': Decimal128('9.99')},

but throws:

bson.errors.InvalidDocument: key '$numberDecimal' must not start with '$'

So what is the correct syntax for inserting numberdecimal in mongodb using python ?

thanks and greetings

Upvotes: 0

Views: 2812

Answers (2)

A. Jesse Jiryu Davis
A. Jesse Jiryu Davis

Reputation: 24017

Simply this:

collection.insert_one({'credits': Decimal128('9.99')})

(The "$numberDecimal" syntax is for expressing a decimal number within a JSON string. But you're not using JSON at all.)

Upvotes: 3

errata
errata

Reputation: 6041

The link you provided tells you about reading from extended JSON. If you want to insert it as a decimal, you should just use:

{ 'credits': '{0:.2f}'.format(9.99) }

The '{0:.2f}'.format(9.99) part will format the number you pass (in this case 9.99) to include 2 decimals every time. So '{0:.2f}'.format(9) should result in 9.00 in your database.

Upvotes: -1

Related Questions