| 33 | ) |
| 34 | |
| 35 | def test_order_by(self): |
| 36 | Author.objects.create(name="Terry Pratchett") |
| 37 | Author.objects.create(name="J. R. R. Tolkien") |
| 38 | Author.objects.create(name="George. R. R. Martin") |
| 39 | self.assertQuerySetEqual( |
| 40 | Author.objects.order_by(StrIndex("name", Value("R.")).asc()), |
| 41 | [ |
| 42 | "Terry Pratchett", |
| 43 | "J. R. R. Tolkien", |
| 44 | "George. R. R. Martin", |
| 45 | ], |
| 46 | lambda a: a.name, |
| 47 | ) |
| 48 | self.assertQuerySetEqual( |
| 49 | Author.objects.order_by(StrIndex("name", Value("R.")).desc()), |
| 50 | [ |
| 51 | "George. R. R. Martin", |
| 52 | "J. R. R. Tolkien", |
| 53 | "Terry Pratchett", |
| 54 | ], |
| 55 | lambda a: a.name, |
| 56 | ) |
| 57 | |
| 58 | def test_unicode_values(self): |
| 59 | Author.objects.create(name="ツリー") |