Display only games with >2 hours of playtime on stats page #81

New Issue

lukas · 2025-01-29T11:45:14Z

lukas commented

2025-01-29 11:45:14 +00:00

Something like this:

json_dumps(
    list(
        Game.objects.filter(edition__purchase__session__timestamp_start__year=2024)
        .annotate(
            total_playtime=Sum(
                F("edition__purchase__session__duration_calculated")
                + F("edition__purchase__session__duration_manual"),
                output_field=DurationField(),
            ),
            total_playtime_hours=ExpressionWrapper(
                F("total_playtime") / timedelta(hours=1), output_field=IntegerField()
            ),
        )
        .values("name", "total_playtime_hours")
        .filter(total_playtime__gt=timedelta(hours=2))
        .order_by("-total_playtime_hours")
    )
)

Something like this: ```py json_dumps( list( Game.objects.filter(edition__purchase__session__timestamp_start__year=2024) .annotate( total_playtime=Sum( F("edition__purchase__session__duration_calculated") + F("edition__purchase__session__duration_manual"), output_field=DurationField(), ), total_playtime_hours=ExpressionWrapper( F("total_playtime") / timedelta(hours=1), output_field=IntegerField() ), ) .values("name", "total_playtime_hours") .filter(total_playtime__gt=timedelta(hours=2)) .order_by("-total_playtime_hours") ) ) ```

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: lukas/timetracker#81