Mid ka mid ah dhibaatooyinka ugu waaweyn ee su'aalaha model Django waa in ay noqon karaan kuwo aad u hadal ah. Tusaale ahaan, haddii aad rabto inaad ka hesho dhammaan maqaallada ku jira baloog la bixiyay, waxaad u baahan doontaa inaad isticmaasho su'aal sidan oo kale ah:
articles = Blog.objects.all()
Haddii aad rabto inaad hesho dhammaan maqaallada la daabacay bishii la soo dhaafay, waxaad u baahan doontaa inaad isticmaasho su'aal sidan oo kale ah:
articles_published_in_the_last_month = Blog.objects.filter(published=Run)
There are a number of ways to query a Django model. The simplest way is to use the Model.objects.all() method, which will return all objects for that model. If you want to filter the queryset, you can use the Model.objects.filter(**kwargs) method, where kwargs is a dictionary of field names and values to filter on. For example, if you only wanted objects with a certain value for the 'name' field, you could do: Model.objects.filter(name='value') If you want to get a single object from the queryset, you can use the Model.objects.get(**kwargs) method, which will return the first object that matches the given criteria. For example, if you wanted to get an object with a particular 'id' value: Model.objects.get(id=1)
Haddii aad rabto inaad dalbato su'aalaha, waxaad isticmaali kartaa habka Model.objects.order_by(field_name), kaas oo u dalbi doona su'aalaha goobta la siiyay si kor loogu qaado. Waxa kale oo aad isticmaali kartaa horgalaha '-' si aad u dalbato sida ay u kala horreeyaan:
Model.objects. order_by ('-name')
Waa maxay QuerySet
QuerySet waa ururinta moodooyinka la xidhiidha kuwaas oo si wadajir ah wax loo waydiin karo. Waa hab ku habboon in la isku keeno moodooyinka si aad si fudud u waydiiso iyaga cutub ahaan.
Weydii Weydiinta
Weydiinta odhaahdu waa hab awood leh oo lagu shaandheeyo xogta gudaha Django. Waxay la mid tahay qodob HALKEE ku jira weydiinta SQL, laakiin waxaa loo isticmaali karaa shay kasta oo moodel ah.
Tusaale ahaan, waxaad isticmaali kartaa odhaah su'aal ah si aad u hesho dhammaan maqaallada leh cinwaan ka bilaabma "Sida loo":
articles.filter (ciwaanka__startswith='Sida loo')
Query Set API Tixraaca
QuerySet API waxa uu bixiyaa hab lagu weyddiiyo moodalka goobihiisa iyo xogta la xidhiidha. API-ga waxa loo qaabeeyey bayaanka SQL SELECT, wuxuuna kuu ogolaanayaa inaad qeexdo meelaha aad doonayso inaad soo saarto, siday u kala horreeyaan, iyo inta saf ee xogta aad rabto inaad soo celiso.
Si aad u isticmaasho QuerySet API, marka hore samee shayga moodeel:
ka django.db soo dejinta moodooyinka fasalka MyModel(models.Model): magac = model.CharField(max_length=30)
Kadib samee shayga weydiinta:
weydiin = MyModel.objects.create_query() weydiin.select ('magaca').
