Increment/Decrement Field value

Posted: May 26th, 2010 | Author: Davo | Filed under: Django | Tags: | No Comments »

Incrementing or decrementing field values can be done by using the F() function.
UPDATE FIELD = FIELD + 1 WHERE… ?

from django.db.models import F

# views.py ...
offer = Offer.objects.get(...)
# SQL: UPDATE field_to_increment = field_to_increment + 1 ...
offer.field_to_increment = F('field_to_increment') + 1
offer.save()


Leave a Reply