Control: Contributing guidelines should be added in each public repository

powerpipe control run github_sherlock.control.public_repo_contributing_added

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

select
  r.url as resource,
  case
    when p.contributing is not null then 'ok'
    else 'alarm'
  end as status,
  r.name_with_owner || case
    when (p.contributing is not null) then ' has '
    else ' has no '
  end || 'contributing guidelines.' as reason,
  r.name_with_owner
from
  github_my_repository as r
  left join github_community_profile as p on r.name_with_owner = p.repository_full_name
where
  visibility = 'PUBLIC'
  and r.is_fork = false