generate update query using django orm

Question

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?

Accepted 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.

generate update query using django orm

Solution

Problem