Querying in mongoexport through python

Question

Can Anyone explain how to export the result of a query with mongoexport inside a program in python ?

os.system('mongoexport -d fintapp -c portfolio --csv --fields userid,budget --query {"budget":{$exists:True}} -o fulbudg.csv')

Answer 1

Use subprocess

import subprocess


subprocess.call("mongoexport --db db_name --collection collection_name --out output_fileName.csv type csv --fields name_of_columns", shell = True)

Answer 2

os.system('''mongoexport -d fintapp -c portfolio --csv --fields userid,budget --query '{"budget":{$exists:True}}' -o fulbudg.csv''')

You need quotations around the query, and they have to be different from the other quotations you have used. In python there are 4 different ways of quoting: 'quote', "quote", '''quote''', """quote"""