On Tuesday 12 September 2006 23:02, James Bennett wrote:
> On 9/12/06, Gary Doades <[EMAIL PROTECTED]> wrote:
> > You mean every TYPE of object surely. I'd like to see it list 10 million
> > records :)
>
> Nope. It lists the objects.
Ok, I'll be sure to avoid this.
> > Even so, if the user selects YES, I'd still be pretty upset. Personally I
> > like the database to have the last word in this case for what can be
> > deleted and what can't.
>
> There are a couple lines you can comment out which I'm pretty sure
> will prevent Django manually cascading the delete (see gabor's post
> below for where to look),
Yeah, seen that already. I'd prefer a more "integrated" solution involving the
backend module.
Something like
if not backend.does_proper_foreign_keys:
do_cascade_deletes()
delete_record()
> > I understand this, but I'm not sure why Django has to be broken to
> > accommodate these databases. As I said, if the database cannot support
> > proper foreign keys, then fall back to the sledge hammer cascade delete
> > approach, otherwise do the right, and simpler thing.
>
> That's an option. Personally, I'd rather see us emulate the standard
> ON DELET/ON UPDATE options for DBs which don't support them, so that
> this functionality would become more portable.
Even the simple solution above would go a long way, and not interfere with
existing MySql and SqlLite users.
> And there are experimental Oracle and SQL Server backends that we'd
> love to get some help testing; I'm in the unfortunate (well, not
> really so unfortunate for me...) position of working in an
> open-source-only shop, and I don't have the spare cash lying around to
> set up personal testbeds for those DBs. So we need someone who does
> have access to a suitable testing setup to help out with those.
Well, I'm a seasoned SQLServer (using .NET) user, so I can certainly try to
test that when I get into Django and get some time.
> Given that it pertains more to future development of Django, this
> might be better hashed out on the django-developers list (I'm pretty
> sure there are people who help us hack on Django who don't subscribe
> to both lists, and django-developers is probably the more appropriate
> forum anyway).
OK, if I have any more thoughts I will post there.
FWIW I looked at the SqlAlchemy docs and they only seem to support code based
cascade delete also (eek). Although I could have misread the docs (again).
Regards,
Gary.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
