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
)
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;