user1624522 user1624522 - 2 months ago 5
Python Question

generate update query using django orm

I need to implement this query using django orm:

update table set field=field+1 where id=id


I don't whant to use this:

o = model.objects.get(id=id)
o.field+=1
o.save()


because it use select and when update, and not thread safe.

How to implement this via orm?

Answer

Both the previous answerers have part of the solution: you should use update in conjunction with F():

Model.objects.filter(id=id).update(field=F('field') +1))

Note this does an in-place UPDATE without any need for SELECT at all.