如何通过Django ModelForm将Customer实例保存至非默认数据库db2？

Got it, let's tackle this problem step by step. The core issue here is that your CustomerCreateForm is using Django's default database (db1) for both validation and instance handling, but your Customer model only exists in db2. Here's how to fix this properly while keeping the ModelForm workflow:

1. Add a Database-Specific Manager to Your Customer Model #

First, we need to create a manager for the Customer model that explicitly uses db2. This will let the ModelForm use the correct database during validation (which is why your is_valid() call was failing).

from django.db import models

class Customer(models.Model):
    name = models.CharField(max_length=100)
    type = models.CharField(max_length=20)
    date_joined = models.DateTimeField()

    # Define a manager that connects to db2
    db2_objects = models.Manager(using='db2')
    # Keep the default manager if you still need access to db1 (optional)
    # objects = models.Manager()

2. Modify the ModelForm to Use the db2 Manager #

Next, override the _get_manager method in your CustomerCreateForm. This tells the form to use our db2-specific manager for all validation operations, so it won't try to check db1 anymore. We can also handle the date_joined field directly in the form's save method to keep things clean:

from django.forms import ModelForm
from .models import Customer
from datetime import datetime

class CustomerCreateForm(ModelForm):
    class Meta:
        model = Customer
        fields = ["name", "type"]

    def _get_manager(self):
        # Force the form to use our db2 manager for validation
        return self._meta.model.db2_objects

    def save(self, commit=True):
        # Get the unsaved instance
        instance = super().save(commit=False)
        # Set the date_joined field
        instance.date_joined = datetime.now()
        
        if commit:
            # Save the instance to db2 explicitly
            instance.save(using='db2')
            # If your model has many-to-many fields, uncomment this line:
            # self.save_m2m(using='db2')
        
        return instance

3. Update Your View Logic #

Now your view can use the form normally—no extra hoops needed, since the form handles the database routing internally:

from django.shortcuts import render
from .forms import CustomerCreateForm

def create_customer(request):
    if request.method == 'POST':
        if "create" in request.POST:
            form = CustomerCreateForm(data=request.POST)
            if form.is_valid():
                # The form will save directly to db2
                customer = form.save()
                # Handle success (e.g., redirect or show a success message)
                return render(request, 'success.html', {'customer': customer})
    else:
        form = CustomerCreateForm()
    
    return render(request, 'create_customer.html', {'form': form})

Why This Works #

• The _get_manager override ensures that when is_valid() runs, the form uses the db2 manager to check constraints (like uniqueness) against the correct database.
• The custom save method sets your date_joined field and explicitly saves the instance to db2, avoiding any default database routing issues.

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