How can I filter MongoDB Database from Pymongo in Flask App?

Question

I am trying to query my database passing as a parameter a string. Some days ago it worked, but suddenly it stopped working. Is there something wrong I am missing?

class Hotel(Resource):
      
  def get(self, cityName):
  
      docs_list  = list(client['mongodbhotels']['wheather_conditions'].find( 
        filter = {
          'name': { "$eq" : cityName} 
          },
        allow_partial_results = True )
        )

      json_response = json.dumps(docs_list, default=json_util.default)
      return json.loads(json_response)

api.add_resource(HotelList, '/')
api.add_resource(Hotel, '/<string:cityName>')


if __name__ == '__main__':
    app.run(debug=True)

I am expecting a url like this with my parameter (city name) http://127.0.0.1:5000/Madrid

This query was working but now it returns an empty value

Does it work if filter = { 'name': cityName }?

rickhg12hs
– rickhg12hs

2022-03-30 16:45:05 +00:00
Commented Mar 30, 2022 at 16:45 — rickhg12hs
– rickhg12hs, Commented Mar 30, 2022 at 16:45

Abdul Haq · Accepted Answer · 2022-05-02 01:20:00Z

1

Have you tried this ?

class Hotel(Resource):
      
  def get(self, cityName):
  
      docs_list  = list(client['mongodbhotels']['wheather_conditions'].find( 
        filter = {
          'name': cityName
          },
        allow_partial_results = True )
        )

      json_response = json.dumps(docs_list, default=json_util.default)
      return json.loads(json_response)

api.add_resource(HotelList, '/')
api.add_resource(Hotel, '/<string:cityName>')


if __name__ == '__main__':
    app.run(debug=True)```

answered May 2, 2022 at 1:20

Abdul Haq

621 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

How can I filter MongoDB Database from Pymongo in Flask App?

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