How to pass 'using' DB to the django connection object

user_651174 0
Viewed 4580

To query a specific database in django I can do:

Item.objects.using('specific_db').all()

Is there a way to do the same using a django connection? For example:

>>> from django.db import connection
>>> cursor=connection.using('specific_db').cursor()

If not, how could I get a cursor/connection for a specific DB without manually providing all the credentials?

django python
1 Answers

According the the django documentation on Using raw SQL on multiple databases, you would use connections rather than connection:

from django.db import connections
cursor = connections['specific_db'].cursor()
cursor.execute("select * from item")
user_6511740
Related