Django查詢集合API

回傳QuerySet的方法

filter(**kwargs)

exclude(**kwargs)

annotate(*args, **kwargs)

order_by(*fields)

reverse()

distinct()

values(*fields)

values_list(*fields)

dates(field, kind, order='ASC')

none()

all()

select_related()

extra(select=None, where=None, params=None, tables=None, order_by=None, select_params=None)

defer(*fields)

only(*fields)

不回傳QuerySet的方法

get(**kwargs)

create(**kwargs)

get_or_create(**kwargs)

count()

in_bulk(id_list)

iterator()

latest(field_name=None)

aggregate(*args, **kwargs)

欄位查詢(Field lookup)

exact

iexact

contains

icontains

in

gt

gte

lt

lte

startswith

istartswith

endswith

iendswith

range

year

month

day

week_day

isnull

search

regex

iregex

聚合函數(Aggregation Function)

Avg

Count

Max

Min

StdDev

Sum

Variance