CODEWITHSUNDEEP
pythonmongodbpymongo
Kaushik Makwana
Kaushik Makwana

Reputation: 2576

How to select a single field in MongoDB using Pymongo?

I'm trying to find a record within MongoDB, and filter _id from the result.

Here is my code:

#app.py
@app.route('/login', methods = ['GET', 'POST'])
def login():
    if request.method == "POST":
        password = request.form.get('password')
        email = request.form.get('email')
        db = get_db()
        data = db.author.find_one({'email' : email, 'password' : password})
        print(data)
        return 'data'
    else:
        return render_template('login.html')

Output:

{'password': '123123', 'name': '<my_name>', 'email': '<my_email>', '_id': ObjectId('<an_object_id_string>')}

How do I filter the _id field from the output?

Upvotes: 23

Views: 41909

Answers (3)

PrabhuPrakash
PrabhuPrakash

Reputation: 261

it is the best way for avoiding id,

data = db.author.find_one({'email' : email, 'password' : password},{"password":1, "email":1, "name":1,"_id": False})

now you got ANSWER "{'password': '123123', 'name': 'prakash', 'email': '[email protected]'}"(without id)

Upvotes: 8

slomek
slomek

Reputation: 5136

You need to pass the second object in your query. First parameter is a select clause, whereas the second one is a projection.

See MongoDB docs for details: https://docs.mongodb.org/manual/tutorial/project-fields-from-query-results/

Upvotes: 4

Sede
Sede

Reputation: 61225

You need to specify the field you want to return using projection.

data = db.author.find_one({'email' : email, 'password' : password}, {'_id': 1})

Upvotes: 35

Related Questions