| 1 |
import unittest |
| 2 |
from decimal import Decimal |
| 3 |
|
| 4 |
from django.db import connection |
| 5 |
from django.db.backends.signals import connection_created |
| 6 |
from django.db.migrations.writer import MigrationWriter |
| 7 |
from django.test import TestCase |
| 8 |
from django.test.utils import CaptureQueriesContext, modify_settings, override_settings |
| 9 |
|
| 10 |
try: |
| 11 |
from django.contrib.postgres.fields import ( |
| 12 |
DateRangeField, |
| 13 |
DateTimeRangeField, |
| 14 |
DecimalRangeField, |
| 15 |
IntegerRangeField, |
| 16 |
) |
| 17 |
from django.contrib.postgres.signals import get_hstore_oids |
| 18 |
from django.db.backends.postgresql.psycopg_any import ( |
| 19 |
DateRange, |
| 20 |
DateTimeRange, |
| 21 |
DateTimeTZRange, |
| 22 |
NumericRange, |
| 23 |
is_psycopg3, |
| 24 |
) |
| 25 |
except ImportError: |
| 26 |
pass |
| 27 |
|
| 28 |
|
| 29 |
@unittest.skipUnless(connection.vendor == "postgresql", "PostgreSQL specific tests") |
| 30 |
class PostgresConfigTests(TestCase): |
| 31 |
def test_install_app_no_warning(self): |
| 32 |
# Clear cache to force queries when (re)initializing the |
| 33 |
# "django.contrib.postgres" app. |
| 34 |
get_hstore_oids.cache_clear() |
| 35 |
with CaptureQueriesContext(connection) as captured_queries: |
| 36 |
with override_settings(INSTALLED_APPS=["django.contrib.postgres"]): |
| 37 |
pass |
| 38 |
self.assertGreaterEqual(len(captured_queries), 1) |
| 39 |
|
| 40 |
def test_register_type_handlers_connection(self): |
| 41 |
from django.contrib.postgres.signals import register_type_handlers |
| 42 |
|
| 43 |
self.assertNotIn( |
| 44 |
register_type_handlers, connection_created._live_receivers(None)[0] |
| 45 |
) |
| 46 |
with modify_settings(INSTALLED_APPS={"append": "django.contrib.postgres"}): |
| 47 |
self.assertIn( |
| 48 |
register_type_handlers, connection_created._live_receivers(None)[0] |
| 49 |
) |
| 50 |
self.assertNotIn( |
| 51 |
register_type_handlers, connection_created._live_receivers(None)[0] |
| 52 |
) |
| 53 |
|
| 54 |
def test_register_serializer_for_migrations(self): |
| 55 |
tests = ( |
| 56 |
(DateRange(empty=True), DateRangeField), |
| 57 |
(DateTimeRange(empty=True), DateRangeField), |
| 58 |
(DateTimeTZRange(None, None, "[]"), DateTimeRangeField), |
| 59 |
(NumericRange(Decimal("1.0"), Decimal("5.0"), "()"), DecimalRangeField), |
| 60 |
(NumericRange(1, 10), IntegerRangeField), |
| 61 |
) |
| 62 |
|
| 63 |
def assertNotSerializable(): |
| 64 |
for default, test_field in tests: |
| 65 |
with self.subTest(default=default): |
| 66 |
field = test_field(default=default) |
| 67 |
with self.assertRaisesMessage( |
| 68 |
ValueError, "Cannot serialize: %s" % default.__class__.__name__ |
| 69 |
): |
| 70 |
MigrationWriter.serialize(field) |
| 71 |
|
| 72 |
assertNotSerializable() |
| 73 |
import_name = "psycopg.types.range" if is_psycopg3 else "psycopg2.extras" |
| 74 |
with self.modify_settings(INSTALLED_APPS={"append": "django.contrib.postgres"}): |
| 75 |
for default, test_field in tests: |
| 76 |
with self.subTest(default=default): |
| 77 |
field = test_field(default=default) |
| 78 |
serialized_field, imports = MigrationWriter.serialize(field) |
| 79 |
self.assertEqual( |
| 80 |
imports, |
| 81 |
{ |
| 82 |
"import django.contrib.postgres.fields.ranges", |
| 83 |
f"import {import_name}", |
| 84 |
}, |
| 85 |
) |
| 86 |
self.assertIn( |
| 87 |
f"{field.__module__}.{field.__class__.__name__}" |
| 88 |
f"(default={import_name}.{default!r})", |
| 89 |
serialized_field, |
| 90 |
) |
| 91 |
assertNotSerializable() |