def convert_order(self, name, tables, Model):
fname, _, key = name.partition('.')
if not key:
return super().convert_order(fname, tables, Model)
database = Transaction().database
table, _ = tables[None]
column = self.sql_column(table)
return [database.json_get(column, key)]
def _domain_column(self, operator, column, key=None):
database = Transaction().database
column = database.json_get(super()._domain_column(operator, column),
key)
if operator.endswith('like'):
column = Cast(column, database.sql_type('VARCHAR').base)
if self.search_unaccented and operator.endswith('ilike'):
column = database.unaccent(column)
return column
def _domain_column(self, operator, column):
database = Transaction().database
return database.json_get(super()._domain_column(operator, column))
def _domain_value(self, operator, value):
database = Transaction().database
domain_value = super()._domain_value(operator, value)
if value is not None:
domain_value = database.json_get(domain_value)
return domain_value
