How to select database in django db collection custom query?

Question

I have two databases in my django application. One is default and another is secondary. When I tried the following code it always returns data from the default database.

from django.db import connection

def my_custom_sql(self):

cursor = connection.cursor()

cursor.execute("SELECT * FROM accounts_account where id=%s", [self.id])

row = cursor.fetchall()

return row

I want to execute the query in second database.

Possible duplicate of Django, multiple databases with raw sql. How to choose db? — ohannes
– ohannes, Commented Jul 24, 2017 at 19:53
the accepted solution worked for me, and then I ran into issues with breaking unit tests... this fixed the issue, but ran quite slowly docs.djangoproject.com/en/4.2/topics/testing/advanced/… (I ultimately ended up using app config to specify which database to use per env) — frederj
– frederj, Commented Sep 5, 2023 at 18:02

MohammadHossein.Sh · Accepted Answer · 2018-06-06 19:12:39Z

1

you just need to

from django.db import connections

instead of

from django.db import connection

and use your database alias as below:

cursor = connections['secondry_db'].cursor()

answered Jun 6, 2018 at 19:12

MohammadHossein.Sh

501 gold badge1 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

How to select database in django db collection custom query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related