Finding empty records in Mongodb using pymongo

Question

I have a Mongo database storing information about some weather stations. For example:

{ 
    "_id" : ObjectId("5ae052a739027d186162ed50"), 
    "src_id" : NumberInt(55844), 
    "Name" : "ABERDEEN: NIGG HEAD WORKS", 
    "Area" : "ABERDEENSHIRE", 
    "Area type" : "COUNTY", 
    "Station start date" : ISODate("1997-03-01T00:00:00.000+0000"), 
    "Station end date" : null, 
    "Postcode" : "AB12", 
    "loc" : {
        "type" : "Point", 
        "coordinates" : [
            -2.06163, 
            57.1318
        ]
    }
}

In order to find the records with empty "Station end date" I do the following query in Mongodb and it works:

db.MIDAS_stations.find({
    "Station end date" : null
})

However, using pymongo I tried without success. In theory, this should work, but it doesn't:

returned_location = db.MIDAS_stations.find(
    {
        "Station end date" : None
    }
)
print(list(returned_location))

It always returns an empty result. Any ideas of how can this be sorted?

Works for me. Just inserted your document and even used the same collection name and copied the query from here. Returns the document without a problem. You are probably in the wrong database namespace. — Neil Lunn
– Neil Lunn, Commented Apr 25, 2018 at 12:22
I just noticed I was connected to the same database but with different content. The code is working fine. I should sleep more. — Jumy Elerossë
– Jumy Elerossë, Commented Apr 25, 2018 at 12:26

Jumy Elerossë · Accepted Answer · 2018-04-25 12:27:44Z

1

The code works just fine. The problem was that I was connected to a different database, containing the data before it was prepared. Shame on me.

answered Apr 25, 2018 at 12:27

Jumy Elerossë

1892 gold badges3 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Finding empty records in Mongodb using pymongo

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related