filter_by_F = Book.objects.filter(sale_price__gte =200+F('cost_price'))
filter_by_F2 = Book.objects.values(
'id','bookname','sale_price', 'cost_price',
profit=F('sale_price')-F('cost_price')
).filter(profit__gte =200)
# SQL的or查询,需要引入Q,编写格式:Q(field=value)|Q(field=value)
#多个Q之间使用“|”隔开即可
# SQL:Select * from index_vocation where job='网站设计' or id=9
from django.db.models import Q
v = Vocation.objects.filter(Q(job='网站设计')|Q(id=4))