數(shù)據(jù)查詢
子查詢
select * from Model_b where field in (select field in Model_a)
sub_query = Model_a.values_list('field')
queryset = Model_b.objects.filter(field__in=sub_query)
Group By
select count(field) as field_count from Model group by field
from django.db.models import Count
Model.objects.values_list('field').annotate(field_count=Count('field'))
使用SQL
Model.objects.raw("select * from model where a = %r group by field", [123])
Model轉(zhuǎn)字典
注意: 若時(shí)間字段設(shè)置了auto_now_add = True, 會(huì)自動(dòng)使該字段editable = False, 從而導(dǎo)致該函數(shù)無法正確對(duì)該字段進(jìn)行轉(zhuǎn)換.
解決辦法: 手動(dòng)為該類字段賦值
from django.forms.models import model_to_dict
data = model_to_dict(obj)
data["create_at"] = str(obj.create_at)
權(quán)限校驗(yàn)
方法裝飾器
from django.utils.decorators import method_decorator
from guardian.decorators import permission_required_or_403
@method_decorator(permission_required_or_403("MODEL.change_TABLE"))
對(duì)象權(quán)限判斷
# 是否擁有某權(quán)限
request.user.has_perm("MODEL.change_TABLE")
# 是否是管理員
request.user.is_superuser
模板函數(shù)
perms.MODEL.change_TABLE
博客文章遷移: 2019-06-25 18:45
