Query: security_headers_content_security_policy_check

select
  case
    when response_headers -> 'Content-Security-Policy' is not null then 'Present'
    else 'Missing'
  end as value,
  case
    when response_headers -> 'Content-Security-Policy' is not null then 'ok'
    else 'alert'
  end as type,
  'Content-Security-Policy' as label
from
  net_http_request
where
  url = $1;