Dry ORM

Code

Result

no cache

from django.db import models

class CalculationTaskStatus(models.TextChoices):
    PENDING = "pending"
    STARTED = "started"
    FAILED = "failed"
    SUCCESS = "success"
    REVOKED = "revoked"

class CalculationTask(models.Model):
    name = models.CharField(max_length=100)
    status = models.CharField(max_length=20, choices=CalculationTaskStatus.choices)
    in_queue = models.GeneratedField(
        expression=models.Case(
            models.When(status__in=[CalculationTaskStatus.PENDING, CalculationTaskStatus.STARTED], then=models.Value(True)),
            default=models.Value(False),
            output_field=models.BooleanField(),
        ),
        output_field=models.BooleanField(),
        db_persist=True
    )

class Meta:
        verbose_name = "Calculation Task"

def run():
    CalculationTask.objects.create(name="Task A", status=CalculationTaskStatus.PENDING)
    CalculationTask.objects.create(name="Task B", status=CalculationTaskStatus.STARTED)
    CalculationTask.objects.create(name="Task C", status=CalculationTaskStatus.SUCCESS)

for task in CalculationTask.objects.all():
        print(f"{task.name}: {task.status} → in_queue={task.in_queue}")

Output

No output.

Queries

Queries Q (0)

No queries.