QuerySet orqali ma’lumot olish

Ma’lumot olish

Modeldan QuerySet’ga ma’lumot olishning turli metodlari bor.

values() metodi

values() metodi har bir obyektni nomlar va qiymatlar kalit/qiymat juftliklari shaklida bo‘lgan Python lug‘ati (dictionary) sifatida qaytarish imkonini beradi:

Misol

views.py:

from django.http import HttpResponse
from django.template import loader
from .models import Member

def testing(request):
  mydata = Member.objects.all().values()
  template = loader.get_template('template.html')
  context = {
    'mymembers': mydata,
  }
  return HttpResponse(template.render(context, request))

Misolni ishga tushirish »

Muayyan ustunlarni qaytarish

values_list() metodi faqat siz ko‘rsatgan ustunlarni qaytarish imkonini beradi.

Misol

Faqat firstname ustunlarini qaytarish:

views.py:

from django.http import HttpResponse
from django.template import loader
from .models import Member

def testing(request):
  mydata = Member.objects.values_list('firstname')
  template = loader.get_template('template.html')
  context = {
    'mymembers': mydata,
  }
  return HttpResponse(template.render(context, request))

Misolni ishga tushirish »

Muayyan qatorlarni qaytarish

filter() metodidan foydalanib, qidiruvni faqat muayyan qatorlar/yozuvlarni qaytaradigan qilib filtrlashingiz mumkin.

Misol

Faqat firstname qiymati 'Emil' bo‘lgan yozuvlarni qaytarish

views.py:

from django.http import HttpResponse
from django.template import loader
from .models import Member

def testing(request):
  mydata = Member.objects.filter(firstname='Emil').values()
  template = loader.get_template('template.html')
  context = {
    'mymembers': mydata,
  }
  return HttpResponse(template.render(context, request))

Misolni ishga tushirish »

filter() metodi haqida keyingi bobda batafsil bilib olasiz.

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!

Ro'yxatdan o'tish Kirish