Control: License should be added in each public repository

powerpipe control run github_sherlock.control.public_repo_license_added

powerpipe login
powerpipe control run github_sherlock.control.public_repo_license_added --share

select
  url as resource,
  case
    when license_info is not null then 'ok'
    else 'alarm'
  end as status,
  name_with_owner || ' license is ' || case
    when (license_info is not null) then (license_info ->> 'spdx_id')
    else 'not added'
  end || '.' as reason,
  name_with_owner
from
  github_my_repository
where
  visibility = 'PUBLIC'
  and is_fork = false