Re: [Sqlalchemy-tickets] [sqlalchemy] #2501: the DELETE before INSERT problem

[sqlalchemy <mi...@zz...>]

#2501: the DELETE before INSERT problem
------------------------------+---------------------------------------
      Reporter:  zzzeek       |      Owner:  zzzeek
          Type:  defect       |     Status:  new
      Priority:  high         |  Milestone:  0.9.xx
     Component:  orm          |   Severity:  very major - up to 2 days
    Resolution:               |   Keywords:
Progress State:  needs tests  |
------------------------------+---------------------------------------

Comment (by schlamar):

 Oh no. The solution from above does not work predictably in the following
 case:

 - Replace the first existing child with a new one

 Sometimes the test passes, sometimes not. Error is:

 {{{
 IntegrityError: (IntegrityError) columns parent_id, position are not
 unique u'INSERT INTO ...
 }}}


 I assume that there is not determined order to update pending instances?
 Probably they are in a dict?

 Any idea how I can solve this issue?

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2501#comment:13>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python