Query: ecr_repository_scan_on_push

with scan_on_push as (
  select
    (image_scanning_configuration ->> 'ScanOnPush')::bool as scan
  from
    aws_ecr_repository
  where
    arn = $1
    and region = split_part($1, ':', 4)
    and account_id = split_part($1, ':', 5)
)
select
  'Scan on Push' as label,
  case when scan then 'Enabled' else 'Disabled' end as value,
  case when scan then 'ok' else 'alert' end as type
from
  scan_on_push;