Module pre_query 

Transaction and session variable setup queries.

Before executing the main SQL query, dbrest sets PostgreSQL session variables via set_config() to communicate request context to database functions and triggers. This module generates those setup queries.

Pipeline

HTTP request ──▶ pre_req_query() ──▶ SET search_path, role, claims …
              ──▶ tx_var_query()  ──▶ SET method, path, headers, cookies …

SQL Example

SELECT
  set_config('search_path', '"test_api", "public"', true),
  set_config('role', 'web_anon', true),
  set_config('request.method', 'GET', true),
  set_config('request.path', '/users', true),
  set_config('request.headers', '{"accept":"application/json"}', true),
  set_config('request.cookies', '{}', true)

Functions

pre_req_query

Build the pre-request function call query.

tx_var_query

Build the session variable setup query.