how to use mongodbexport in python or shell script

Question

i want to create a json output from mongodb by mongodbexport

it act correctly in terminal by this command :

sudo mongoexport --db mydb --collection url_db --query '{"state": "processed"}' --out /mongodb_json/name.JSON

but how can i use it in a shell script or in a python by subprocess.call

i use this code in python :

call(["mongoexport", "--db","mydb","--collection","url_db","--query","'{\"state\": \"processed\"}'","--out ",outfile],shell=True)

but it create this error: "no collection specified!" ,"Export MongoDB data to CSV, TSV or JSON files."

thank you

Martin Konecny · Accepted Answer · 2014-06-08 04:58:53Z

4

If you are passing your arguments in via a list, you need to remove the shell = True argument, otherwise only the first element of the list is used to construct your subprocess call (in this case only mongoexport is called)

call(["mongoexport", "--db","mydb","--collection","url_db","--query","'{\"state\": \"processed\"}'","--out ",outfile])

You only use shell = True when you're passing your command as a string not a list

call("mongoexport --db mydb --collection url_db --query '{\"state\": \"processed\"}' --out " + outfile, shell=True)

answered Jun 8, 2014 at 4:58

Martin Konecny

59.9k20 gold badges144 silver badges159 bronze badges

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

Collectives™ on Stack Overflow

how to use mongodbexport in python or shell script

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