summaryrefslogtreecommitdiff
path: root/tests/db_functions/text/test_left.py
diff options
context:
space:
mode:
Diffstat (limited to 'tests/db_functions/text/test_left.py')
-rw-r--r--tests/db_functions/text/test_left.py26
1 files changed, 17 insertions, 9 deletions
diff --git a/tests/db_functions/text/test_left.py b/tests/db_functions/text/test_left.py
index 873bbf859b..8871f9ac79 100644
--- a/tests/db_functions/text/test_left.py
+++ b/tests/db_functions/text/test_left.py
@@ -8,20 +8,28 @@ from ..models import Author
class LeftTests(TestCase):
@classmethod
def setUpTestData(cls):
- Author.objects.create(name='John Smith', alias='smithj')
- Author.objects.create(name='Rhonda')
+ Author.objects.create(name="John Smith", alias="smithj")
+ Author.objects.create(name="Rhonda")
def test_basic(self):
- authors = Author.objects.annotate(name_part=Left('name', 5))
- self.assertQuerysetEqual(authors.order_by('name'), ['John ', 'Rhond'], lambda a: a.name_part)
+ authors = Author.objects.annotate(name_part=Left("name", 5))
+ self.assertQuerysetEqual(
+ authors.order_by("name"), ["John ", "Rhond"], lambda a: a.name_part
+ )
# If alias is null, set it to the first 2 lower characters of the name.
- Author.objects.filter(alias__isnull=True).update(alias=Lower(Left('name', 2)))
- self.assertQuerysetEqual(authors.order_by('name'), ['smithj', 'rh'], lambda a: a.alias)
+ Author.objects.filter(alias__isnull=True).update(alias=Lower(Left("name", 2)))
+ self.assertQuerysetEqual(
+ authors.order_by("name"), ["smithj", "rh"], lambda a: a.alias
+ )
def test_invalid_length(self):
with self.assertRaisesMessage(ValueError, "'length' must be greater than 0"):
- Author.objects.annotate(raises=Left('name', 0))
+ Author.objects.annotate(raises=Left("name", 0))
def test_expressions(self):
- authors = Author.objects.annotate(name_part=Left('name', Value(3, output_field=IntegerField())))
- self.assertQuerysetEqual(authors.order_by('name'), ['Joh', 'Rho'], lambda a: a.name_part)
+ authors = Author.objects.annotate(
+ name_part=Left("name", Value(3, output_field=IntegerField()))
+ )
+ self.assertQuerysetEqual(
+ authors.order_by("name"), ["Joh", "Rho"], lambda a: a.name_part
+ )