All queries and dml-s from viewDef for compilation - to test viewDef. Used by sbt-mojoz plugin

Returns expression transformer

Used by expression transformer

Returns resolvables expression for inclusion in resolver, where evaluation to not null enables resolve check.

Returns resolvables expression for inclusion in resolver error message expression

Returns missing var expression for inclusion in resolver error message expression

Returns error message expression for resolver

Returns error message expression for resolver

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;

Provides missing fields, override to convert types to compatible with your jdbc driver

Returns transformed expression