Menene QuerySets kuma ta yaya suke da rashin aiki (laziness)?

Question

Accepted Answer

A **QuerySet** yana wakiltar tarin layukan sitima a matsayin abin Python wanda kake iya tacewa, umurnawa, da haɗawa. Siffar da ta fi mahimmanci ita ce **rashin aiki (laziness)** — QuerySet bai buge sitima ba lokacin da aka gina shi; yana aiwatar da bugun ajiya ne kawai lokacin da aka buƙata data a gaske (evaluation). Fahimtar haka ita ce mabugi don rubuta Django code mai inganci.

## QuerySets sun da rashin aiki — babu bugun sitima har sai an auna su

```python
# NONE of these touch the database — they just build up the query
qs = Article.objects.all()                  # no query yet
qs = qs.filter(published=True)              # still no query — chaining is lazy
qs = qs.exclude(views=0).order_by("-created_at")   # still no query

# the database is hit ONLY when the QuerySet is EVALUATED:
for article in qs:        # ← NOW the query runs
    print(article.title)
```

Gina da haɗawa QuerySet ba shi da waya — Django yana tara SQL amma yana jiyar aiwatarwa har sai mutum ke buƙatar sakonnin gaske. Wannan yana bada damar sarrafa buggaje masu rikitarwa da inganci a cikin gida guda.

## Abin da ya jawo evaluation (bugun sitima)

```text
✓ Iterating:        for x in qs
✓ Slicing with step: qs[::2]  (plain slicing qs[:10] stays lazy, adds LIMIT)
✓ len(qs), list(qs), bool(qs)
✓ Calling a non-QuerySet method: .count(), .exists(), .first(), .get(), .aggregate()
```

## Me ya sa rashin aiki ya kasance mai ƙarfi

```python
# build a query conditionally WITHOUT extra database trips
qs = Article.objects.all()
if search:
    qs = qs.filter(title__icontains=search)   # no DB hit
if category:
    qs = qs.filter(category=category)          # no DB hit
articles = qs[:20]                              # ONE query runs here, with LIMIT 20
```

Rashin aiki yana bada damar ka tsara bugun ajiya ta wariya a cikin layukan da yawa, sannan ka aiwatar shi **kacal** — inganci da tsabta.

## QuerySet caching

```python
qs = Article.objects.filter(published=True)
list(qs)     # query runs, results CACHED on the QuerySet
list(qs)     # uses the CACHE — no second query
# BUT a NEW queryset re-queries:
Article.objects.filter(published=True)   # a fresh queryset → new query
```

Da zarar aka auna QuerySet, yana ajiye sakonnin, don haka sake maimaita QuerySet *ɗaya* ba zai sake bugun sitima ba.

## Cin zarafi na rashin aiki

```python
# ⚠️ calling .count() then iterating runs TWO queries
if Article.objects.filter(published=True).count() > 0:   # query 1
    for a in Article.objects.filter(published=True):     # query 2 (new queryset!)
        ...
# ✅ better — evaluate once, reuse
qs = list(Article.objects.filter(published=True))
if qs: ...
```

## Me ya sa ya matuwa

Fahimtar QuerySets da rashin aikinta ita ce abubuwan da ba a raba a rubuta Django sitima code mai inganci, daidai — yana shafar aiki daidai kuma yana bayyana hali da suka daure sabuwar mumunus.

Mabugi shine cewa QuerySets **ba su buge sitima ba har sai an auna su**, wanda abu ne mai ƙarfi: kana iya gina, tacewa, haɗawa, da tsara buggaje masu rikitarwa a jere da yawa na code tare da sitima kusan sifili, sannan aiwata komai a **gida guda** lokacin da ya bukatar sakonni.

Wannan yana ba damar tsabtaccen tsarawa bugun ajiya (misali tsara tacewa ta hanyar niyya dangane da bugun mai amfani, sannan aiwata bugun ajiya gida) wanda ko ba haka ba zai buƙaci wata hanyar taɓatacce ta aiki da kirtani.

Sanin daidai **abin da ya jawo evaluation** (maimaita, `len()`, `list()`, `.count()`, `.exists()`, da sauransu) kuma cewa sakonnin **aka ajiye** a QuerySet da aka auna ita ce mahimmanci don iyaka hatawar karfi - musamman kacal aiwatar bugun ajiya daidai nan (misali kiran `.count()` sannan maimaita QuerySet sabuwa, buge sitima sau biyu).

Rashin aiki ita ce ɗaya daga cikin mahimman hanhanniyoyi don amfani da Django ORM sosai, rabuwa tsakanin masu aiki da rubuta sitima code mai inganci daga waɗanda suka ba da saɗa tare da jawo da gida buggaje masu rashin gida, yana zama ilmin aushi wanda ya danganta da duk ingancin amfani da ingancin aiki a Django.