为每个客户端创建PostgreSQL数据库，在单个Django应用程序和同一服务器上创建客户端时自动迁移

# settings.py
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'default_db',
        'USER': 'default_user',
        'PASSWORD': 'default_password',
        'HOST': 'localhost',
        'PORT': '5432',
    },
    'client_db_1': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'client_db_1',
        'USER': 'client_user_1',
        'PASSWORD': 'client_password_1',
        'HOST': 'localhost',
        'PORT': '5432',
    },
    # 可以继续添加更多客户端数据库配置
}

import psycopg2
from django.conf import settings

def create_client_database(client_id):
    db_name = f'client_db_{client_id}'
    db_user = f'client_user_{client_id}'
    db_password = f'client_password_{client_id}'
    
    conn = psycopg2.connect(
        dbname=settings.DATABASES['default']['NAME'],
        user=settings.DATABASES['default']['USER'],
        password=settings.DATABASES['default']['PASSWORD'],
        host=settings.DATABASES['default']['HOST'],
        port=settings.DATABASES['default']['PORT']
    )
    
    cur = conn.cursor()
    cur.execute(f'CREATE DATABASE {db_name}')
    cur.execute(f'CREATE USER {db_user} WITH PASSWORD \'{db_password}\'')
    cur.execute(f'GRANT ALL PRIVILEGES ON DATABASE {db_name} TO {db_user}')
    conn.commit()
    cur.close()
    conn.close()
    
    # 更新Django数据库配置
    settings.DATABASES[db_name] = {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': db_name,
        'USER': db_user,
        'PASSWORD': db_password,
        'HOST': settings.DATABASES['default']['HOST'],
        'PORT': settings.DATABASES['default']['PORT'],
    }

from django.core.management import call_command

def migrate_client_database(client_id):
    db_name = f'client_db_{client_id}'
    settings.DATABASES['default'] = settings.DATABASES[db_name]
    call_command('migrate', database=db_name)