checking if a value exists in mongodb collection using pymongo

Question

I have a a mongo db table in the following format

    [{"url":"www.example1.com", "name":"hans","age":30},
    {"url":"www.example2.com", "name":"x","age":34},
    {"url":"www.example3.com", "name":"y","age":35},
    {"url":"www.example4.com", "name":"z","age":36},
    {"url":"www.example5.com", "name":"b","age":37}]

I have two tables where i need to check for under two if conditions. I did in the following way

    val = "www.example1.com"
    if list(table1.find({"url": {"$eq": val}})):
        print("exist in table 1")
        if list(table2.find({"url": {"$eq": val}})):
            print("exist in table 2")
        else:
            print("not exist in table 2")
    else:
        print("not exist in table 1")

This gives me correct response but it seems to take more time in doing the check. Is there a better way to do this query using pymongo

Answer 1

I'd do it with findOne:

    val = "www.example1.com"
    if table1.find_one({"url": {"$eq": val}}):
        print("exist in table 1")
        if table2.find_one({"url": {"$eq": val}}):
            print("exist in table 2")
        else:
            print("not exist in table 2")
    else:
        print("not exist in table 1")

Which is much simpler than find() and fine_one() returns an element if found or None and not a cursor like find()