I do have a Database with several collections (overall ~15mil documents) and documents look like this (simplified): They all have an unique _id field as well, but I want to delete duplicates accodring to another field (the external ID field). First, I tried a very manual approach with lists and deleting after…
Tag: mongodb
Why is PyMongo 3 giving ServerSelectionTimeoutError?
I’m using: Python 3.4.2 PyMongo 3.0.2 mongolab running mongod 2.6.9 uWSGI 2.0.10 CherryPy 3.7.0 nginx 1.6.2 uWSGI start params: I setup my MongoClient ONE time: I try and save a JSON dict to MongoDB: It works via a unit test that executes the same code path to mongodb. However when I execute via CherryP…
django mongo engine – DatabaseError: Unknown option auto_start_request
After going into the django shell and creating the following entry: i am not able to use i am getting the following error message My folder structure is as follows: The versions used are: Is there anything i am missing? Can somebody please help me on what the problem is? i am new to django and mongodb. I am n…
Setting up MongoDB + Django
I am new to Mongo DB and Django. I’ve been trying to use Mongo DB as my primary Database for Django. I’ve installed MongoDB and Django-nonrel as per the following link: Django – MongoDB setup The version of django-nonrel, i am using is 1.7. Clone link to it: pip install git+https://github.co…
How to connect to Mongo database locally using python
I am using ipython 2.7. I am creating database name enron in mongodb. I have tried to connect to this database locally but the following error occurred – how do I fix it? this my code: error: Answer Refer this PyMongo Connection to connect and Connection is deprecated
TypeError: ObjectId(”) is not JSON serializable
My response back from MongoDB after querying an aggregated function on document using Python, It returns valid response and i can print it but can not return it. Error: Print: But When i try to return: It is RESTfull call: db is well connected and collection is there too and I got back valid expected result b…
How to make a combined set of fields unique in Mongodb in Python
I want to create a table where two of its fields combine to form an index field. My Python code for creating the table is as follows. What I want to do is make the combined fields course_name and group_name unique so that no two groups with the same course_name and group_name can be created. Can someone pleas…
Removing _id element from Pymongo results
I’m attempting to create a web service using MongoDB and Flask (using the pymongo driver). A query to the database returns documents with the “_id” field included, of course. I don’t want to send this to the client, so how do I remove it? Here’s a Flask route: This returns: I tho…
Map Reduce on timestamps
Mongodb Database: How can I Map-Reduce or aggregate on the above data to generate an output as: I am trying to write some code but its difficult to average on unsorted dates. Are there any built in functions averaging on time to do this? Answer You could do min/max on the dates like described here for numbers…