I want to increase the prices by 30% in django shell.
models.py:
price = models.FloatField(null=True)
shell:
from product.models import Product
Product.objects.all().update(price=price*1.3)
error:
NameError: name 'price' is not defined
Asked
Active
Viewed 711 times
0
ibrahim demet
- 89
- 11
-
Have you run the migrations after adding the `price = models.FloatField(null=True)` line to your model ? – Rvector Nov 23 '21 at 15:43
-
Of course running migrations – ibrahim demet Nov 23 '21 at 15:53
1 Answers
0
You need to use an F expression to reference the field in the database https://docs.djangoproject.com/en/3.2/ref/models/expressions/#f-expressions
from django.db.models import F
from product.models import Product
Product.objects.all().update(price=F('price')*1.3)
Jimmy Pells
- 674
- 1
- 5
- 12