Python3.6+Django2.0.2调用遗留User数据库遇QuerySet repr获取失败问题

Hey there, let's work through this error you're hitting when connecting to your legacy User database. That unable to get repr for <class 'django.db.models.query.QuerySet'> error usually pops up when Django can't properly interact with the database or your model definition doesn't align with the actual table structure. Let's break down the fixes step by step:

1. 补全遗留数据库的完整配置 #

First off, your legacy_db configuration looks incomplete. MySQL connections require full authentication parameters to work properly. Fill in the missing details like this:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    },
    'legacy_db': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'your_actual_db_name',  # 替换成遗留数据库的真实名称
        'USER': 'your_db_username',      # 数据库登录用户名
        'PASSWORD': 'your_db_password',  # 数据库登录密码
        'HOST': 'localhost',             # 数据库主机，比如localhost或远程IP
        'PORT': '3306',                  # MySQL默认端口，按需修改
    }
}

Also, make sure you've installed the correct MySQL driver for Python 3.6 and Django 2.0.2 — use mysqlclient (the officially supported driver):

pip install mysqlclient==1.3.14  # 这个版本完美适配你的环境

2. 配置数据库路由，标记遗留库为只读 #

Since this legacy database is only written to by external systems and your site never modifies it, you need to tell Django to skip any write operations on it. Create a database router file (e.g., your_app/db_router.py):

class LegacyDBRouter:
    def db_for_read(self, model, **hints):
        # 让User模型从legacy_db读取数据
        if model._meta.app_label == 'your_app_name' and model.__name__ == 'User':
            return 'legacy_db'
        return None

    def db_for_write(self, model, **hints):
        # 绝对禁止往legacy_db写入数据
        if model._meta.app_label == 'your_app_name' and model.__name__ == 'User':
            return None
        return None

    def allow_migrate(self, db, app_label, model_name=None, **hints):
        # 禁止在legacy_db上执行任何迁移操作
        if db == 'legacy_db':
            return False
        return None

Then add this router to your settings.py:

DATABASE_ROUTERS = ['your_app.db_router.LegacyDBRouter']

3. 正确定义适配遗留表的User模型 #

For legacy databases, Django shouldn't manage the table structure — so set managed=False in your model's Meta class, and make sure all fields exactly match the legacy table's schema (including the primary key):

from django.db import models

class User(models.Model):
    id = models.IntegerField(primary_key=True)  # 匹配遗留表的主键字段和类型
    username = models.CharField(max_length=100)  # 按实际表字段定义
    email = models.EmailField(null=True)         # 如果字段允许为空，加上null=True
    # 其他和遗留表对应的字段...

    class Meta:
        db_table = 'your_legacy_user_table_name'  # 替换成真实的表名
        managed = False  # 告诉Django不要创建/修改这个表

Mismatched fields between your model and the actual database table are a common cause of this QuerySet repr error.

4. 排查底层错误 #

If you still get the error after the above steps, run a Django shell to get the real underlying issue:

python manage.py shell
from your_app.models import User
users = User.objects.all()
print(users)  # 这会触发QuerySet的repr，打印出具体的错误信息

Often the repr error hides a more specific issue like permission problems, field type mismatches, or missing required fields.

内容的提问来源于stack exchange，提问作者tina