Convert query from sql type in mongodb type

Question

I am working in python with pymongo. I have a query in psql that looks like this :

cursor.execute("select id13 from nc_durhamallwithorder where date2 >='2010-01-01' and date2<='2011-01-01'"),

Now i want to convert that query in mongodb type. I did something like this

cursor=mycol1.find({"$and": [ { "date2": { "$gte": "2010-01-01" } }, { "date2": { "$lte":"2011-01-01" } } ]  } )

This works fine but i want to select only id13

I thought something like this:

cursor=mycol1.find({"id13":1},{"$and": [ { "date2": { "$gte": "2010-01-01" } }, { "date2": { "$lte":"2011-01-01" } } ]  } )

But it doesnt work.Can someone help me?

AlexisG · Accepted Answer · 2021-03-02 17:21:24Z

1

You can use pass a second argument with a dict and the fields you want to keep

mycol1.find({"$and": [ 
        { "date2": { "$gte": "2010-01-01" } }, 
        { "date2": { "$lte":"2011-01-01" } } 
    ]},
    {"id13":1} 
)

edited Mar 2, 2021 at 17:21

answered Mar 2, 2021 at 17:10

AlexisG

2,4943 gold badges13 silver badges25 bronze badges

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

7 Comments

xaroulis gekas Over a year ago

Thank you for your reply.I am executing query with cursor so i did cursor=mycol1.find({"$and": [ { "date2": { "$gte": "2010-01-01" } }, { "date2": { "$lte":"2011-01-01" } } ]} ).fields(id13=1) and the output says :AttributeError: 'Cursor' object has no attribute 'fields'

xaroulis gekas Over a year ago

I edited my question.I only added cursor function

AlexisG Over a year ago

Oh my bad, it's pymongo. I updatef my answer for your package

xaroulis gekas Over a year ago

Now it works great.Thank you!If you have time i want to ask you one more thing.My date2 field is a string type.Why $gte and $lte work fine without date2 being double?

AlexisG Over a year ago

You're welcome. Since the dates are stored year-month-day... In this format, the alphabetical order will be the same as the chronological order.

|

Collectives™ on Stack Overflow

Convert query from sql type in mongodb type

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related