turbot/github_sherlock

Control: Contributing guidelines should be added in each public repository

Description

Adding a contributing guideline defines standards for how the community should contribute to the project.

Usage

steampipe check github_sherlock.control.public_repo_contributing_added

Plugins & Tables

SQL

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