Django, multiple databases with raw sql. How to choose db?

Question

I have a Django project that utilizes multiple databases. https://docs.djangoproject.com/en/dev/topics/db/multi-db/

I perform a lot of raw queries like this:

 cursor = connection.cursor() cursor.execute("select * from my_table") .... transaction.commit_unless_managed()

How can I specify which database to use?

Have you tried transaction.commit_unless_managed(using = 'database_entry')? — arulmr
– arulmr, Commented Aug 14, 2013 at 5:49
Nobody has linked to the actual documentation, which is very clear: docs.djangoproject.com/en/dev/topics/db/transactions — Timmy O'Mahony
– Timmy O'Mahony, Commented Aug 14, 2013 at 5:56
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:03

Community · Accepted Answer · 2023-11-17 22:53:53Z

Refer django docs on executing custom query directly. Specify database in your connection as given below:

from django.db import connections cursor = connections['db_alias'].cursor() cursor.execute("select * from my_table") data = cursor.fetchall() for row in data: print(data)

And then commit using

from django.db import transaction transaction.commit_unless_managed(using='db_alias')

This answer is incomplete. It doesn't shown an example of at least one SQL query with the cursor, how the transaction will work, and from where did you got that transaction object. @arulmr
module 'django.db.transaction' has no attribute 'commit_unless_managed' apparently removed in 1.8, quite some time ago.

drabo2005 · Accepted Answer · 2013-08-14 05:55:33Z

try this may be it should works.

from django.db import connections cursor = connections[’my_db_name’].cursor() # Your code here... transaction.commit_unless_managed(using=’my_db_name’)

Collectives™ on Stack Overflow

Django, multiple databases with raw sql. How to choose db?

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related