summaryrefslogtreecommitdiff
path: root/tests/db_functions/tests.py
diff options
context:
space:
mode:
authordjango-bot <ops@djangoproject.com>2022-02-03 20:24:19 +0100
committerMariusz Felisiak <felisiak.mariusz@gmail.com>2022-02-07 20:37:05 +0100
commit9c19aff7c7561e3a82978a272ecdaad40dda5c00 (patch)
treef0506b668a013d0063e5fba3dbf4863b466713ba /tests/db_functions/tests.py
parentf68fa8b45dfac545cfc4111d4e52804c86db68d3 (diff)
Refs #33476 -- Reformatted code with Black.
Diffstat (limited to 'tests/db_functions/tests.py')
-rw-r--r--tests/db_functions/tests.py72
1 files changed, 39 insertions, 33 deletions
diff --git a/tests/db_functions/tests.py b/tests/db_functions/tests.py
index e6d8a4fa0a..e5b73cdaac 100644
--- a/tests/db_functions/tests.py
+++ b/tests/db_functions/tests.py
@@ -1,4 +1,5 @@
-from django.db.models import CharField, Value as V
+from django.db.models import CharField
+from django.db.models import Value as V
from django.db.models.functions import Coalesce, Length, Upper
from django.test import TestCase
from django.test.utils import register_lookup
@@ -11,62 +12,67 @@ class UpperBilateral(Upper):
class FunctionTests(TestCase):
-
def test_nested_function_ordering(self):
- Author.objects.create(name='John Smith')
- Author.objects.create(name='Rhonda Simpson', alias='ronny')
+ Author.objects.create(name="John Smith")
+ Author.objects.create(name="Rhonda Simpson", alias="ronny")
- authors = Author.objects.order_by(Length(Coalesce('alias', 'name')))
+ authors = Author.objects.order_by(Length(Coalesce("alias", "name")))
self.assertQuerysetEqual(
- authors, [
- 'Rhonda Simpson',
- 'John Smith',
+ authors,
+ [
+ "Rhonda Simpson",
+ "John Smith",
],
- lambda a: a.name
+ lambda a: a.name,
)
- authors = Author.objects.order_by(Length(Coalesce('alias', 'name')).desc())
+ authors = Author.objects.order_by(Length(Coalesce("alias", "name")).desc())
self.assertQuerysetEqual(
- authors, [
- 'John Smith',
- 'Rhonda Simpson',
+ authors,
+ [
+ "John Smith",
+ "Rhonda Simpson",
],
- lambda a: a.name
+ lambda a: a.name,
)
def test_func_transform_bilateral(self):
with register_lookup(CharField, UpperBilateral):
- Author.objects.create(name='John Smith', alias='smithj')
- Author.objects.create(name='Rhonda')
- authors = Author.objects.filter(name__upper__exact='john smith')
+ Author.objects.create(name="John Smith", alias="smithj")
+ Author.objects.create(name="Rhonda")
+ authors = Author.objects.filter(name__upper__exact="john smith")
self.assertQuerysetEqual(
- authors.order_by('name'), [
- 'John Smith',
+ authors.order_by("name"),
+ [
+ "John Smith",
],
- lambda a: a.name
+ lambda a: a.name,
)
def test_func_transform_bilateral_multivalue(self):
with register_lookup(CharField, UpperBilateral):
- Author.objects.create(name='John Smith', alias='smithj')
- Author.objects.create(name='Rhonda')
- authors = Author.objects.filter(name__upper__in=['john smith', 'rhonda'])
+ Author.objects.create(name="John Smith", alias="smithj")
+ Author.objects.create(name="Rhonda")
+ authors = Author.objects.filter(name__upper__in=["john smith", "rhonda"])
self.assertQuerysetEqual(
- authors.order_by('name'), [
- 'John Smith',
- 'Rhonda',
+ authors.order_by("name"),
+ [
+ "John Smith",
+ "Rhonda",
],
- lambda a: a.name
+ lambda a: a.name,
)
def test_function_as_filter(self):
- 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")
self.assertQuerysetEqual(
- Author.objects.filter(alias=Upper(V('smithj'))),
- ['John Smith'], lambda x: x.name
+ Author.objects.filter(alias=Upper(V("smithj"))),
+ ["John Smith"],
+ lambda x: x.name,
)
self.assertQuerysetEqual(
- Author.objects.exclude(alias=Upper(V('smithj'))),
- ['Rhonda'], lambda x: x.name
+ Author.objects.exclude(alias=Upper(V("smithj"))),
+ ["Rhonda"],
+ lambda x: x.name,
)