pymongo specify variable in connection string

Question

I am using pymongo to connect to my mongodb database. I am trying to call the database name and collection name in the connection string but I can't figure it out.

If I have a database name (mydb) and a collection named (mycol) this example works:

con = Connection('mymongodbhost')
d = con.mydb.mycol.find_one()
print (d)

That works fine but lets say I am defining mydb and mycol as variables, how do I call them in the connection string. So lets say I have:

db = parser.get('some_conf_file', 'db_name')
col = parser.get('some_conf_file', 'col_name')

How do I specify the db and col variables (which work that is just a code snippit) in my connection string? I've tried all sorts of combinations, and this certainly doesn't work:

d = con.db.col.find_one()
print (d)

This basically is calling the db (db) and the collection (col). But I want the variable values replaced by db and col in the example above.

Thanks.

JohnnyHK · Accepted Answer · 2012-07-28 03:42:14Z

7

Try this:

d = con[db][col].find_one()

answered Jul 28, 2012 at 3:42

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

1 Comment

Brian Carpio Over a year ago

Thanks. I think I knew that once upon a time :)

blahdiblah · Accepted Answer · 2012-07-28 03:39:08Z

0

You could use:

d = getattr(getattr(con, db), col).find_one()

Though it looks a bit inelegant.

answered Jul 28, 2012 at 3:39

blahdiblah

34.4k21 gold badges102 silver badges154 bronze badges

Collectives™ on Stack Overflow

pymongo specify variable in connection string

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related