turbot/github

steampipe plugin install githubsteampipe plugin install github

Table: github_tag

Tags mark specific commits in a repository history.

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

Examples

List tags

select
name,
commit_sha
from
github_tag
where
repository_full_name = 'turbot/steampipe'

Order tags by semantic version

select
name,
commit_sha
from
github_tag
where
repository_full_name = 'turbot/steampipe'
order by
string_to_array(regexp_replace(name, '[^0-9\.]', '', 'g'), '.')::int[],
name;

Get commit details for each tag (Not working yet)

Note: This example is intended to join tags with commit information to return the full details of each item. Currently joins with multiple columns are not working pending a solution to #47.

select
t.name,
t.commit_sha,
c.author_date,
c.message
from
github_tag as t,
github_commit as c
where
t.repository_full_name = 'turbot/steampipe'
and t.repository_full_name = c.repository_full_name
and t.commit_sha = c.sha
order by
c.author_date desc;

.inspect github_tag

Tags for commits in the given repository.

NameTypeDescription
commit_shatextCommit SHA the tag refers to.
commit_urltextCommit URL the tag refers to.
nametextName of the tag.
repository_full_nametextFull name of the repository that contains the tag.
tarball_urltextURL to download a tar file of the code for this tag.
zipball_urltextURL to download a zip file of the code for this tag.