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;

Schema for gitlab_commit

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
author_email	text		The email of the commit author.
author_name	text		The name of the commit author.
authored_date	timestamp with time zone		Timestamp of commit.
commit_additions	bigint		Number of additions made in the commit
commit_deletions	bigint		Number of deletions made in the commit
commit_total_changes	bigint		Total number of changes made in the commit
committed_date	timestamp with time zone		Timestamp of the commit.
committer_email	text		The email address of the committer.
committer_name	text		The name of the committer.
created_at	timestamp with time zone		Timestamp of the creation of commit.
id	text	=	The ID (commit hash) of the commit.
message	text		The commit message.
parent_ids	jsonb		Array of parent commit hashes.
pipeline_created	timestamp with time zone		Timestamp indicating when the last pipeline instance was created.
pipeline_id	bigint		Identifier for the last pipeline instance triggered against the commit
pipeline_ref	text		The ref that the pipeline was run against
pipeline_sha	text		The SHA of the commit the last pipeline instance was run against
pipeline_source	text		Source associated with the pipeline instance
pipeline_status	text		Status of the last pipeline instance triggered against the commit
pipeline_updated	timestamp with time zone		Timestamp indicating when the last pipeline instance was updated.
pipeline_url	text		The URL of the pipeline in the web interface
project_id	bigint	=	The ID of the project containing the commit - link to `gitlab_project.ID`
short_id	text		The short ID (short commit hash) of the commit.
status	text		Build state of the commit
title	text		The title of the commit.
web_url	text		The url of the commit.