From 886005078d66bd779ad3d6434d5699fbc17cfed1 Mon Sep 17 00:00:00 2001 From: Brian Rosner Date: Mon, 28 Apr 2008 14:43:46 +0000 Subject: newforms-admin: Merged from trunk up to [7499]. git-svn-id: http://code.djangoproject.com/svn/django/branches/newforms-admin@7500 bcc190cf-cafb-0310-a4f2-bffc1f526a37 --- tests/regressiontests/queries/models.py | 43 +++++++++++++++++++++++++++++++++ 1 file changed, 43 insertions(+) (limited to 'tests') diff --git a/tests/regressiontests/queries/models.py b/tests/regressiontests/queries/models.py index 5529bced8b..6fd361ec19 100644 --- a/tests/regressiontests/queries/models.py +++ b/tests/regressiontests/queries/models.py @@ -117,6 +117,24 @@ class LoopZ(models.Model): class Meta: ordering = ['z'] +# A model and custom default manager combination. +class CustomManager(models.Manager): + def get_query_set(self): + return super(CustomManager, self).get_query_set().filter(public=True, + tag__name='t1') + +class ManagedModel(models.Model): + data = models.CharField(max_length=10) + tag = models.ForeignKey(Tag) + public = models.BooleanField(default=True) + + objects = CustomManager() + normal_manager = models.Manager() + + def __unicode__(self): + return self.data + + __test__ = {'API_TESTS':""" >>> t1 = Tag(name='t1') >>> t1.save() @@ -658,5 +676,30 @@ Bug #7098 -- Make sure semi-deprecated ordering by related models syntax still works. >>> Item.objects.values('note__note').order_by('queries_note.note', 'id') [{'note__note': u'n2'}, {'note__note': u'n3'}, {'note__note': u'n3'}, {'note__note': u'n3'}] + +Bug #7096 -- Make sure exclude() with multiple conditions continues to work. +>>> Tag.objects.filter(parent=t1, name='t3').order_by('name') +[] +>>> Tag.objects.exclude(parent=t1, name='t3').order_by('name') +[, , , ] +>>> Item.objects.exclude(tags__name='t1', name='one').order_by('name').distinct() +[, , ] +>>> Item.objects.filter(name__in=['three', 'four']).exclude(tags__name='t1').order_by('name') +[, ] + +More twisted cases, involving nested negations. +>>> Item.objects.exclude(~Q(tags__name='t1', name='one')) +[] +>>> Item.objects.filter(~Q(tags__name='t1', name='one'), name='two') +[] +>>> Item.objects.exclude(~Q(tags__name='t1', name='one'), name='two') +[, , ] + +Bug #7095 +Updates that are filtered on the model being updated are somewhat tricky to get +in MySQL. This exercises that case. +>>> mm = ManagedModel.objects.create(data='mm1', tag=t1, public=True) +>>> ManagedModel.objects.update(data='mm') + """} -- cgit v1.3