PostGres Function(s) Proxy Feature
Jon November 1, 2021, 11:24 AMAC:
route maps to db function name: api.com/campaigns/get == w4api.campaigns_get
only accept args that are allowed by database function, you can use something similar to below query
SELECT concat(a.entity, '', a.action) as function_name, n.nspname AS schema_name, pg_catalog.pg_get_function_identity_arguments(p.oid) AS function_arguments FROM acl a LEFT JOIN pg_catalog.pg_proc p ON (p.proname=concat(a.entity, '', a.action)) LEFT JOIN pg_catalog.pg_namespace n ON (n.oid = p.pronamespace);
append 'arg_' to all passed in parameters
build out db function that looks like: SELECT * FROM {function name} ('{argument name}' := '{argument value}', ...);
add one day to max_date argument
Jon
November 1, 2021, 11:24 AM
AC:
route maps to db function name: api.com/campaigns/get == w4api.campaigns_get
only accept args that are allowed by database function, you can use something similar to below query
SELECT concat(a.entity, '', a.action) as function_name, n.nspname AS schema_name, pg_catalog.pg_get_function_identity_arguments(p.oid) AS function_arguments FROM acl a LEFT JOIN pg_catalog.pg_proc p ON (p.proname=concat(a.entity, '', a.action)) LEFT JOIN pg_catalog.pg_namespace n ON (n.oid = p.pronamespace);append 'arg_' to all passed in parameters
build out db function that looks like: SELECT * FROM {function name} ('{argument name}' := '{argument value}', ...);
add one day to max_date argument
