changeset 3b899a065dce in trytond:default details: https://hg.tryton.org/trytond?cmd=changeset&node=3b899a065dce description: Add support for SQL expression to sqlite's TRIM
issue10510 review352121003 diffstat: trytond/backend/sqlite/database.py | 7 ++++++- trytond/tests/test_backend.py | 3 ++- 2 files changed, 8 insertions(+), 2 deletions(-) diffs (37 lines): diff -r 701dd4767588 -r 3b899a065dce trytond/backend/sqlite/database.py --- a/trytond/backend/sqlite/database.py Sun Jun 06 09:28:24 2021 +0200 +++ b/trytond/backend/sqlite/database.py Wed Jun 16 14:55:46 2021 +0200 @@ -236,7 +236,12 @@ @property def params(self): - return [self.string, self.characters] + if isinstance(self.string, str): + params = [self.string] + else: + params = list(self.string.params) + params.append(self.characters) + return params def sign(value): diff -r 701dd4767588 -r 3b899a065dce trytond/tests/test_backend.py --- a/trytond/tests/test_backend.py Sun Jun 06 09:28:24 2021 +0200 +++ b/trytond/tests/test_backend.py Wed Jun 16 14:55:46 2021 +0200 @@ -5,7 +5,7 @@ import unittest from sql import Select -from sql import functions +from sql import functions, Literal from sql.functions import CurrentTimestamp, ToChar from trytond.tests.test_tryton import activate_module, with_transaction @@ -127,6 +127,7 @@ # (functions.Substring('Thomas', '...$'), 'mas'), # (functions.Substring('Thomas', '%#"o_a#"_', '#'), 'oma'), (functions.Trim('yxTomxx', 'BOTH', 'xyz'), 'Tom'), + (functions.Trim(Literal('yxTomxxx'), 'BOTH', 'xyz'), "Tom"), (functions.Upper('tom'), 'TOM'), ] for func, result in tests: