Django订单处理中如何避免同一客户重复添加相同地址？

问题背景 #

订单处理时需要为客户记录独立于ShippingAddress的Address地址，要求同一客户的相同地址仅创建一次，但当前代码在客户使用相同地址下单时会重复生成Address记录。

核心问题 #

当前视图中创建Address时直接调用Address.objects.create()，未检查该客户是否已存在完全匹配的地址，导致每次下单都会新增一条重复记录。

解决方案 #

方法一：使用get_or_create()（推荐） #

Django内置的get_or_create()方法会先尝试查询符合条件的记录，不存在则自动创建，完美适配需求。修改视图中创建Address的代码：

if order.shipping == True:
    # 保存关联订单的ShippingAddress（这部分保留，因为每个订单需独立记录配送地址）
    ShippingAddress.objects.create(
        customer=customer,
        order=order,
        house=data['shipping']['house'],
        street=data['shipping']['street'],
        city=data['shipping']['city'],
        postcode=data['shipping']['postcode'],
    )
    # 用get_or_create避免重复创建客户地址
    address, created = Address.objects.get_or_create(
        customer=customer,
        house=data['shipping']['house'],
        street=data['shipping']['street'],
        city=data['shipping']['city'],
        postcode=data['shipping']['postcode'],
    )

方法二：先查询再判断（适合需额外逻辑的场景） #

如果需要更精细的流程控制，可以先查询地址是否存在，不存在再执行创建：

if order.shipping == True:
    ShippingAddress.objects.create(
        customer=customer,
        order=order,
        house=data['shipping']['house'],
        street=data['shipping']['street'],
        city=data['shipping']['city'],
        postcode=data['shipping']['postcode'],
    )
    # 检查当前客户是否已存在该地址
    address_exists = Address.objects.filter(
        customer=customer,
        house=data['shipping']['house'],
        street=data['shipping']['street'],
        city=data['shipping']['city'],
        postcode=data['shipping']['postcode'],
    ).exists()
    if not address_exists:
        Address.objects.create(
            customer=customer,
            house=data['shipping']['house'],
            street=data['shipping']['street'],
            city=data['shipping']['city'],
            postcode=data['shipping']['postcode'],
        )

额外优化建议 #

为避免因输入格式（如大小写、多余空格）导致的隐性重复，可做以下优化：

1. 添加数据库级唯一约束 #

修改Address模型，确保同一客户的地址组合唯一：

class Address(models.Model):
    house = models.CharField(max_length=255)
    street = models.CharField(max_length=255)
    city = models.CharField(max_length=255)
    postcode = models.CharField(max_length=25)
    customer = models.ForeignKey(Customer, on_delete=models.CASCADE)

    class Meta:
        # 联合唯一约束：同一客户的地址字段组合不可重复
        unique_together = ('customer', 'house', 'street', 'city', 'postcode')

    def __str__(self):
        return f'用户名: {self.customer.user} - 姓名: {self.customer.first_name} {self.customer.last_name}'

2. 统一地址字段格式（可选） #

在保存前对地址字段做格式化处理，消除输入差异：

# 预处理地址字段：去除空格、统一大写
house = data['shipping']['house'].strip().upper()
street = data['shipping']['street'].strip().upper()
city = data['shipping']['city'].strip().upper()
postcode = data['shipping']['postcode'].strip().upper()

# 使用格式化后的字段执行查询/创建
address, created = Address.objects.get_or_create(
    customer=customer,
    house=house,
    street=street,
    city=city,
    postcode=postcode,
)

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