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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
author_account_id	text		The account id of the author of the commit.
author_display_name	text		The display name of the author of the commit.
author_self_link	text		The self link of the author of the commit.
author_type	text		The type of the author of the commit.
author_uuid	text		The UUID of the author of the commit.
hash	text	=	The hash id of the commit.
message	text		The message of the commit.
parents	jsonb		Details of parent commit (if any).
repository_full_name	text	=	The repository's full name.
repository_name	text		The repository's name (slug).
repository_self_link	text		The self link of the repository that contains the commit.
repository_uuid	text		The UUID of the repository that contains the commit.
self_link	text		The self link of the commit.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
summary	jsonb		A brief summary of the commit.
type	text		The 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