分组F查询和Q查询

分组

annotate

# models.Publish.objects.annotate(a=Avg('book__price')).values('a')

# models.Book.objects.values('publish_id','id').annotate(a=Avg('price')) {'pulish_id':1,'a':11.11}

F查询和Q查询

from django.db.models import F,Q

F  针对自己单表中字段的比较和处理
models.Book.objects.filter(good__gt=F('comment')*2)
models.Book.objects.all().update(price=F('price')+1)

Q    &  |  非~
filter(Q(xx=11)|Q(ss=22)&Q(oo=33))
filter(Q(Q(xx=11)|Q(ss=22))&Q(oo=33))  &优先级高
filter(Q(Q(xx=11)|Q(ss=22))&Q(oo=33),name='dd')  

执行原生sql(了解)

models.Publish.objects.raw('原生sql')

from django.db import connection
cursor = connection.cursor()
cursor.excute(sql,[1,])
cursor.fetchall()

展示sql的

models.Book.objects.filter(good__gt=F('comment')*2)
from django.db import connection
print(connection.queries)