django中的多数据库支持 [英] Multiple database support in django

问题描述

从某个论坛，我了解到在较低级别的Django中添加了多个数据库支持，但尚未添加更高级别的api。

From some forum I came to know that Multiple database support is added in Django at lower level, but the higher level apis are not added yet.

任何人都可以告诉我如何在Django中实现多个数据库连接。

Can anyone please tell me how one can achieve multiple database connections in Django.

当Django完全/正式支持多个数据库连接时，是否有任何想法。

Does anyone have any idea by when Django will fully/officially support Multiple database connections.

推荐答案

如果你只需要多个连接，你可以这样做：

If you simply need multiple connections, you can do something like this:

from django.db import load_backend
myBackend = load_backend('postgresql_psycopg2') # or 'mysql', 'sqlite3', 'oracle'
myConnection = myBackend.DatabaseWrapper({
    'DATABASE_HOST': '192.168.1.1',
    'DATABASE_NAME': 'my_database',
    'DATABASE_OPTIONS': {},
    'DATABASE_PASSWORD': "",
    'DATABASE_PORT': "",
    'DATABASE_USER': "my_user",
    'TIME_ZONE': "America/New_York",})
# Now we can do all the standard raw sql stuff with myConnection.
myCursor = myConnection.cursor()
myCursor.execute("SELECT COUNT(1) FROM my_table;")
myCursor.fetchone()

这篇关于django中的多数据库支持的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！