Dry ORM

Code

Result

no cache

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

class SchoolDetail(models.Model):
    internalSchool = models.BooleanField(default=False)
    inactive = models.BooleanField(default=False)
    nextSession = models.BooleanField(default=False)
    notUsing = models.BooleanField(default=False)
    deleted = models.BooleanField(default=False)
    cancelled = models.BooleanField(default=False)
    notReachable = models.BooleanField(default=False)

class BasicFee(models.Model):
    school = models.ForeignKey(SchoolDetail, on_delete=models.CASCADE)
    startDate = models.DateField()
    endDate = models.DateField()

def run():
    today = timezone.now().date()

s1 = SchoolDetail.objects.create()
    s2 = SchoolDetail.objects.create()
    s3 = SchoolDetail.objects.create(inactive=True)

BasicFee.objects.bulk_create([
        BasicFee(
            school=s1,
            startDate=today - timedelta(days=30),
            endDate=today + timedelta(days=30)
        ),
        BasicFee(
            school=s2,
            startDate=today - timedelta(days=30),
            endDate=today + timedelta(days=30)
        ),
        BasicFee(
            school=s3,
            startDate=today - timedelta(days=10),
            endDate=today + timedelta(days=10)
        ),
    ])

currentAcademicYearIds = BasicFee.objects.filter(
        school__internalSchool=False,
        school__inactive=False,
        school__nextSession=False,
        school__notUsing=False,
        school__deleted=False,
        school__cancelled=False,
        school__notReachable=False,
        startDate__lte=today,
        endDate__gte=today
    ).values_list('id', flat=True)

print("Current Academic Year IDs:", list(currentAcademicYearIds))

Output

No output.

Queries

Queries Q (0)

No queries.