How can I get data from a mongodb collection using pymongo in django using get method?

Question

I have one mongodb database and I have connected that db with pymongo in django. I am new to django, I am trying to get if the entered data present in the collection or not, if present return that record using get method

import pymongo
from pymongo import MongoClient
db_name = 'student_db'
client = MongoClient('localhost', 27017)
db_obj = client[db_name]
collection=db_obj['mongo_app_student']

@api_view(['GET'])
def test(request):
    data = request.data
    for x in collection.find():
        if data in x:
            print('entered a right value')
            return Response(data)

TypeError at /test unhashable type: 'dict'

I am getting this error when i am trying to get the output in postman. please help

Mousse · Accepted Answer · 2019-06-14 13:16:25Z

1

First you Should use a POST request for that and since find() return a cursor, you're trying to iterate on a cursor. I'm not sure that's a good idea. And assuming request.data is a dict() try using == for comparison with x
Also Try casting what you get from mongo in a list like this :

import pymongo
from pymongo import MongoClient
db_name = 'student_db'
client = MongoClient('localhost', 27017)
db_obj = client[db_name]
collection=db_obj['mongo_app_student']

@api_view(['GET', 'POST'])
def test(request):
    response_data = None
    if request.method == 'POST':
        for x in list(collection.find()):
            if data == x:
                print('entered a right value')
                response_data = data
    return Response(response_data )

Let me know how it goes.

edited Jun 14, 2019 at 13:16

answered Jun 14, 2019 at 11:59

Mousse

1581 silver badge11 bronze badges

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

10 Comments

AJ Chowdary Over a year ago

Now I am getting this error:Expected a Response, HttpResponse or HttpStreamingResponse to be returned from the view, but received a <class 'NoneType'>

Mousse Over a year ago

Yes the return statement shouldn' t be in the if statement. I've updated my answer above, try that out and let me know how it goes

AJ Chowdary Over a year ago

Thanks! this working pretty good but when running this server on postman, I am giving key=data, Value={'firstname':'Abburi'}. I am not getting anything like I have firstname:Abburi lastname:jagadeesh student_id:1 in my collection

Mousse Over a year ago

Hum, are you trying to send a data like {"firstname":"Abburi", "lastname":"jagadeesh"} and you want your service to check if that exist in mongo ? if yes return that same data ?

AJ Chowdary Over a year ago

Exactly if that present return me that doccument/row

|

Collectives™ on Stack Overflow

How can I get data from a mongodb collection using pymongo in django using get method?

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related