当前位置：文江博客话题详情

使用 Django ORM 按日期对对象进行排序和分组

发布于 2024-08-20 02:23:32 字数 188 浏览 7 评论 0原文

我有一个带有日期字段的文章模型。我想查询所有 Article 对象，并返回每个不同年份的数据类型，然后返回其中每个不同的月份。

例如

<代码> 档案={ 2009: {12, [, , ...], 11: [...]}, 2008：{12，[...]，11：[...]}， }

这可能吗？

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

尬尬 2024-08-27 02:23:32

这类问题似乎经常出现。最简单的解决方案是循环访问数据并按年份和月份对对象进行分组。您可以在视图中手动执行此操作或使用 regroup 在您的模板中。这实际上取决于您想对数据做什么。

如果在应用程序中按年和月对档案进行分组是很常见的事情，那么您可能需要考虑创建在 save() 上填充的年和月字段。

手动它可能是这样的：

arch = {}
for a in Archive.objects.all():
    year = arch.get(a.pub_date.year, {})
    month = year.get(a.pub_date.month, [])
    month.append(a)
    year[a.pub_date.month] = month
    arch[a.pub_date.year] = year

或者使用 regroup（未经测试）：

{% regroup archives by pub_date.year as year_list %}
{% for year in year_list %}
  Year: {{ year.grouper }}
  {% regroup year.list by pub_date.month as month_list %}
  {% for month in month_list %}
    Month: {{ month.grouper }}
    {% for archive in month.list %}
      {{ archive }}
    {% endfor %}
  {% endfor %}
{% endfor %}

我个人会尝试将逻辑放在视图中而不是模板中。

以下是一些相关帖子：

This sort of question seems to come up fairly often. The easiest solution is to loop through the data and group the objects by year and month. You can do this by hand in the view or using regroup in your template. It really depends on what you want to do with the data.

If grouping Archives by year and month is a very common thing for you to do in your application, you might want to consider creating a year and month field that you populate on save().

By hand it could be something like this:

arch = {}
for a in Archive.objects.all():
    year = arch.get(a.pub_date.year, {})
    month = year.get(a.pub_date.month, [])
    month.append(a)
    year[a.pub_date.month] = month
    arch[a.pub_date.year] = year

Or pushing all the grouping logic into the template using regroup (untested):

{% regroup archives by pub_date.year as year_list %}
{% for year in year_list %}
  Year: {{ year.grouper }}
  {% regroup year.list by pub_date.month as month_list %}
  {% for month in month_list %}
    Month: {{ month.grouper }}
    {% for archive in month.list %}
      {{ archive }}
    {% endfor %}
  {% endfor %}
{% endfor %}

I would personally try to put the logic in the view instead of in the template.

Here are a few related posts:

回复收藏 0 原文