ODBC Driver for Bitbucket

Build 24.0.9060

Repositories

Repositories in a workspace.

Table Specific Information

Select

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

  • UUID
  • Name
  • Slug
  • Description
  • IsPrivate
  • CreatedOn
  • UpdatedOn
  • SCM
  • Size
  • Langage
  • HasIssues
  • HasWiki
  • ProjectKey
  • ParentUUID

The driver 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 driver.

  • UUID
  • Name
  • Slug
  • Description
  • IsPrivate
  • CreatedOn
  • UpdatedOn
  • SCM
  • Size
  • Langage
  • HasIssues
  • HasWiki
  • ForkPolicy
  • ProjectKey
  • ParentUUID

For example, the following query is processed server side:

SELECT * FROM Repositories WHERE Slug='myrepo'

Insert

To create a new repository, you must specify the Slug field. You can also, optionally, specify the Name, Description, IsPrivate, SCM, Language, Website, HasIssues, HasWiki, ForkPolicy, and ProjectKey fields.

To set the project for the newly created repository, include the ProjectKey in the INSERT statement.

A sample INSERT is included below:

INSERT INTO Repositories (Slug) VALUES ('myrepository')

Update

A sample UPDATE is included below:
UPDATE Repositories SET IsPrivate=true WHERE Slug='myrepo'

Delete

A sample DELETE is included below:

DELETE FROM Repositories WHERE Slug='myrepo'

Columns

Name Type ReadOnly References Description
UUID String True

The repository's immutable id.

FullName String True

The concatenation of the repository owner's username and the slug name.

Name String False

Name of the repository.

Slug [KEY] String False

The short label that identifies this repository.

Description String False

Description of the repository.

IsPrivate Bool False

Whether the repository is private.

CreatedOn Datetime True

When the repository was created.

UpdatedOn Datetime True

When the repository was updated.

SCM String False

Source Code Management tool.

Size Int True

Size of the repository.

Language String False

Language of the repository.

Website String False

Website of the repository.

MainbranchName String True

Name of the main branch of the repository.

HasIssues Bool False

Whether the issue tracker for this repository is enabled.

HasWiki Bool False

Whether the wiki for this repository is enabled.

ForkPolicy String False

Rules for forking this repository.

ProjectKey String False

Key to the project linked to this repository.

ParentUUID String True

UUID of the parent repository of this repository.

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