Django自定义保存模型

Question

我想在Django的保存模型中执行基本的日期计算，代码如下：

  class Purchase(models.Model):
    purchase_date = models.DateField()
    purchase_place = models.CharField(verbose_name='Place of Purchase', max_length=255)
    purchaseCategory = models.ForeignKey(PurchaseCategory, verbose_name='Purchase Category')
    cost = models.DecimalField(max_digits=11, decimal_places=2)
    warranty_period_number = models.IntegerField()
    warranty_period_type = models.CharField(max_length=255, choices=(('m', 'Month(s)'), ('y', 'Year(s)')))
    warranty_end_date = models.DateField(editable=False)
    scan = models.CharField(max_length=255)
    alerts = models.BooleanField(verbose_name='Receive Email Alerts?')
    user = models.ForeignKey('auth.User', editable=False)
    created = models.DateTimeField(editable=False, auto_now_add=True)
    modified = models.DateTimeField(editable=False, auto_now=True)

    #custom save model
    def save(self, *args, **kwargs):
        #figure out warranty end date
        if self.warranty_period_type == 'm':
            self.warranty_end_date = self.purchase_date + self.purchase_date.timedelta(months=self.warranty_period_number)
        else:
            self.warranty_end_date = self.purchase_date + self.purchase_date.timedelta(years=self.warranty_period_number)
        super(Purchase, self).save()

我想以下内容应该可以运行，但没有成功..它会出现错误:

'datetime.date' object has no attribute 'timedelta'

有人能指点我如何做我想做的事吗？

谢谢， Ben

- Ben Kilah

---

从datetime模块中导入timedelta。 - Rizwan Mumtaz

Answer 1

timedelta不支持年份，因此

from datetime import timedelta
# custom save model
def save(self, *args, **kwargs):
    # figure out warranty end date
    if self.warranty_period_type == 'm':
        self.warranty_end_date = self.purchase_date + timedelta(days=self.warranty_period_number*31)
    else:
        self.warranty_end_date = self.purchase_date + timedelta(days=self.warranty_period_number*365.2425)
    super(Purchase, self).save(*args, **kwargs)

参考 Python timedelta in years

- okm

---

有什么想法为什么会出现这个错误：数字字段溢出 详细信息：精度为11，比例为11的字段必须舍入为绝对值小于1的值。 - Ben Kilah

@BenKilah 一个精度为11且小数位为11的数字字段应该小于1，请查看PostgreSQL文档，其原则适用于其他数据库。 - okm