Allows for some logging and debugging of PostgREST requests. All the x-* headers set by the reverse proxy.

audit.api_request().sql

create or replace function audit.api_request() returns void
  language plpgsql
  as $$
declare
	
	_request_id text := coalesce(current_setting('request.header.x-request-id', true),'');
	_role text := coalesce(current_setting('request.jwt.claim.role', true),'');
	_user_id text := coalesce(current_setting('request.jwt.claim.id', true),'');
	_resource text := coalesce(current_setting('request.header.x-path', true),'');
	_verb text := coalesce(current_setting('request.header.x-verb', true),'');
	_qs_id text := coalesce(current_setting('request.header.x-qs-id', true),'not-set');
	
	_query text;

begin

  	raise log 'PostgREST: [%] JWT claim: (%:%) Resource: %:%; Query args: id=%', 
  		_request_id,
  		_role,
  		_user_id,
  		_verb,
  		_resource,
  		_qs_id;

	-- Create another connection and use it to write the action to a log table:
	
	-- _query := 'insert into audit.requests (user_id,resource,action,role) values ';
	-- _query := _query || '($user_id$, $resource$, $verb$, $role$)';
	-- _query := replace(_query, '$user_id$'::text, quote_literal(_user_id));
	-- _query := replace(_query, '$resource$'::text, quote_literal(lower(_resource)));
	-- _query := replace(_query, '$verb$'::text, quote_literal(lower(_verb)));
	-- _query := replace(_query, '$role$'::text, quote_literal(lower(_role)));

	-- raise notice '%', _query;

	-- PERFORM dblink_connect_u('dblink_audit','dbname=db');
	-- PERFORM dblink('dblink_audit', _query);
	-- PERFORM dblink('dblink_audit','COMMIT;');
	-- PERFORM dblink_disconnect('dblink_audit'); 

end
$$;