Django Federated Query

Suppose that the primary key aid of table A is the foreign key of Table B, and a table has the property name, then you can write this by querying the elements of name ABC in table B:

B.objects.all (). Filter (Aid__name = ' abc ')

It's so easy to use ... There are other uses:

When the condition is selected Queryset, filter indicates that =,exclude represents! =.
Queryset.distinct () to repeat
__exact exactly equals like ' AAA '
__iexact precision equals ignoring case ilike ' AAA '
__contains contains like '%aaa% '
__icontains includes ignoring case ilike '%aaa% ', but for SQLite, the effect of contains is equivalent to Icontains.
__GT Greater than
__gte greater than or equal to
__lt less than
__lte less than or equal to
__in exists in a list range
__startswith to ... Beginning
__istartswith to ... Start ignoring case
__endswith to ... End
__iendswith to ... End, ignoring case
__range in ... Within range
__year Year of Date field
__month Month of Date field
Day of the __day date field
__isnull=true/false

Example:

Q1 = Entry.objects.filter (headline__startswith= "what") q2 = Q1.exclude (Pub_date__gte=datetime.date.today ()) Q3 = Q1.filter (Pub_date__gte=datetime.date.today ()) q = Q.filter (Pub_date__lte=datetime.date.today ()) q = Q.exclude (body_ text__icontains= "Food")

That is, Q1.filter (Pub_date__gte=datetime.date.today ()) is expressed as time >=now,q1.exclude (Pub_date__gte=datetime.date.today ()) expressed as <=now

Above from http://www.douban.com/note/301166150/

It's kinda funny to write = =

Django Federated Query