turbot/github

steampipe plugin install githubsteampipe plugin install github
On This Page
Get Involved

Table: github_commit

Commits for a repository.

The github_commit table can be used to query information about any commit, and you must specify which repository in the where or join clause using the repository_full_name column.

Examples

Recent commits

select
sha,
author_login,
author_date,
message
from
github_commit
where
repository_full_name = 'turbot/steampipe'
order by
author_date desc;

Commits by a given author

select
sha,
author_date,
message
from
github_commit
where
repository_full_name = 'turbot/steampipe'
and author_login = 'e-gineer'
order by
author_date desc;

Contributions by author

select
author_login,
count(*)
from
github_commit
where
repository_full_name = 'turbot/steampipe'
group by
author_login
order by
count desc;

Commits that were not verified

select
sha,
author_login,
author_date
from
github_commit
where
repository_full_name = 'turbot/steampipe'
and not verified
order by
author_date desc;

.inspect github_commit

GitHub Commits bundle project files for download by users.

NameTypeDescription
author_datetimestamp without time zoneTimestamp when the author made this commit.
author_logintextThe login name of the author of the commit.
comments_urltextComments URL of the commit.
commitjsonbCommit details.
committer_datetimestamp without time zoneTimestamp when the committer made this commit.
committer_logintextThe login name of committer of the commit.
filesjsonbFiles of the commit.
html_urltextHTML URL of the commit.
messagetextCommit message.
node_idtextNode where GitHub stores this data internally.
parentsjsonbParent commits of the commit.
repository_full_nametextFull name of the repository that contains the commit.
shatextSHA of the commit.
statsjsonbStatistics of the commit.
urltextURL of the commit.
verifiedbooleanTrue if the commit was verified with a signature.