Convert Sql query to Mongodb query

Question

i have a query in sql that i want to convert in mongodb with python pymongo.

cursor=execute("select avg(id13)::numeric(10,2) from timestamppsql where timestamp1<='2011-01-01 00:05:00'")

This is the code i tested in mongodb:

cursor=mydb1.mongodbtime.aggregate({
    '$group': {
        "timestamp1":{ "$lte" : datetime.strptime("2011-01-01 00:05:00", "%Y-%m-%d %H:%M:%S") },

        "avg_id13": {"$avg": "$id13"}
    }
})

The output is this:

pipeline must be a list

How can i fix that?Any help would be appreciated.

D. SM · Accepted Answer · 2021-03-11 01:44:14Z

1

The argument to aggregate is an array, not a mapping. Put your mapping into an array.

answered Mar 11, 2021 at 1:44

D. SM

14.6k3 gold badges15 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Convert Sql query to Mongodb query

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