Exemplo n.º 1
0
 def test_trim(self):
     Author.objects.create(name='  John ', alias='j')
     Author.objects.create(name='Rhonda', alias='r')
     authors = Author.objects.annotate(
         ltrim=LTrim('name'),
         rtrim=RTrim('name'),
         trim=Trim('name'),
     )
     self.assertQuerysetEqual(authors.order_by('alias'), [
         ('John ', '  John', 'John'),
         ('Rhonda', 'Rhonda', 'Rhonda'),
     ], lambda a: (a.ltrim, a.rtrim, a.trim))
Exemplo n.º 2
0
 def test_trim(self):
     Author.objects.create(name="  John ", alias="j")
     Author.objects.create(name="Rhonda", alias="r")
     authors = Author.objects.annotate(
         ltrim=LTrim("name"),
         rtrim=RTrim("name"),
         trim=Trim("name"),
     )
     self.assertQuerysetEqual(
         authors.order_by("alias"),
         [
             ("John ", "  John", "John"),
             ("Rhonda", "Rhonda", "Rhonda"),
         ],
         lambda a: (a.ltrim, a.rtrim, a.trim),
     )
Exemplo n.º 3
0
#!/usr/bin/env python
from django.db.models.functions import RTrim
from .models import MyModel
"""
https://docs.djangoproject.com/en/dev/ref/models/database-functions/#rtrim

class RTrim(expression, **extra)
"""

qs = MyModel.objects.annotate(value=RTrim('name'))
for r in qs.all():
    print(r.value)