theapsgroup/gitlab

steampipe plugin install theapsgroup/gitlabsteampipe plugin install theapsgroup/gitlab

Table: gitlab_commit

A commit is a change-set to the code.

The gitlab_commit table can be used to query information about any commit.

However, you must specify a project_id in the where or join clause.

Examples

List commits

select
*
from
gitlab_commit
where
project_id = 1;

List commits (by newest first)

select
*
from
gitlab_commit
where
project_id = 1
order by
created_at desc;

Obtain an individual commit

select
*
from
gitlab_commit
where
project_id = 1
and
id = '73012177d1c8eb765bfd952ccfc50c679f147d12';

Contributions by author

select
author_email,
count(*)
from
gitlab_commit
where
project_id = 1
group by
author_email
order by
count desc;

.inspect gitlab_commit

Commits in the given project.

NameTypeDescription
author_emailtextThe email of the commit author.
author_nametextThe name of the commit author.
authored_datetimestamp without time zoneTimestamp of commit.
committed_datetimestamp without time zoneTimestamp of the commit.
committer_emailtextThe email address of the committer.
committer_nametextThe name of the committer.
created_attimestamp without time zoneTimestamp of the creation of commit.
idtextThe ID (commit hash) of the commit.
messagetextThe commit message.
parent_idsjsonbArray of parent commit hashes.
project_idbigintThe ID of the project containing the commit - link to `gitlab_project.ID`
short_idtextThe short ID (short commit hash) of the commit.
titletextThe title of the commit.
web_urltextThe url of the commit.