Advertisement
skaterksa

models_q

Jul 17th, 2018
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.38 KB | None | 0 0
  1. from django.db.models import Count
  2. from django.db.models import Q
  3.  
  4.  
  5. for item in a_list :
  6.     data = qs.aggregate(
  7.         p1=Count('pk', filter=Q(**{item: True})),
  8.         p2=Count('pk', filter=Q(**{item: False})),
  9.         p3=Count('pk', filter=Q(**{item: None})),
  10.     )
  11.     param1[item] = data['p1'] or 0
  12.     param2[item] = data['p2'] or 0
  13.     param3[item] = data['p3'] or 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement