Django，带有原始sql的多个数据库.如何选择分贝? [英] Django, multiple databases with raw sql. How to choose db?

问题描述

我有一个利用多个数据库的Django项目. https://docs.djangoproject.com/en/dev/topics/db/multi-db/

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?

推荐答案

在

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")

然后使用

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

这篇关于Django，带有原始sql的多个数据库.如何选择分贝?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！