I want to use MongoDB with Python, but every time I try to access/connect to my database or do some action, it doesn't work, and an error is displayed in the terminal. My code is as follows: import pymongo myclient…
How to update dict within alot of other dicts without changing the dicts around that dict in pymongo Im using flask with this aswell, which is why there is request.form.get() in this and why the code below has indent, i…
I have a MongoDB collection with around 20K articles with an "articledate" string field with dates in the "dd/mm/YYYY" format. Want to query the collection and get the sum of the count of articles in each mm/YYYY. This is the…
{ "_id" : ObjectId("639789e84500571417ii9343"), "72uebaa27279b22p348e61870a6a8840something" : [ { "price" : 130, "date" : 1670874476 }, { "price" : 107, "date" : 1672258500 } ] } I need to find all documents where the second key contains string "something". I only…
After reading many similar questions, although new to MongoDB and pymongo, I believe this specific use case is not covered fully. I need to perform a case insensitive search on a MongoDB collection which holds place names as strings with…
I have a document as follows: { "_id": "1234", "created_at": 1678787680 } I want to modify the document and add a new key updated_at which will be a datetime equivalent of the created_at UNIX timestamp. { "_id": "1234", "created_at": 1678787680,…
EDIT 3 FOR BOUNTY : The below error is not relevant anymore, pymongo accepts the encoded connection string but this is not the good way to go with the AWS Lambda according to this documentation. I am trying to connect…
I need to add 1 millisecond to all objects in my collection. I'm looking at created_date specifically. Such as this: { _id: 'd751b295-6597-4a0b-bd64-89b0fbaac812', yada: { type: 'yada', id: 'nkfsh000136' }, audit: { created_at: '2022-10-03T09:09:22.672144670Z' }, type: 'yada', payload: { encounter:…
Hi I am currently trying to set up a mongo db on my home server and expose it to the internet using cloudflare tunnels. I have a service up and running and have the following for the connection. client =…
I need each document in a collection to be updated only if its content is different, regardless of the order of the elements in nested lists. Fundamentally, two versions should be the same if the elements are identical regardless of…