set array from MongoDB as a variable
I am using MongoDB and pymongo to create a database and store data in them. I have a list that I wish to store in a database. And as far as I understand, I would have to use Python dict…
Unable to import module 'lambda_function': No module named 'pymongo'
I have followed this guide last year to build my AWS python archive and it was working. Today i have automated my code deployment and it was not working (i am using shutil.make_archive("package", 'zip', root_dir=path, base_dir="package/", verbose=True) instead of the…
Mongodb – How can you getKeyByAltName in Pymongo using Field Level Encryption?
I have been trying to get the keys I have generated with this repo https://github.com/mongodb-developer/python-quickstart-code and it is really useful for creating keys in python, however how do you get a key for an altname? I thought perhaps it is…
MongoDB nested map aggregation to sum a array element
I have the following data: [ { "result": { "events": [ { "amount": [ [ 1623224700000, "33333333" ], [ 1623224760000, "33333333" ], [ 1623224820000, "33333334" ] ], } ], } } ] In amount, the second element (str) is the…
Getting distinct values from aggregate result in MongoDB
My data has the following format: [ { "level_1": "A", "cols": [ "A", "B" ], "arno": "DC", "table": [ { country: "NO", population: 400, color: "red" }, { country: "AE", population: 100, color: "red" }, { country: "OT", population: 200,…
Mongodb – How do I push to a nested array in a PyMongo database?
I have a MongoDB database with the following structure (simplified for the question's sake): User: "id": int "aquarium": Aquarium[] Aquarium: "name": str "fish": Fish[] I have access to: The database, which contains a list of objects of type User, which…
Can't connect to MongoDB Replica Set in Docker
I am attempting to run a MongoDB cluster locally to test transactions. I've leveraged the Bitnami docker-compose file version: '2' services: mongodb-primary: image: 'bitnami/mongodb:latest' environment: - MONGODB_ADVERTISED_HOSTNAME=mongodb-primary - MONGODB_REPLICA_SET_MODE=primary - MONGODB_ROOT_PASSWORD=password123 - MONGODB_REPLICA_SET_KEY=replicasetkey123 ports: - 27017:27017 volumes: - 'mongodb_master_data:/bitnami' mongodb-secondary:…
MongoDB poor write speed for collection with 500K documents with pymongo – Ubuntu
System Information: OS: Ubuntu 20.04 LTS System: 80 GB RAM, 1 TB SSD, i7-12700k The documents in this collection are on average 16KB, and there are 500K documents in this collection. I noticed that as the collection grows larger, the…
How to fetch documents based on the count of the elements from pymongo / mongodb
I have 4 conditions which I want to use to fetch my documents: data MUST be between from_date - to_date imageKey MUST be included in IDS EITHER (at least 1 of) "updatedCoordinates.status" should be in ["ORIGINALLY_UNDETECTED","CHANGED"] OR the length of…
Mongodb aggregation to find outliers
In my mongodb collection documents are stored in the following format: { "_id" : ObjectId("62XXXXXX"), "res" : 12, ... } { "_id" : ObjectId("63XXXXXX"), "res" : 23, ... } { "_id" : ObjectId("64XXXXXX"), "res" : 78, ... } ... I…