Debian Codegraph @

tests/backends/test_utils.py

raw
1 """Tests for django.db.backends.utils"""
2
3 from decimal import Decimal, Rounded
4
5 from django.db import NotSupportedError, connection
6 from django.db.backends.utils import (
7 format_number,
8 split_identifier,
9 split_tzname_delta,
10 truncate_name,
11 )
12 from django.test import (
13 SimpleTestCase,
14 TransactionTestCase,
15 skipIfDBFeature,
16 skipUnlessDBFeature,
17 )
18
19
20 class TestUtils(SimpleTestCase):
21 def test_truncate_name(self):
22 self.assertEqual(truncate_name("some_table", 10), "some_table")
23 self.assertEqual(truncate_name("some_long_table", 10), "some_la38a")
24 self.assertEqual(truncate_name("some_long_table", 10, 3), "some_loa38")
25 self.assertEqual(truncate_name("some_long_table"), "some_long_table")
26 # "user"."table" syntax
27 self.assertEqual(
28 truncate_name('username"."some_table', 10), 'username"."some_table'
29 )
30 self.assertEqual(
31 truncate_name('username"."some_long_table', 10), 'username"."some_la38a'
32 )
33 self.assertEqual(
34 truncate_name('username"."some_long_table', 10, 3), 'username"."some_loa38'
35 )
36
37 def test_split_identifier(self):
38 self.assertEqual(split_identifier("some_table"), ("", "some_table"))
39 self.assertEqual(split_identifier('"some_table"'), ("", "some_table"))
40 self.assertEqual(
41 split_identifier('namespace"."some_table'), ("namespace", "some_table")
42 )
43 self.assertEqual(
44 split_identifier('"namespace"."some_table"'), ("namespace", "some_table")
45 )
46
47 def test_format_number(self):
48 def equal(value, max_d, places, result):
49 self.assertEqual(format_number(Decimal(value), max_d, places), result)
50
51 equal("0", 12, 3, "0.000")
52 equal("0", 12, 8, "0.00000000")
53 equal("1", 12, 9, "1.000000000")
54 equal("0.00000000", 12, 8, "0.00000000")
55 equal("0.000000004", 12, 8, "0.00000000")
56 equal("0.000000008", 12, 8, "0.00000001")
57 equal("0.000000000000000000999", 10, 8, "0.00000000")
58 equal("0.1234567890", 12, 10, "0.1234567890")
59 equal("0.1234567890", 12, 9, "0.123456789")
60 equal("0.1234567890", 12, 8, "0.12345679")
61 equal("0.1234567890", 12, 5, "0.12346")
62 equal("0.1234567890", 12, 3, "0.123")
63 equal("0.1234567890", 12, 1, "0.1")
64 equal("0.1234567890", 12, 0, "0")
65 equal("0.1234567890", None, 0, "0")
66 equal("1234567890.1234567890", None, 0, "1234567890")
67 equal("1234567890.1234567890", None, 2, "1234567890.12")
68 equal("0.1234", 5, None, "0.1234")
69 equal("123.12", 5, None, "123.12")
70
71 with self.assertRaises(Rounded):
72 equal("0.1234567890", 5, None, "0.12346")
73 with self.assertRaises(Rounded):
74 equal("1234567890.1234", 5, None, "1234600000")
75
76 def test_split_tzname_delta(self):
77 tests = [
78 ("Asia/Ust+Nera", ("Asia/Ust+Nera", None, None)),
79 ("Asia/Ust-Nera", ("Asia/Ust-Nera", None, None)),
80 ("Asia/Ust+Nera-02:00", ("Asia/Ust+Nera", "-", "02:00")),
81 ("Asia/Ust-Nera+05:00", ("Asia/Ust-Nera", "+", "05:00")),
82 ("America/Coral_Harbour-01:00", ("America/Coral_Harbour", "-", "01:00")),
83 ("America/Coral_Harbour+02:30", ("America/Coral_Harbour", "+", "02:30")),
84 ("UTC+15:00", ("UTC", "+", "15:00")),
85 ("UTC-04:43", ("UTC", "-", "04:43")),
86 ("UTC", ("UTC", None, None)),
87 ("UTC+1", ("UTC+1", None, None)),
88 ]
89 for tzname, expected in tests:
90 with self.subTest(tzname=tzname):
91 self.assertEqual(split_tzname_delta(tzname), expected)
92
93
94 class CursorWrapperTests(TransactionTestCase):
95 available_apps = []
96
97 def _test_procedure(self, procedure_sql, params, param_types, kparams=None):
98 with connection.cursor() as cursor:
99 cursor.execute(procedure_sql)
100 # Use a new cursor because in MySQL a procedure can't be used in the
101 # same cursor in which it was created.
102 with connection.cursor() as cursor:
103 cursor.callproc("test_procedure", params, kparams)
104 with connection.schema_editor() as editor:
105 editor.remove_procedure("test_procedure", param_types)
106
107 @skipUnlessDBFeature("create_test_procedure_without_params_sql")
108 def test_callproc_without_params(self):
109 self._test_procedure(
110 connection.features.create_test_procedure_without_params_sql, [], []
111 )
112
113 @skipUnlessDBFeature("create_test_procedure_with_int_param_sql")
114 def test_callproc_with_int_params(self):
115 self._test_procedure(
116 connection.features.create_test_procedure_with_int_param_sql,
117 [1],
118 ["INTEGER"],
119 )
120
121 @skipUnlessDBFeature(
122 "create_test_procedure_with_int_param_sql", "supports_callproc_kwargs"
123 )
124 def test_callproc_kparams(self):
125 self._test_procedure(
126 connection.features.create_test_procedure_with_int_param_sql,
127 [],
128 ["INTEGER"],
129 {"P_I": 1},
130 )
131
132 @skipIfDBFeature("supports_callproc_kwargs")
133 def test_unsupported_callproc_kparams_raises_error(self):
134 msg = (
135 "Keyword parameters for callproc are not supported on this database "
136 "backend."
137 )
138 with self.assertRaisesMessage(NotSupportedError, msg):
139 with connection.cursor() as cursor:
140 cursor.callproc("test_procedure", [], {"P_I": 1})