Django 模型按日期时间的日期分组

使用Django模型按日期时间的日期分组

python
from django.db import models
class Post(models.Model):
    title = models.CharField(max_length=100)
    created_at = models.DateTimeField(auto_now_add=True)

python
from datetime import datetime
from django.db.models import Count
# 按天分组查询帖子数量
posts_by_day = Post.objects.dates('created_at', 'day').annotate(count=Count('id'))
# 输出每天的帖子数量
for post in posts_by_day:
    print(f"{post.created_at.strftime('%Y-%m-%d')}: {post.count}")

python
# 按周分组查询帖子数量
posts_by_week = Post.objects.dates('created_at', 'week').annotate(count=Count('id'))
# 输出每周的帖子数量
for post in posts_by_week:
    print(f"Week {post.week}: {post.count}")

python
# 按月分组查询帖子数量
posts_by_month = Post.objects.dates('created_at', 'month').annotate(count=Count('id'))
# 输出每月的帖子数量
for post in posts_by_month:
    print(f"{post.strftime('%Y-%m')}: {post.count}")