On Mon, Jun 27, 2011 at 4:24 PM, Jim D. <jim.dal...@gmail.com> wrote: > I spent some time last week and over the weekend nailing down a > solution for https://code.djangoproject.com/ticket/3615 . This is the > ticket about allowing forward references when loading data on the > MySQL InnoDB backend. My patch implements the proposed change > (disabling foreign key checks when the data is loaded) as well as a > straightforward SQL SELECT check for integrity after the data is > loaded, which if I understand it is the missing piece that has > prevented this ticket from moving forward for the last 4 years...
Interesting approach -- I wouldn't have thought of this! It feels a bit nasty to me, but it's rather close to how deferred constraints work behind the scenes anyway. I'd like to see some feedback from other people who're experienced with MySQL; I don't know enough about any potential downsides to spot 'em. But I think you've found a way to cut the knot of this problem, and barring a better solution I'd like to check this one in. > Anyhow, the patch should be 100% there so I'd love if someone could > check it out and either push it along or let me know if any changes > are required. It should be easy enough for me to address any issues > while the whole problem is in my head. I left some comments on the patch on the ticket. > I'm using django-threadedcomments on a project, which has forward > references in one of its test fixtures, so I'm reminded of this issue > every time I run my project tests. I hate test errors! I'm hopeful the > latest patch is sufficient to get this issue resolved. Does this patch work for you (I'm assuming so)? A "this works for me in production" goes a huge way towards me feeling comfortable checking things in. Jacob -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developers@googlegroups.com. To unsubscribe from this group, send email to django-developers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.
