diff options
| author | Russell Keith-Magee <russell@keith-magee.com> | 2010-09-28 08:28:32 +0000 |
|---|---|---|
| committer | Russell Keith-Magee <russell@keith-magee.com> | 2010-09-28 08:28:32 +0000 |
| commit | ccd6a6783baef1980cbe2f04a038eaecf23742ef (patch) | |
| tree | 2f7cec427f26cf1fbadd62da64ca0a705eb0530b | |
| parent | a9e0305f2294012ffd6aad76fa7bab4d2c3ed4cd (diff) | |
[1.2.X] Migrated null_fk_ordering doctests. Thanks to Stephan Jaekel.
Backport of r13933 from trunk.
git-svn-id: http://code.djangoproject.com/svn/django/branches/releases/1.2.X@13941 bcc190cf-cafb-0310-a4f2-bffc1f526a37
| -rw-r--r-- | tests/regressiontests/null_fk_ordering/models.py | 37 | ||||
| -rw-r--r-- | tests/regressiontests/null_fk_ordering/tests.py | 39 |
2 files changed, 39 insertions, 37 deletions
diff --git a/tests/regressiontests/null_fk_ordering/models.py b/tests/regressiontests/null_fk_ordering/models.py index dd81706dcd..d0635e8acc 100644 --- a/tests/regressiontests/null_fk_ordering/models.py +++ b/tests/regressiontests/null_fk_ordering/models.py @@ -47,40 +47,3 @@ class Comment(models.Model): def __unicode__(self): return self.comment_text - - -__test__ = {'API_TESTS': """ -# Regression test for #7512 -- ordering across nullable Foreign Keys shouldn't -# exclude results ->>> author_1 = Author.objects.create(name='Tom Jones') ->>> author_2 = Author.objects.create(name='Bob Smith') ->>> article_1 = Article.objects.create(title='No author on this article') ->>> article_2 = Article.objects.create(author=author_1, title='This article written by Tom Jones') ->>> article_3 = Article.objects.create(author=author_2, title='This article written by Bob Smith') - -# We can't compare results directly (since different databases sort NULLs to -# different ends of the ordering), but we can check that all results are -# returned. ->>> len(list(Article.objects.all())) == 3 -True - ->>> s = SystemInfo.objects.create(system_name='System Info') ->>> f = Forum.objects.create(system_info=s, forum_name='First forum') ->>> p = Post.objects.create(forum=f, title='First Post') ->>> c1 = Comment.objects.create(post=p, comment_text='My first comment') ->>> c2 = Comment.objects.create(comment_text='My second comment') ->>> s2 = SystemInfo.objects.create(system_name='More System Info') ->>> f2 = Forum.objects.create(system_info=s2, forum_name='Second forum') ->>> p2 = Post.objects.create(forum=f2, title='Second Post') ->>> c3 = Comment.objects.create(comment_text='Another first comment') ->>> c4 = Comment.objects.create(post=p2, comment_text='Another second comment') - -# We have to test this carefully. Some databases sort NULL values before -# everything else, some sort them afterwards. So we extract the ordered list -# and check the length. Before the fix, this list was too short (some values -# were omitted). ->>> len(list(Comment.objects.all())) == 4 -True - -""" -} diff --git a/tests/regressiontests/null_fk_ordering/tests.py b/tests/regressiontests/null_fk_ordering/tests.py new file mode 100644 index 0000000000..c9ee4f7b1a --- /dev/null +++ b/tests/regressiontests/null_fk_ordering/tests.py @@ -0,0 +1,39 @@ +from django.test import TestCase + +from regressiontests.null_fk_ordering.models import * + +class NullFkOrderingTests(TestCase): + + def test_ordering_across_null_fk(self): + """ + Regression test for #7512 + + ordering across nullable Foreign Keys shouldn't exclude results + """ + author_1 = Author.objects.create(name='Tom Jones') + author_2 = Author.objects.create(name='Bob Smith') + article_1 = Article.objects.create(title='No author on this article') + article_2 = Article.objects.create(author=author_1, title='This article written by Tom Jones') + article_3 = Article.objects.create(author=author_2, title='This article written by Bob Smith') + + # We can't compare results directly (since different databases sort NULLs to + # different ends of the ordering), but we can check that all results are + # returned. + self.assertTrue(len(list(Article.objects.all())) == 3) + + s = SystemInfo.objects.create(system_name='System Info') + f = Forum.objects.create(system_info=s, forum_name='First forum') + p = Post.objects.create(forum=f, title='First Post') + c1 = Comment.objects.create(post=p, comment_text='My first comment') + c2 = Comment.objects.create(comment_text='My second comment') + s2 = SystemInfo.objects.create(system_name='More System Info') + f2 = Forum.objects.create(system_info=s2, forum_name='Second forum') + p2 = Post.objects.create(forum=f2, title='Second Post') + c3 = Comment.objects.create(comment_text='Another first comment') + c4 = Comment.objects.create(post=p2, comment_text='Another second comment') + + # We have to test this carefully. Some databases sort NULL values before + # everything else, some sort them afterwards. So we extract the ordered list + # and check the length. Before the fix, this list was too short (some values + # were omitted). + self.assertTrue(len(list(Comment.objects.all())) == 4) |
