Django -使用多个连接计算平均分数

# settings.py
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'database1',
        'USER': 'username1',
        'PASSWORD': 'password1',
        'HOST': 'localhost',
        'PORT': '3306',
    },
    'second_db': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'database2',
        'USER': 'username2',
        'PASSWORD': 'password2',
        'HOST': 'localhost',
        'PORT': '3306',
    }
}

# models.py
from django.db import models

class Score(models.Model):
    name = models.CharField(max_length=100)
    score = models.IntegerField()
    connection = models.CharField(max_length=100)

# views.py
from django.db.models import Avg
from .models import Score

def calculate_average_score(request):
    average_score_db1 = Score.objects.filter(connection='default').aggregate(Avg('score'))
    average_score_db2 = Score.objects.filter(connection='second_db').aggregate(Avg('score'))
    
    return {
        'average_score_db1': average_score_db1,
        'average_score_db2': average_score_db2
    }