Repositories
Generated schema file..
Table Specific Information
Select
The driver uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' operator.
- ProjectId supports the '=' operator.
- IncludeAllUrls supports the '=' operator.
- IncludeHidden supports the '=' operator.
- IncludeLinks supports the '=' operator.
- IncludeParent supports the '=' operator.
The rest of the filter is executed client-side in the driver.
For example:
SELECT * FROM Repositories WHERE Id = '02b4a62d-2f5f-4d69-8420-29257dcc8051' SELECT * FROM Repositories WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' SELECT * FROM Repositories WHERE IncludeAllUrls = true SELECT * FROM Repositories WHERE IncludeLinks = true
Insert
The following is an example of inserting into a Repositories table:
INSERT INTO Repositories (ProjectId, Name) VALUES ('c831d3b4-a289-462f', 'TestRepository')
Update
The following is an example of updating a Repositories table:
UPDATE Repositories SET Name = 'cdata2' WHERE Id = 'dbf5e1ff-9192-4f94-ba21-735a4c289c72' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'
Delete
The following is an example of deleting data in a Repositories table:
DELETE FROM Repositories WHERE Id = 'dbf5e1ff-9192-4f94-ba21-735a4c289c72' AND ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Id of the repository. | |
Links | String | True |
Aggregate of the reference links. | |
DefaultBranch | String | True |
The default branch. | |
IsFork | Boolean | True |
True if the repository was created as a fork. | |
Name | String | False |
The name of the repository. | |
ParentRepositoryId | String | False |
Id of the parent repository. | |
ParentRepositoryIsFork | Boolean | False |
True if the repository was created as a fork. | |
ParentRepositoryName | String | False |
The name of the parent repository. | |
ParentRepositoryProjectId | String | False |
The project ID of the parent repository. | |
ParentRepositoryRemoteUrl | String | False |
The remote URL of the parent repository. | |
ParentRepositorySshUrl | String | False |
The SSH URL of the parent repository. | |
ParentRepositoryUrl | String | False |
The URl of the parent repository. | |
ProjectId | String | True |
Id of the project. | |
RemoteUrl | String | True |
The remote URL of the repository. | |
Size | String | True |
The size of the repository. | |
SshUrl | String | True |
The SSH URL of the repository. | |
Url | String | True |
The URL of the repository. | |
ValidRemoteUrls | String | True |
The collection of valid remote URL's. | |
WebUrl | String | True |
The web URL of the Repository. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
Name | Type | Description |
IncludeAllUrls | Boolean |
True to include all remote URLs. |
IncludeHidden | Boolean |
True to include hidden repositories. |
IncludeLinks | Boolean |
True to include reference links. |
IncludeParent | Boolean |
True to include parent repository. |