How do I sort in Collection.find_one_and_update?

[tyteen4a03]

I have the following code:

        next_job = yield self.scrapers_coll.find_one_and_update(
            {"state": "enqueued"},
            {
                "$set": {
                    "startTime": time.time(),
                }
            },
            sort=[("createdOn", pymongo.ASCENDING)]
    )

This gives me a TypeError: list indices must be integers or slices, not str.

From going through the source code it looks like TxMongo wants a different format than PyMongo. How do I specify the sort order in this case?

[IlyaSkriblovsky]

Yes, txmongo has its own syntax for sort, hint and other query options:

from txmongo import filter

next_job = yield self.scrapers_coll.find_one_and_update(
    {"state": "enqueued"},
    {
        "$set": {
            "startTime": time.time(),
        }
    },
    sort=filter.sort(filter.ASCENDING("createdOn"))
)

This way you can sort by multiple fields:

filter.sort(filter.ASCENDING("priority") + filter.ASCENDING("createdOn"))

[tyteen4a03]

Any plans to update the code to support standard pymongo syntax too?

[IlyaSkriblovsky]

actually, sort= can also be specified like this:

    sort=filter.sort(["createdOn", pymongo.ASCENDING])

Which is almost like in pymongo except wrapping with filter.sort