JDBC Driver for Bitbucket

Build 24.0.9062

Projects

Projects in a workspace.

Table Specific Information

Select

The 本製品 uses the Bitbucket API to process WHERE clause conditions built with the below columns. Filtering on other columns is processed client-side within the 本製品.

  • UUID
  • Key
  • Name
  • Description
  • IsPrivate
  • CreatedOn
  • UpdatedOn

The 本製品 uses the Bitbucket API to process ORDER BY clause conditions built with the below columns. Sorting on other columns is processed client-side within the 本製品.

  • UUID
  • Key
  • Name
  • Description
  • IsPrivate
  • CreatedOn
  • UpdatedOn

For example, the following query is processed server side:

SELECT * FROM Projects WHERE Name='Project2'

Insert

To create a new project, you must specify the Key and Name fields. You can also, optionally, specify the Description and IsPrivate fields.

A sample INSERT is included below:

INSERT INTO Projects (Key, Name) VALUES ('TEST', 'TestProj')

Update

A sample UPDATE is included below:
UPDATE Projects SET IsPrivate=true WHERE Key='PROJ'

Delete

You cannot delete a project that still contains repositories. If you want to delete a project, you must first either delete all existing repositories or move them to a different project.

A sample DELETE is included below:

DELETE FROM Projects WHERE Key='PROJ'

Columns

Name Type ReadOnly References Description
UUID String True

The project's immutable id.

Key [KEY] String False

The project's key.

Name String False

The name of the project.

Description String False

Description of the project.

IsPrivate Bool False

Whether the project is publicly accessible, or private to the team and only visible to team members.

CreatedOn Datetime True

When the project was created.

UpdatedOn Datetime True

When the project was updated.

HasPubliclyVisibleRepos Bool True

Indicates whether the project contains publicly visible repositories.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062