turbot/bitbucket

steampipe plugin install bitbucketsteampipe plugin install bitbucket

Table: bitbucket_my_project

Projects are used by teams to organize repositories.

The bitbucket_my_repository table will lists projects your user have access or that belong to your workspaces.

To query ANY project, including public projects, use the bitbucket_my_repository table.

Examples

Get information about my projects

select
name,
uuid,
key as project_key,
workspace_slug,
owner_display_name,
is_private,
created
from
bitbucket_my_project;

List count of repositories by project

select
count(*),
project_key,
project_name,
owner_display_name
from
bitbucket_my_repository
group by
project_key,
project_name,
owner_display_name
order by
project_name;

List count of my repositories by project

select
count(r.project_key),
p.key as project_key,
p.name as project_name,
p.owner_display_name
from
bitbucket_my_project as p
left join bitbucket_my_repository as r on r.project_key = p.key
group by
p.key,
p.name,
p.owner_display_name
order by
count,
p.name;

.inspect bitbucket_my_project

A Bitbucket project. Projects are used by teams to organize repositories.

NameTypeDescription
createdtimestamp without time zoneTimestamp when project was last updated.
descriptiontextA usefule description for thr project.
is_privatebooleanIndicates whether the project is publicly accessible, or whether it is private to the team and consequently only visible to team members. Note that private projects cannot contain public repositories.
keytextThe project's key.
nametextThe name of the project.
owner_display_nametextDisplay name of the owner of this project.
owner_typetextType of the owner of this project.
owner_uuidtextUUID of the owner of this project.
self_linktextA self link to this project.
titletextTitle of the resource.
typetextType of the Bitbucket resource.
updatedtimestamp without time zoneTimestamp when project was last updated.
uuidtextThe project's immutable id.
workspace_slugtextSlug name of the workspace to which this project belongs.