Dry ORM

Code

Result

no cache

from django.db import models
from django.utils import timezone

class Document(models.Model):
    """Represents a document in the user's mailbox."""

class DocLogEntry(models.Model):
    """Records the most important events in the lifecycle of a document."""

class Event(models.IntegerChoices):
        CREATED = 1, "The `Document` was created."
        FILE_ADDED = 2, "The related file was added."
        DL_REQUESTED = 3, "The document was requested for download."

timestamp = models.DateTimeField(default=timezone.now)
    doc = models.ForeignKey(
        Document, on_delete=models.CASCADE,
        related_name="doc_log_entries",
    )
    event = models.IntegerField(choices=Event)

def run():
    list(Document.objects.alias(
        deleted_doc_log_entries=models.FilteredRelation(
            "doc_log_entries", condition=models.Q(
                doc_log_entries__event=DocLogEntry.Event.DL_REQUESTED
            )
        )
    ).annotate(
        num_reads=models.Count("deleted_doc_log_entries"),
        first_read=models.Min("deleted_doc_log_entries__timestamp"),
    ))

Output

No output.

Queries

Queries Q (0)

No queries.