diff options
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/schema/tests.py | 44 |
1 files changed, 43 insertions, 1 deletions
diff --git a/tests/schema/tests.py b/tests/schema/tests.py index fff4982315..740cd5b0d0 100644 --- a/tests/schema/tests.py +++ b/tests/schema/tests.py @@ -54,7 +54,16 @@ from django.db.models import ( Value, ) from django.db.models.fields.json import KT, KeyTextTransform -from django.db.models.functions import Abs, Cast, Collate, Lower, Random, Round, Upper +from django.db.models.functions import ( + Abs, + Cast, + Collate, + Concat, + Lower, + Random, + Round, + Upper, +) from django.db.models.indexes import IndexExpression from django.db.transaction import TransactionManagementError, atomic from django.test import ( @@ -893,6 +902,39 @@ class SchemaTests(TransactionTestCase): editor.create_model(GeneratedFieldOutputFieldModel) @isolate_apps("schema") + @skipUnlessDBFeature("supports_stored_generated_columns") + def test_add_generated_field_contains(self): + class GeneratedFieldContainsModel(Model): + text = TextField(default="foo") + generated = GeneratedField( + expression=Concat("text", Value("%")), + db_persist=True, + output_field=TextField(), + ) + + class Meta: + app_label = "schema" + + with connection.schema_editor() as editor: + editor.create_model(GeneratedFieldContainsModel) + + field = GeneratedField( + expression=Q(text__icontains="FOO"), + db_persist=True, + output_field=BooleanField(), + ) + field.contribute_to_class(GeneratedFieldContainsModel, "contains_foo") + + with connection.schema_editor() as editor: + editor.add_field(GeneratedFieldContainsModel, field) + + obj = GeneratedFieldContainsModel.objects.create() + obj.refresh_from_db() + self.assertEqual(obj.text, "foo") + self.assertEqual(obj.generated, "foo%") + self.assertIs(obj.contains_foo, True) + + @isolate_apps("schema") def test_add_auto_field(self): class AddAutoFieldModel(Model): name = CharField(max_length=255, primary_key=True) |