select and update database record with a single queryset

sql django django-models orm django-queryset
John picture John · Apr 26, 2010 · Viewed 184.3k times · Source

How do I run an update and select statements on the same queryset rather than having to do two queries: - one to select the object - and one to update the object

The equivalent in SQL would be something like:

update my_table set field_1 = 'some value' where pk_field = some_value

Answer

Daniel Roseman picture Daniel Roseman · Apr 26, 2010

Use the queryset object update method:

MyModel.objects.filter(pk=some_value).update(field1='some value')

Related questions

How can I temporarily disable a foreign key constraint in MySQL?

Is it possible to temporarily disable constraints in MySQL? I have two Django models, each with a foreign key to the other one. Deleting instances of a model returns an error because of the foreign key constraint: cursor.execute("DELETE …

Read More
sql "LIKE" equivalent in django query

What is the equivalent of this SQL statement in django? SELECT * FROM table_name WHERE string LIKE pattern; How do I implement this in django? I tried result = table.objects.filter( pattern in string ) But that did not work. How …

Read More
LEFT JOIN Django ORM

I have the following models: class Volunteer(models.Model): first_name = models.CharField(max_length=50L) last_name = models.CharField(max_length=50L) email = models.CharField(max_length=50L) gender = models.CharField(max_length=1, choices=GENDER_CHOICES) class Department(models.…

Read More