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>"

score 1 · Accepted Answer · answered Feb 20 '20 at 03:01

1

it can be extracted in one line

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

answered Feb 20 '20 at 03:01

venkata krishnan

1,961
1
13
20

It works but I get: "orders": [ "IHZXMZQ3SX", "eu8j35tvoO" ] – mtz_federico Feb 20 '20 at 03:08
you wanted a list right ? and the list has all the order id's right ? or did i misread the question ? – venkata krishnan Feb 20 '20 at 03:46
1

It gets the job done, but I need to remove the extra characters – mtz_federico Feb 20 '20 at 04:27
maybe you need to learn the string method join, as in ','.join(['a','b','c']) – electrogas Feb 20 '20 at 05:34
Do as above and then https://stackoverflow.com/questions/44778/how-would-you-make-a-comma-separated-string-from-a-list-of-strings – Belly Buster Feb 20 '20 at 11:32
hey, I am using this method but when I add it twice (two lists for two values) the second one is empty. if I comment the one on top the second one works. How can I fix this? – mtz_federico Mar 07 '20 at 23:46
can you elaborate ? may be some example will do.? – venkata krishnan Mar 09 '20 at 01:41
If I add orderNames = [x['ordername'] for x in mydoc] and orders = [x['orderid'] for x in mydoc] one on top of the other orderNames gets the values from mongodb and orders is empty (i.e. orders = []) – mtz_federico Mar 11 '20 at 02:14
yes.. it's because the cursor moved forward. before using orders = [...], use mydoc.rewind() to reset the cursor to initial position – venkata krishnan Mar 11 '20 at 03:46

converting mongodb values in query to a string in python

1 Answers1