ModelAdmin.save_as integrity error
107 views
Skip to first unread message
Mike Dewhirst
Jun 22, 2015, 10:57:41 PM6/22/15
to django...@googlegroups.com
The following is all I could find in the docs about ModelAdmin.save_as
ModelAdmin.save_as
(https://docs.djangoproject.com/en/1.7/ref/contrib/admin/#django.contrib.admin.ModelAdmin.save_as)
Set save_as to enable a “save as” feature on admin change forms.
Normally, objects have three save options: “Save”, “Save and
continue editing” and “Save and add another”. If save_as is True, “Save
and add another” will be replaced by a “Save as” button.
“Save as” means the object will be saved as a new object (with a
new ID), rather than the old object.
By default, save_as is set to False.
I'm having problems with [save as new] when the model has inlines. Is
there a known gotcha in this area?
The particular error I'm seeing is ...
IntegrityError at /admin/substance/substance/20/
duplicate key value violates unique constraint
"substance_liquid_substance_id_key"
DETAIL: Key (substance_id)=(54) already exists.
Request Method: POST
Request URL: http://localhost:8000/admin/substance/substance/20/
Django Version: 1.7.8
Exception Type: IntegrityError
Exception Value:
duplicate key value violates unique constraint
"substance_liquid_substance_id_key"
DETAIL: Key (substance_id)=(54) already exists.
Exception Location:
C:\Users\mike\env\xxex3\lib\site-packages\django\db\backends\utils.py in
execute, line 65
Python Executable: C:\Users\mike\env\xxex3\Scripts\python.exe
Python Version: 3.4.3
Python Path:
['/var/www/ssds',
'C:\\Users\\mike\\env\\xxex3\\ssds',
'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages\\psycopg2-2.5.4-py3.4-win32.egg',
'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages\\pillow-2.7.0-py3.4-win32.egg',
'C:\\WINDOWS\\SYSTEM32\\python34.zip',
'C:\\Users\\mike\\env\\xxex3\\DLLs',
'C:\\Users\\mike\\env\\xxex3\\lib',
'C:\\Users\\mike\\env\\xxex3\\Scripts',
'C:\\Python34\\Lib',
'C:\\Python34\\DLLs',
'C:\\Users\\mike\\env\\xxex3',
'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages',
'C:/Users/mike/env/xxex3/ssds']
Server time: Tue, 23 Jun 2015 12:08:44 +1000
The relationship between substance and liquid is 1:1 and the error is
highlighted in my liquid.save() method. However, when I comment that
whole save() method out and try [save as new] again the error doesn't
change, just the substance pk which increments from 54 (as above) to 55
and none of my code seems to be involved. Or at least the traceback
doesn't highlight any.
There appear to be no problems with the code saving normally and there
are hundreds of unit tests all passing successfully.
I would really appreciate any help. Is there more info I can provide?
Python 3.4 (Windows 8.1)
Django 1.7.8 (Windows 8.1)
Postgres 9.1 (Ubuntu 12.04)
Thanks for any hints.
Mike
ModelAdmin.save_as
(https://docs.djangoproject.com/en/1.7/ref/contrib/admin/#django.contrib.admin.ModelAdmin.save_as)
Set save_as to enable a “save as” feature on admin change forms.
Normally, objects have three save options: “Save”, “Save and
continue editing” and “Save and add another”. If save_as is True, “Save
and add another” will be replaced by a “Save as” button.
“Save as” means the object will be saved as a new object (with a
new ID), rather than the old object.
By default, save_as is set to False.
I'm having problems with [save as new] when the model has inlines. Is
there a known gotcha in this area?
The particular error I'm seeing is ...
IntegrityError at /admin/substance/substance/20/
duplicate key value violates unique constraint
"substance_liquid_substance_id_key"
DETAIL: Key (substance_id)=(54) already exists.
Request Method: POST
Request URL: http://localhost:8000/admin/substance/substance/20/
Django Version: 1.7.8
Exception Type: IntegrityError
Exception Value:
duplicate key value violates unique constraint
"substance_liquid_substance_id_key"
DETAIL: Key (substance_id)=(54) already exists.
Exception Location:
C:\Users\mike\env\xxex3\lib\site-packages\django\db\backends\utils.py in
execute, line 65
Python Executable: C:\Users\mike\env\xxex3\Scripts\python.exe
Python Version: 3.4.3
Python Path:
['/var/www/ssds',
'C:\\Users\\mike\\env\\xxex3\\ssds',
'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages\\psycopg2-2.5.4-py3.4-win32.egg',
'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages\\pillow-2.7.0-py3.4-win32.egg',
'C:\\WINDOWS\\SYSTEM32\\python34.zip',
'C:\\Users\\mike\\env\\xxex3\\DLLs',
'C:\\Users\\mike\\env\\xxex3\\lib',
'C:\\Users\\mike\\env\\xxex3\\Scripts',
'C:\\Python34\\Lib',
'C:\\Python34\\DLLs',
'C:\\Users\\mike\\env\\xxex3',
'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages',
'C:/Users/mike/env/xxex3/ssds']
Server time: Tue, 23 Jun 2015 12:08:44 +1000
The relationship between substance and liquid is 1:1 and the error is
highlighted in my liquid.save() method. However, when I comment that
whole save() method out and try [save as new] again the error doesn't
change, just the substance pk which increments from 54 (as above) to 55
and none of my code seems to be involved. Or at least the traceback
doesn't highlight any.
There appear to be no problems with the code saving normally and there
are hundreds of unit tests all passing successfully.
I would really appreciate any help. Is there more info I can provide?
Python 3.4 (Windows 8.1)
Django 1.7.8 (Windows 8.1)
Postgres 9.1 (Ubuntu 12.04)
Thanks for any hints.
Mike
Mike Dewhirst
Jun 23, 2015, 2:08:23 AM6/23/15
to django...@googlegroups.com
I commented out the save() method in the Substance model (the master
model with a number of 1:1 and 1:n relationships) and it started saving
as new successfully. Unfortunately I do a lot of stuff in that save()
method so I have to figure out how to do that another way.
Mike
On 23/06/2015 12:57 PM, Mike Dewhirst wrote:
> The following is all I could find in the docs about ModelAdmin.save_as
>
> ModelAdmin.save_as
> (https://docs.djangoproject.com/en/1.7/ref/contrib/admin/#django.contrib.admin.ModelAdmin.save_as)
>
>
> Set save_as to enable a “save as†feature on admin change forms.
>
> Normally, objects have three save options: “Save†, “Save and
> continue editing†and “Save and add another†. If save_as is True,
> “Save and add another†will be replaced by a “Save as†button.
>
> “Save as†means the object will be saved as a new object (with
model with a number of 1:1 and 1:n relationships) and it started saving
as new successfully. Unfortunately I do a lot of stuff in that save()
method so I have to figure out how to do that another way.
Mike
On 23/06/2015 12:57 PM, Mike Dewhirst wrote:
> The following is all I could find in the docs about ModelAdmin.save_as
>
> ModelAdmin.save_as
> (https://docs.djangoproject.com/en/1.7/ref/contrib/admin/#django.contrib.admin.ModelAdmin.save_as)
>
>
>
> Normally, objects have three save options: “Save†, “Save and
> continue editing†and “Save and add another†. If save_as is True,
> “Save and add another†will be replaced by a “Save as†button.
>
> “Save as†means the object will be saved as a new object (with
Luis Zárate
Jun 23, 2015, 1:25:22 PM6/23/15
to django...@googlegroups.com
Can I see your Substance save method? Maybe there are something wrong.> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
> To post to this group, send email to django...@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/5588F7B9.1030906%40dewhirst.com.au.
> For more options, visit https://groups.google.com/d/optout.
>
--
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
> To post to this group, send email to django...@googlegroups.com.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/5588F7B9.1030906%40dewhirst.com.au.
> For more options, visit https://groups.google.com/d/optout.
>
--
"La utopía sirve para caminar" Fernando Birri
Mike Dewhirst
Jun 23, 2015, 4:37:28 PM6/23/15
to django...@googlegroups.com
On 24/06/2015 3:24 AM, Luis Zárate wrote:
> Can I see your Substance save method? Maybe there are something wrong.
Luis
Thanks for responding. There is/was something wrong. I was creating
related objects in the save() method which is fine for a new substance
but when [Save as new] happened the Admin didn't know that and
replicated existing related objects. It was getting somewhat out of hand.
My solution FWIW is to use try/except around my own related object
creation and pass if already there. For the moment that seems to be working.
Cheers
Mike
> <mailto:mi...@dewhirst.com.au>> escribió:
> admin change forms.
> >>
> >>    Normally, objects have three save options: “Saveâ€
> , “Save and
> >> continue editing†and “Save and add another†. If
> save_as is True,
> >> “Save and add another†will be replaced by a “Save
> as†button.
> >>
> >>    â€œSave as†means the object will be saved as a
> >>
> >> Request Method:Â Â Â POST
> >> Request URL:Â Â Â http://localhost:8000/admin/substance/substance/20/
> >> Django Version:Â Â Â 1.7.8
> >> Exception Type:Â Â Â IntegrityError
> >> Python Version:Â Â Â 3.4.3
> >> Python Path:
> >>
> >> ['/var/www/ssds',
> >> Â 'C:\\Users\\mike\\env\\xxex3\\ssds',
> >> Â 'C:\\Users\\mike\\env\\xxex3\\DLLs',
> >> Â 'C:\\Users\\mike\\env\\xxex3\\lib',
> >> Â 'C:\\Users\\mike\\env\\xxex3\\Scripts',
> >> Â 'C:\\Python34\\Lib',
> >> Â 'C:\\Python34\\DLLs',
> >> Â 'C:\\Users\\mike\\env\\xxex3',
> >> Â 'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages',
> >> Â 'C:/Users/mike/env/xxex3/ssds']
> >>
> >> Server time:Â Â Â Tue, 23 Jun 2015 12:08:44 +1000
> <https://groups.google.com/d/msgid/django-users/CAG%2B5VyPKTdDLEMdU5RoeA-Q2CFK42DhPQ5ooqGVCKrHKq447Rw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
> Can I see your Substance save method? Maybe there are something wrong.
Luis
Thanks for responding. There is/was something wrong. I was creating
related objects in the save() method which is fine for a new substance
but when [Save as new] happened the Admin didn't know that and
replicated existing related objects. It was getting somewhat out of hand.
My solution FWIW is to use try/except around my own related object
creation and pass if already there. For the moment that seems to be working.
Cheers
Mike
> <mailto:mi...@dewhirst.com.au>> escribió:
> > I commented out the save() method in the Substance model (the master
> model with a number of 1:1 and 1:n relationships) and it started saving
> as new successfully. Unfortunately I do a lot of stuff in that save()
> method so I have to figure out how to do that another way.
> >
> > Mike
> >
> > On 23/06/2015 12:57 PM, Mike Dewhirst wrote:
> >>
> >> The following is all I could find in the docs about ModelAdmin.save_as
> >>
> >> ModelAdmin.save_as
> >>
> (https://docs.djangoproject.com/en/1.7/ref/contrib/admin/#django.contrib.admin.ModelAdmin.save_as)
> >>
> >>
> >>    Set save_as to enable a “save as†feature on
> model with a number of 1:1 and 1:n relationships) and it started saving
> as new successfully. Unfortunately I do a lot of stuff in that save()
> method so I have to figure out how to do that another way.
> >
> > Mike
> >
> > On 23/06/2015 12:57 PM, Mike Dewhirst wrote:
> >>
> >> The following is all I could find in the docs about ModelAdmin.save_as
> >>
> >> ModelAdmin.save_as
> >>
> (https://docs.djangoproject.com/en/1.7/ref/contrib/admin/#django.contrib.admin.ModelAdmin.save_as)
> >>
> >>
> admin change forms.
> >>
> >>    Normally, objects have three save options: “Saveâ€
> , “Save and
> >> continue editing†and “Save and add another†. If
> save_as is True,
> >> “Save and add another†will be replaced by a “Save
> as†button.
> >>
> >>    â€œSave as†means the object will be saved as a
> new object (with
> >> a new ID), rather than the old object.
> >>
> >> Â Â Â By default, save_as is set to False.
> >> a new ID), rather than the old object.
> >>
> >>
> >>
> >>
> >> I'm having problems with [save as new] when the model has inlines. Is
> >> there a known gotcha in this area?
> >>
> >> The particular error I'm seeing is ...
> >>
> >>
> >>
> >> IntegrityError at /admin/substance/substance/20/
> >>
> >> duplicate key value violates unique constraint
> >> "substance_liquid_substance_id_key"
> >> DETAIL:Â Key (substance_id)=(54) already exists.
> >>
> >>
> >> I'm having problems with [save as new] when the model has inlines. Is
> >> there a known gotcha in this area?
> >>
> >> The particular error I'm seeing is ...
> >>
> >>
> >>
> >> IntegrityError at /admin/substance/substance/20/
> >>
> >> duplicate key value violates unique constraint
> >> "substance_liquid_substance_id_key"
> >>
> >> Request Method:Â Â Â POST
> >> Request URL:Â Â Â http://localhost:8000/admin/substance/substance/20/
> >> Django Version:Â Â Â 1.7.8
> >> Exception Type:Â Â Â IntegrityError
> >> Exception Value:
> >>
> >> duplicate key value violates unique constraint
> >> "substance_liquid_substance_id_key"
> >> DETAIL:Â Key (substance_id)=(54) already exists.
> >>
> >> duplicate key value violates unique constraint
> >> "substance_liquid_substance_id_key"
> >>
> >> Exception Location:
> >> C:\Users\mike\env\xxex3\lib\site-packages\django\db\backends\utils.py in
> >> execute, line 65
> >> Python Executable:Â Â Â C:\Users\mike\env\xxex3\Scripts\python.exe
> >> Exception Location:
> >> C:\Users\mike\env\xxex3\lib\site-packages\django\db\backends\utils.py in
> >> execute, line 65
> >> Python Version:Â Â Â 3.4.3
> >> Python Path:
> >>
> >> ['/var/www/ssds',
> >> Â 'C:\\Users\\mike\\env\\xxex3\\ssds',
> >>
> >>
> 'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages\\psycopg2-2.5.4-py3.4-win32.egg',
> >>
> >>
> >>
> 'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages\\pillow-2.7.0-py3.4-win32.egg',
> >>
> >> Â 'C:\\WINDOWS\\SYSTEM32\\python34.zip',
> >>
> 'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages\\psycopg2-2.5.4-py3.4-win32.egg',
> >>
> >>
> >>
> 'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages\\pillow-2.7.0-py3.4-win32.egg',
> >>
> >> Â 'C:\\Users\\mike\\env\\xxex3\\DLLs',
> >> Â 'C:\\Users\\mike\\env\\xxex3\\lib',
> >> Â 'C:\\Users\\mike\\env\\xxex3\\Scripts',
> >> Â 'C:\\Python34\\Lib',
> >> Â 'C:\\Python34\\DLLs',
> >> Â 'C:\\Users\\mike\\env\\xxex3',
> >> Â 'C:\\Users\\mike\\env\\xxex3\\lib\\site-packages',
> >> Â 'C:/Users/mike/env/xxex3/ssds']
> >>
> >> Server time:Â Â Â Tue, 23 Jun 2015 12:08:44 +1000
> >>
> >>
> >> The relationship between substance and liquid is 1:1 and the error is
> >> highlighted in my liquid.save() method. However, when I comment that
> >> whole save() method out and try [save as new] again the error doesn't
> >> change, just the substance pk which increments from 54 (as above) to 55
> >> and none of my code seems to be involved. Or at least the traceback
> >> doesn't highlight any.
> >>
> >> There appear to be no problems with the code saving normally and there
> >> are hundreds of unit tests all passing successfully.
> >>
> >> I would really appreciate any help. Is there more info I can provide?
> >>
> >> Python 3.4 (Windows 8.1)
> >> Django 1.7.8 (Windows 8.1)
> >> Postgres 9.1 (Ubuntu 12.04)
> >>
> >> Thanks for any hints.
> >>
> >> Mike
> >>
> >
> > --
> > You received this message because you are subscribed to the Google
> Groups "Django users" group.
> > To unsubscribe from this group and stop receiving emails from it,
> send an email to django-users...@googlegroups.com
> <mailto:django-users%2Bunsu...@googlegroups.com>.
> >>
> >> The relationship between substance and liquid is 1:1 and the error is
> >> highlighted in my liquid.save() method. However, when I comment that
> >> whole save() method out and try [save as new] again the error doesn't
> >> change, just the substance pk which increments from 54 (as above) to 55
> >> and none of my code seems to be involved. Or at least the traceback
> >> doesn't highlight any.
> >>
> >> There appear to be no problems with the code saving normally and there
> >> are hundreds of unit tests all passing successfully.
> >>
> >> I would really appreciate any help. Is there more info I can provide?
> >>
> >> Python 3.4 (Windows 8.1)
> >> Django 1.7.8 (Windows 8.1)
> >> Postgres 9.1 (Ubuntu 12.04)
> >>
> >> Thanks for any hints.
> >>
> >> Mike
> >>
> >
> > --
> > You received this message because you are subscribed to the Google
> Groups "Django users" group.
> > To unsubscribe from this group and stop receiving emails from it,
> send an email to django-users...@googlegroups.com
> > To post to this group, send email to django...@googlegroups.com
> <mailto:django...@googlegroups.com>.
> > Visit this group at http://groups.google.com/group/django-users.
> > To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/5588F7B9.1030906%40dewhirst.com.au.
> > For more options, visit https://groups.google.com/d/optout.
> >
>
> --
> "La utopÃa sirve para caminar" Fernando Birri
> > To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/5588F7B9.1030906%40dewhirst.com.au.
> > For more options, visit https://groups.google.com/d/optout.
> >
>
> --
>
>
>
> --
> You received this message because you are subscribed to the Google
> Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to django-users...@googlegroups.com
> <mailto:django-users...@googlegroups.com>.
>
>
> --
> You received this message because you are subscribed to the Google
> Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to django-users...@googlegroups.com
> To post to this group, send email to django...@googlegroups.com
> <mailto:django...@googlegroups.com>.
> Visit this group at http://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CAG%2B5VyPKTdDLEMdU5RoeA-Q2CFK42DhPQ5ooqGVCKrHKq447Rw%40mail.gmail.com
> To view this discussion on the web visit
> <https://groups.google.com/d/msgid/django-users/CAG%2B5VyPKTdDLEMdU5RoeA-Q2CFK42DhPQ5ooqGVCKrHKq447Rw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
Reply all
Reply to author
Forward
0 new messages