Opened 11 years ago
Last modified 6 months ago
#21295 new New feature
Add on_update support
Reported by: | Anssi Kääriäinen | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | dev |
Severity: | Normal | Keywords: | |
Cc: | loic@…, emorley@…, Akash Kumar Sen, Giannis Terzopoulos, Ülgen Sarıkavak, Ryan Hiebert | Triage Stage: | Accepted |
Has patch: | yes | Needs documentation: | yes |
Needs tests: | no | Patch needs improvement: | yes |
Easy pickings: | no | UI/UX: | no |
Description
There are cases where on-update cascade support would be useful. Currently Django offers no way to cascade updates.
An experimental patch implementing on_update=models.CASCADE support for foreign keys is available from: https://github.com/akaariai/django/tree/update_cascade. It is based on composite foreign keys branch (https://github.com/akaariai/django/tree/soc2013/composite-fields).
I'll attach a sample project to this ticket. Unpack it, use the above mentioned branch of Django, run syncdb, runserver and try in admin. Note that the country/city names are stored locally in the models, so country name update cascades to cities and from cities to streets.
Attachments (1)
Change History (10)
by , 11 years ago
Attachment: | test_composite.tar.gz added |
---|
comment:1 by , 11 years ago
Needs documentation: | set |
---|---|
Patch needs improvement: | set |
comment:2 by , 11 years ago
Cc: | added |
---|
Awesome work.
I just had a brief look at the diff, it will need special handling to be compatible with migrations, my patch for #21275 addresses this issue.
comment:3 by , 11 years ago
Triage Stage: | Unreviewed → Accepted |
---|
comment:4 by , 8 years ago
Cc: | added |
---|
comment:5 by , 17 months ago
This seems to be a interesting topic to work on, but I am not sure about the ideal behavior of the on_update
parameter. Some explanation would be very helpful. Are we talking about something similar to the SQL ON UPDATE
clause here?
comment:6 by , 17 months ago
Cc: | added |
---|
comment:7 by , 9 months ago
Cc: | added |
---|
comment:8 by , 8 months ago
Cc: | added |
---|
comment:9 by , 6 months ago
Cc: | added |
---|
Sample project