Debian Codegraph @

tests/db_functions/comparison/test_collate.py

raw
1 from django.db import connection
2 from django.db.models import F, Value
3 from django.db.models.functions import Collate
4 from django.test import TestCase
5
6 from ..models import Author
7
8
9 class CollateTests(TestCase):
10 @classmethod
11 def setUpTestData(cls):
12 cls.author1 = Author.objects.create(alias="a", name="Jones 1")
13 cls.author2 = Author.objects.create(alias="A", name="Jones 2")
14
15 def test_collate_filter_ci(self):
16 collation = connection.features.test_collations.get("ci")
17 if not collation:
18 self.skipTest("This backend does not support case-insensitive collations.")
19 qs = Author.objects.filter(alias=Collate(Value("a"), collation))
20 self.assertEqual(qs.count(), 2)
21
22 def test_collate_order_by_cs(self):
23 collation = connection.features.test_collations.get("cs")
24 if not collation:
25 self.skipTest("This backend does not support case-sensitive collations.")
26 qs = Author.objects.order_by(Collate("alias", collation))
27 self.assertSequenceEqual(qs, [self.author2, self.author1])
28
29 def test_language_collation_order_by(self):
30 collation = connection.features.test_collations.get("swedish_ci")
31 if not collation:
32 self.skipTest("This backend does not support language collations.")
33 author3 = Author.objects.create(alias="O", name="Jones")
34 author4 = Author.objects.create(alias="Ö", name="Jones")
35 author5 = Author.objects.create(alias="P", name="Jones")
36 qs = Author.objects.order_by(Collate(F("alias"), collation), "name")
37 self.assertSequenceEqual(
38 qs,
39 [self.author1, self.author2, author3, author5, author4],
40 )
41
42 def test_invalid_collation(self):
43 tests = [
44 None,
45 "",
46 'et-x-icu" OR ',
47 '"schema"."collation"',
48 ]
49 msg = "Invalid collation name: %r."
50 for value in tests:
51 with self.subTest(value), self.assertRaisesMessage(ValueError, msg % value):
52 Collate(F("alias"), value)