基于Django url的多数据库

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'default_db',
        'USER': 'root',
        'PASSWORD': 'password',
        'HOST': 'localhost',
        'PORT': '3306',
    },
    'second_db': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'second_db',
        'USER': 'root',
        'PASSWORD': 'password',
        'HOST': 'localhost',
        'PORT': '3306',
    },
}

from django.urls import path
from . import views

urlpatterns = [
    path('default_db/', views.default_db_view),
    path('second_db/', views.second_db_view),
]

from django.shortcuts import render
from django.db import connections

def default_db_view(request):
    with connections['default'].cursor() as cursor:
        # 使用default_db连接执行数据库操作
        cursor.execute('SELECT * FROM table')
        result = cursor.fetchall()
    
    return render(request, 'default_db.html', {'result': result})

def second_db_view(request):
    with connections['second_db'].cursor() as cursor:
        # 使用second_db连接执行数据库操作
        cursor.execute('SELECT * FROM table')
        result = cursor.fetchall()
    
    return render(request, 'second_db.html', {'result': result})