CData Python Connector for Azure DevOps

Build 24.0.9060

Pushes

Retrieves pushes associated with a repository, sliced across all repositories.

Table Specific Information

Select

The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

The rest of the filter is executed client-side in the connector.


NOTE: RepositoryId is required in order to query Pushes.

  • PushId supports the '=' operator.
  • ProjectId supports the '=' operator.
  • RepositoryId supports the '=' operator.
  • PushedById supports the '=' operator.
  • Date supports the '>=,<' operators.
  • BranchName supports the '=' operator.
For example:
	SELECT * FROM Pushes WHERE RepositoryId = '229ec1a1-609f-4545-af5a-85f00ce7428b'
	SELECT * FROM Pushes WHERE RepositoryId = '229ec1a1-609f-4545-af5a-85f00ce7428b' AND PushId = 16 AND Date >= '2000-01-01'

Insert

The following are examples of inserting into a Pushes table. For example:

INSERT INTO RefUpdates#TEMP (NewObjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'abcd')
INSERT INTO Commits#TEMP (Comment, AuthorName) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'xyz')
INSERT INTO Pushes (ProjectId, RepositoryId, Commits, RefUpdates) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', '84609754-3aa8-4b91-8a56-8ccb48f6d017', Commits#TEMP, RefUpdates#TEMP)

Columns

Name Type ReadOnly References Description
PushId [KEY] Integer True

Id of the push.

ProjectId String True

Id of the project.

Date Datetime True

The date of the push.

PushedByDisplayName String False

The display name of the user.

PushedById String False

The Id of the user.

PushedByUrl String False

The URL of the user.

RepositoryDefaultBranch String False

The default of the repository.

RepositoryId String True

Repositories.Id

The Id of the repository.

RepositoryName String False

Name of the repository.

RepositoryProjectId String False

The Project Id.

RepositoryProjectName String False

The Project name.

RepositoryProjectState String False

The Project state.

RepositoryProjectUrl String False

The Project URL.

RepositoryRemoteUrl String False

The Remote URL of the repository.

RepositoryUrl String False

The URL of the repository.

Url String False

The URL of the push.

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
BranchName String

Branch name.

RefUpdates String

Branch name.

Commits String

List of inputs for the specific task group.

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