| 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}) |