#23646: query set sql update to change different values by different keys
(include
django-bulk-update in core)
-------------------------------------+-------------------------------------
Reporter: brillgen | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: 1.9
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by brillgen):
* version: 1.7 => 1.9
Old description:
> Database backends like Postgresql support doing multiple value update for
> the same field in different rows using a single update query. Please see
> this sample below:
>
> http://stackoverflow.com/questions/18797608/update-multiple-rows-in-same-
> query-using-postgresql
>
> Example:
> Currently:
> {{{
> Books.objects.all().update(price=10)
> }}}
>
> Proposed (syntax can vary):
> {{{
> Books.objects.all().update({'pk': 1, 'price': 10}, {'pk': 2, 'price':
> 25}])
> }}}
>
> Idea is to do it in sql for performance reasons but still use the ORM and
> not use a raw database connection.
>
> However, such an interface is not exposed via the Django ORM. Would this
> be accepted as a patch? if so, would a list dictionary with the various
> fields:values to be updated be a good way to provide the input to ORM
New description:
**Update**
django-bulk-upate (https://github.com/aykut/django-bulk-update) which
could/should be integrated into django core since we have a bulk_create
and this corresponds well with the save (could be called bulk save if it
makes sense). App works with an identical api to bulk_create and so should
be a good candidate to be considered for inclusion in core.
Database backends like Postgresql support doing multiple value update for
the same field in different rows using a single update query. Please see
this sample below:
http://stackoverflow.com/questions/18797608/update-multiple-rows-in-same-
query-using-postgresql
Example:
Currently:
{{{
Books.objects.all().update(price=10)
}}}
Proposed (syntax can vary):
{{{
Books.objects.all().update({'pk': 1, 'price': 10}, {'pk': 2, 'price':
25}])
}}}
Idea is to do it in sql for performance reasons but still use the ORM and
not use a raw database connection.
However, such an interface is not exposed via the Django ORM. Would this
be accepted as a patch? if so, would a list dictionary with the various
fields:values to be updated be a good way to provide the input to ORM
--
--
Ticket URL: <https://code.djangoproject.com/ticket/23646#comment:5>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/066.46e7abd6cdc4c3f98b10ed97743ca264%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
