Returns expression transformer
Returns expression transformer
Returns error message expression string for resolver
Returns error message expression string for resolver
view name this expression is from
field name this expression is from or null
"filter" or "resolver" for now
Returns resolver expression string - db function call to check resolver result and throw exception when result is not unique or is missing.
Returns resolver expression string - db function call to check resolver result and throw exception when result is not unique or is missing. This is important to avoid silent deletion of data from db. Default implementation is
s"checked_resolve(_, array($queryString), $errorMessage)"
For postgresql bigint and string resolvers checked_resolve
db function can be defined as:
create or replace function checked_resolve(resolvable text, resolved bigint[], error_message text) returns bigint as $$ begin if array_length(resolved, 1) > 1 or resolvable is not null and resolved[1] is null then raise exception sqlstate '235BX' using message = error_message; else return resolved[1]; end if; end; $$ language plpgsql immutable; create or replace function checked_resolve(resolvable text, resolved text[], error_message text) returns text as $$ begin if array_length(resolved, 1) > 1 or resolvable is not null and resolved[1] is null then raise exception sqlstate '235BX' using message = error_message; else return resolved[1]; end if; end; $$ language plpgsql immutable;
Returns transformed expression
Returns transformed expression
expression to be transformed
view this expression is from
field name this expression is from or null
yaml section this expression is from
base table alias for filter transformation
path to alias map for this query
Returns transformed expression
Returns transformed expression
expression to be transformed
view this expression is from
field this expression is from or null
yaml section this expression is from
base table alias for filter transformation
path to alias map for this query