Projects are used by teams to organize repositories.
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
Get information about my projects
selectname,uuid,key as project_key,workspace_slug,owner_display_name,is_private,createdfrombitbucket_my_project;
List count of repositories by project
selectcount(*),project_key,project_name,owner_display_namefrombitbucket_my_repositorygroup byproject_key,project_name,owner_display_nameorder byproject_name;
List count of my repositories by project
selectcount(r.project_key),p.key as project_key,p.name as project_name,p.owner_display_namefrombitbucket_my_project as pleft join bitbucket_my_repository as r on r.project_key = p.keygroup byp.key,p.name,p.owner_display_nameorder bycount,p.name;
A Bitbucket project. Projects are used by teams to organize repositories.
|created||timestamp without time zone||Timestamp when project was last updated.|
|description||text||A usefule description for thr project.|
|is_private||boolean||Indicates 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.|
|key||text||The project's key.|
|name||text||The name of the project.|
|owner_display_name||text||Display name of the owner of this project.|
|owner_type||text||Type of the owner of this project.|
|owner_uuid||text||UUID of the owner of this project.|
|self_link||text||A self link to this project.|
|title||text||Title of the resource.|
|type||text||Type of the Bitbucket resource.|
|updated||timestamp without time zone||Timestamp when project was last updated.|
|uuid||text||The project's immutable id.|
|workspace_slug||text||Slug name of the workspace to which this project belongs.|