converting mongodb values in query to a string in python

Question

How can I convert the values in the multiple responses from mongodb in python to a string with the values separated by a comma?

I don't know if my question is understandable, basically, this is what I want to do.

I am using this code to get data from mongodb:

    myclient = pymongo.MongoClient("mongodb://localhost:27017/")
    mydb = myclient["mydatabase"]
    driversdb = mydb["orders"]

    ordersQuery = { "city": city }
    mydoc = ordersdb.find(ordersQuery)
    for x in mydoc:

The response is:

{ <more values>, 'orderid': 'IHZXMZQ3SX', <more values> }
{ <more values>, 'orderid': 'eu8j35tvoO', <more values> }
<more data>

how can I convert that to:

orderslist = "IHZXMZQ3SX, eu8j35tvoO, <more orderids>"

venkata krishnan · Accepted Answer · 2020-02-20 03:01:28Z

1

it can be extracted in one line

orderids = [x['orderid'] for x in mydoc]

answered Feb 20, 2020 at 3:01

venkata krishnan

2,0461 gold badge15 silver badges23 bronze badges

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

9 Comments

mtz_federico Over a year ago

It works but I get: "orders": [ "IHZXMZQ3SX", "eu8j35tvoO" ]

venkata krishnan Over a year ago

you wanted a list right ? and the list has all the order id's right ? or did i misread the question ?

mtz_federico Over a year ago

It gets the job done, but I need to remove the extra characters

electrogas Over a year ago

maybe you need to learn the string method join, as in ','.join(['a','b','c'])

Belly Buster Over a year ago

Do as above and then stackoverflow.com/questions/44778/…

|

Collectives™ on Stack Overflow

converting mongodb values in query to a string in python

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related