[Django] #25195: update_or_create doesn't understand F() operations
Django
-------------------------------------+-------------------------------------
Reporter: mjtamlyn | Owner: nobody
Type: New | Status: new
feature |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
This may not be possible to resolve, but it would be really nice if you
could do something like
{{{
Foo.objects.update_or_create(name='bar', defaults={'value': F('value') +
1})
}}}
This would only be possible when value has a default, and we would need to
resolve the F() object to the default. It may be that we need a different
object which resolves to an expression when used in an update but resolves
differently when used in a create.
--
Ticket URL: <https://code.djangoproject.com/ticket/25195>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
-------------------------------------+-------------------------------------
Reporter: mjtamlyn | Owner: nobody
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* stage: Unreviewed => Accepted
--
Ticket URL: <https://code.djangoproject.com/ticket/25195#comment:1>
Django
-------------------------------------+-------------------------------------
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by ghazpar):
How about the following?
{{{
Foo.objects.update_or_create(name='bar', defaults={'value':
Coalesce('value', 0) + 1})
}}}
where one could specify an explicit default?
--
Ticket URL: <https://code.djangoproject.com/ticket/25195#comment:2>
Django
-------------------------------------+-------------------------------------
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Simon Charette):
Replying to [comment:2 Marc Parizeau]:
> How about the following?
>
> {{{
> Foo.objects.update_or_create(name='bar', defaults={'value':
Coalesce('value', 0) + 1})
> }}}
>
> where one could specify an explicit default?
We'd need to special case `Coalesce` in `update_or_create` for this to
work as references to columns are not allowed in `INSERT`s.
--
Ticket URL: <https://code.djangoproject.com/ticket/25195#comment:3>
Django
-------------------------------------+-------------------------------------
Type: New feature | Status: new
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* cc: Ülgen Sarıkavak (added)
--
Ticket URL: <https://code.djangoproject.com/ticket/25195#comment:4>