Django动态获取mysql连接_根据django中的请求动态设置数据库

I am writing a multi-tenant application with python-django.

I want to set database connection based on each request.I thought i could write a middleware where we set the database to be used for that particular database.

import re

from django.db import connections

class SetTenantDatabase(object):

def process_request(self, request):

pattern = re.compile("\\b(http://|https://|www.|.com|8000|:|//)\\W\\d+", re.I)

words = request.get_host()

db_name = [pattern.sub("", words)][0].split('.')[0]

connections.databases['new-alias'] = {

'default': {

'ENGINE': 'django.db.backends.postgresql_psycopg2',

'NAME'