I am trying to find a document in a MongoDB instance with the largest value of a particular field. Here is the current code I have to do that: document = collection.find().sort('experiment_id', -1).limit(1) if document is None: # ... else:…
Here is a code fragment that I used to test. I'm trying to determine what happens when you use dictionary vs JSON style, and when you use a variable. from decimal import * from pymongo import MongoClient my_int_a = "21"…
I need your help. I am fetching data from a mongoDb server using Python. While fetching data I encounter an error. drivers = mongodb_global('drivers') filter_col = { "created": 1, "updated": 1, "_id": 1, "name": 1, "birthday": 1, "id_expiry": 1, "license_expiry":…
I'm trying to connect to my shared MongoDB cluster, but I keep receiving the following error: SSL handshake failed: ac-ascvkib-shard-00-02.hkzvmvh.mongodb.net:27017: [WinError 10054] An existing connection was forcibly closed by the remote host. The exact code I'm using is below: from…
I'm building an aggregation pipeline in mongodb and I'm encountering some unexpected behaviour. The pipeline is as follow: [{ "$search":{ "index":"vector_index", "knnBeta":{ "vector":[ -0.30345699191093445, 0.6833441853523254, 1.2565147876739502, -0.6364057064056396 ], "path":"embedding", "k":10, "filter":{ "compound":{ "filter":[ { "text":{ "path":"my.field.name", "query":[ "value1", "value2", "value3",…
On MongoDB the _Id field for some reason is always very similar, so similar that after 20 documents I cant insert more because the _Id will be the same. What I think is happening is MongoDB generates the _Id based…
I am trying to search my MongoDB of products. The dataset has multiple of each product to record price over time. I would like to search for a phrase then limit the results to 1 of each UPC. My current…
I want to try import pymongo via JupyterLab but i have received an error message and tried uninstall pymongo, httpx, httpcore and again install them but not work. how can i solve this problem, please help me. Thank you for…
We have a collection with documents called notes like: { "_id": { "$oid": "64b42008f622157dd5aead17" }, "isbn": 9789401466097, "chapter": 2, "notes": [ { "note": "a note", "dt": 2374238742345, }, { "note": "another note about the same book and chapter", "dt": 2345234234,…
I want to update a field in MongoDB only if the string value being inserted has a longer length (number of characters) than what is currently stored in the database. How can I achieve this? Here is my current python…