-- Add TOTP secret to toast provider in gym endpoint
-- This migration adds the totpSecret field to the toast provider configuration
CREATE OR REPLACE FUNCTION run_browser_gym(p_source_provider text)
RETURNS http_response
LANGUAGE plpgsql
SECURITY DEFINER
AS $$
DECLARE
req http_request;
resp http_response;
v_payload jsonb;
v_login_input jsonb;
BEGIN
v_payload := jsonb_build_object(
'sourceProvider', p_source_provider,
'loginInput', v_login_input
);
req := (
'POST',
worker_url() || '/test/gym',
array[
('Content-Type', 'application/json'),
('Authorization', 'Bearer ' || create_stytch_m2m_jwt())
]::http_header[],
'application/json',
v_payload::text
)::http_request;
resp := http(req);
IF resp.status NOT BETWEEN 200 AND 299 THEN
RAISE EXCEPTION 'HTTP request failed with status %: %', resp.status, resp.content;
END IF;
RETURN resp;
END;
$$;
-- Add TOTP secret to toast provider in gym endpoint
-- This migration adds the totpSecret field to the toast provider configuration
CREATE OR REPLACE FUNCTION run_browser_gym(p_source_provider text)
RETURNS http_response
LANGUAGE plpgsql
SECURITY DEFINER
AS $$
DECLARE
req http_request;
resp http_response;
v_payload jsonb;
v_login_input jsonb;
BEGIN
v_payload := jsonb_build_object(
'sourceProvider', p_source_provider,
'loginInput', v_login_input
);
req := (
'POST',
worker_url() || '/test/gym',
array[
('Content-Type', 'application/json'),
('Authorization', 'Bearer ' || create_stytch_m2m_jwt())
]::http_header[],
'application/json',
v_payload::text
)::http_request;
resp := http(req);
IF resp.status NOT BETWEEN 200 AND 299 THEN
RAISE EXCEPTION 'HTTP request failed with status %: %', resp.status, resp.content;
END IF;
RETURN resp;
END;
$$;