參考 django 中如何進(jìn)行分組統(tǒng)計映胁？

from django.test import TestCase

# Create your tests here.

'''
https://www.v2ex.com/t/466327
如果你的 Model 定義了默認(rèn)排序字段, 必須要加 order_by()

'''
import os

if __name__ == '__main__':
    os.environ.setdefault("DJANGO_SETTINGS_MODULE", "hey_star.settings")
    import django

    django.setup()

    from light.models import Light
    from django.db.models import Count

    # 新增歸檔字段查詢
    # 比如查詢 xxxx年x月發(fā)布的所有產(chǎn)品
    res = Light.objects.extra(
        select={"update_ym": "date_format(update_time, '%%Y-%%m-%%d')"}
    ).values("update_ym").annotate(c=Count("id")).values("update_ym", "c").order_by("update_ym")
    print(res)

Light的model 部分

class Light(models.Model):
    """
    燈具
    """
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    item_no = models.CharField(max_length=50, unique=True, verbose_name="編號")
    name = models.CharField(max_length=100, verbose_name="名稱", null=True, blank=True)
    fob_ningbo_USD = models.CharField(max_length=20, verbose_name="FOB寧波(USD)")
    quotation_image = models.ImageField(upload_to="light/image", verbose_name="報價圖片", null=True, blank=True)

    desc = RichTextUploadingField(verbose_name="產(chǎn)品具體描述")
    first_packing = models.CharField(max_length=50, verbose_name="第一包裝尺寸(CM)")
    gross_weight = models.CharField(max_length=50, verbose_name="毛重(KG)")
    second_packing = models.CharField(max_length=50, verbose_name="第二包裝尺寸(CM)")
    pks_qty = models.CharField(max_length=20, verbose_name="裝箱數(shù)(PCS)", help_text="第二包裝需要多少個第一包裝")
    moq = models.CharField(max_length=20, verbose_name="MOQ(PCS)", help_text="最小起訂量")

    is_new = models.BooleanField(default=False, verbose_name="是否新品")
    is_hot = models.BooleanField(default=False, verbose_name="是否熱銷")
    category = models.ForeignKey(LightCategory, on_delete=models.CASCADE, verbose_name="分類")
    add_time = models.DateTimeField(auto_now_add=True, verbose_name="添加時間")
    update_time = models.DateTimeField(auto_now=True, verbose_name="修改時間")

    class Meta:
        verbose_name = "燈具"
        verbose_name_plural = verbose_name
        ordering = ['-add_time']

    def __str__(self):
        return self.item_no

    def picture_img(self):
        if self.quotation_image:
            return mark_safe('<img src="%s" width="100px" />' % self.quotation_image.url)
        else:
            return '沒有圖片'

    picture_img.short_description = '縮略圖'

    def delete(self, using=None, keep_parents=False):
        if os.path.isfile(self.quotation_image.path):
            os.remove(self.quotation_image.path)
        super(Light, self).delete(using, keep_parents)

    # 自定義 get_absolute_url 方法
    # 記得從 django.urls 中導(dǎo)入 reverse 函數(shù)
    def get_absolute_url(self):
        # return reverse("light:light-detail", kwargs={"pk": self.pk})
        # return reverse("light:thank_you")
        return reverse("light:light-detail", args=[str(self.id)])