Me and another programmer have run around in circles on this and cannot seem to find an answer online. We have a MongoDB collection into which we have inserted documents which have been pulled from an API. Each document has a field called attributes.created which is a string. The format of the string is like… Read More How to sort by year using a date string in PyMongo Aggregate

I want to make a system where when a user enters the private creation channel, a text channel and a voice channel are created, in the text the creator can give and take away the rights to enter the private, and if the owner leaves the private, then in a minute the channels should be… Read More Creating private channels and deleting them in the discord

I execute some_python_function on all elements of collection. This function returns different values for each document. I developed the following function, but it’s very slow. for doc in db.collection.find(query, projection): result = db.collection.update_one( {"_id": doc["_id"]}, {"$set": {"field": some_python_function(doc["field"])}} ) I am looking any smarter way to do it, rather than updating documents one-by-one. What would… Read More Smart way to update all documents in mongodb using python function

This may sound like a dumb question but I was working with pymongo and wrote the following function to insert documents and was wondering if the insert_many method would also work for one record inserts, that way I wouldn’t need another function in case I was just inserting one record. This is my function: def… Read More Pymongo is it possible to insert one with insert_many?

I’m trying to match by a given year (lets say 2008) and from there, group by months in order to find the count for each month in 2008. So far, im able to group by month, but im unable to filter by only a particular year. The date column is stored as a datetime object… Read More Aggregate group by months and match by given year