turbot/bitbucket
steampipe plugin install bitbucket

Table: bitbucket_commit - Query Bitbucket Commits using SQL

Bitbucket is a web-based version control repository hosting service owned by Atlassian, for source code and development projects that use either Mercurial or Git revision control systems. Bitbucket offers both commercial plans and free accounts. It provides a way to manage and maintain versioning of source code, manage projects, work on your applications, and deploy them in a team environment.

Table Usage Guide

The bitbucket_commit table provides insights into each commit made in the Bitbucket repositories. As a DevOps engineer or a developer, explore commit-specific details through this table, including commit messages, author details, and associated metadata. Utilize it to track changes, understand version history, and manage your development workflow more effectively.

Important Notes

  • You must specify the repository_full_name in the where clause in order to query this table.

Examples

List the commits in a repository

Discover the segments that have made changes in a specific repository. This can be used to track changes, understand the context of modifications, and identify the contributors involved.

select
repository_full_name,
hash,
message,
author_display_name,
author_uuid
from
bitbucket_commit
where
repository_full_name = 'sayan97tb/stmp-rep';
select
repository_full_name,
hash,
message,
author_display_name,
author_uuid
from
bitbucket_commit
where
repository_full_name = 'sayan97tb/stmp-rep';

List the commits by a specific author

Explore the specific contributions made by an individual author within a particular repository. This could be useful for assessing their productivity or understanding the nature of their contributions.

select
repository_full_name,
hash,
message,
author_display_name,
author_uuid
from
bitbucket_commit
where
repository_full_name = 'sayan97tb/stmp-rep'
and author_display_name = 'sayan';
select
repository_full_name,
hash,
message,
author_display_name,
author_uuid
from
bitbucket_commit
where
repository_full_name = 'sayan97tb/stmp-rep'
and author_display_name = 'sayan';

Schema for bitbucket_commit

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
author_account_idtextThe account id of the author of the commit.
author_display_nametextThe display name of the author of the commit.
author_self_linktextThe self link of the author of the commit.
author_typetextThe type of the author of the commit.
author_uuidtextThe UUID of the author of the commit.
hashtext=The hash id of the commit.
messagetextThe message of the commit.
parentsjsonbDetails of parent commit (if any).
repository_full_nametext=The repository's full name.
repository_nametextThe repository's name (slug).
repository_self_linktextThe self link of the repository that contains the commit.
repository_uuidtextThe UUID of the repository that contains the commit.
self_linktextThe self link of the commit.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
summaryjsonbA brief summary of the commit.
typetextThe type of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- bitbucket

You can pass the configuration to the command with the --config argument:

steampipe_export_bitbucket --config '<your_config>' bitbucket_commit