django读写分离

django读写分离

settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    },
    'db1': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite5'),
    }
}

views.py

from app01.models import User
def index(request):
    # 读从default数据库中读，写数据从db1中写
    ret=User.objects.using('default').all()
    ret=User.objects.using('db1').all()
    print(ret)
    
    # 写入db1数据库
    User.objects.using('db1').create(name="xxxxxx",pwd="444")
    ret=User.objects.all()
    print(ret)
    User.objects.create(name="lqz", pwd="xxxx")

    return HttpResponse("xxx")