CODE EXAMPLE FOR PYTHON

case statement in querset django

# Creating a calculated column named 'discount' on Client table 
# Using conditional case statement with nested When -> Then logic
Client.objects.annotate(
     discount=Case(
         When(account_type=Client.GOLD, then=Value('5%')),
         When(account_type=Client.PLATINUM, then=Value('10%')),
         default=Value('0%'),
     ),
 ).values_list('name', 'discount')