django exclude code example

Example 1: django reverse queryset

queryset = reversed(Collection.objects.filter(pk__in = li))

Example 2: django q objects

from django.db.models import Q

obj, created = Person.objects.filter(
    Q(first_name='Bob') | Q(first_name='Robert'),
).get_or_create(last_name='Marley', defaults={'first_name': 'Bob'})

Example 3: query set

A QuerySet is a list of a dictionary of objects in your database.

Example 4: objects.filter django

>>> Entry.objects.filter(blog_id=4)

Example 5: django filter values with e and operator

exact
iexact
contains
icontains
in
gt
gte
lt
lte
startswith
istartswith
endswith
iendswith
range

date
year
iso_year
month
day
week
week_day
iso_week_day
quarter
time
hour
minute
second

isnull
regex
iregex

Example 6: how to work with django ornm __in

# Get blogs entries with id 1, 4 and 7
>>> Blog.objects.filter(pk__in=[1,4,7])

# Get all blog entries with id > 14
>>> Blog.objects.filter(pk__gt=14)

Tags:

Sql Example