turbot/github_compliance
GitHub

Query: repo_open_branches_are_upto_date_before_merge

Usage

steampipe query github_compliance.query.repo_open_branches_are_upto_date_before_merge

Plugins & Tables

SQL

select
-- Required Columns
url as resource,
case
when (default_branch_ref -> 'branch_protection_rule') is null then 'info'
when (
default_branch_ref -> 'branch_protection_rule' ->> 'requires_strict_status_checks'
) :: bool = true then 'ok'
else 'alarm'
end as status,
name_with_owner || ' default branch ' || (default_branch_ref ->> 'name') || case
when (default_branch_ref -> 'branch_protection_rule') is null then ' branch protection rule unknown.'
when (
default_branch_ref -> 'branch_protection_rule' ->> 'requires_strict_status_checks'
) :: bool = true then ' requires open branches to be upto date before merge.'
else ' does not require open branches to be upto date before merge.'
end as reason,
-- Additional Dimensions
name_with_owner
from
github_my_repository;

Controls

The query is being used by the following controls: