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 thewhere
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_uuidfrom bitbucket_commitwhere repository_full_name = 'sayan97tb/stmp-rep';
select repository_full_name, hash, message, author_display_name, author_uuidfrom bitbucket_commitwhere 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_uuidfrom bitbucket_commitwhere repository_full_name = 'sayan97tb/stmp-rep' and author_display_name = 'sayan';
select repository_full_name, hash, message, author_display_name, author_uuidfrom bitbucket_commitwhere 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