CData Python Connector for Azure DevOps

Build 24.0.9060

TestConfigurations

Retrieves a list test configurations.

Table Specific Information

Select

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

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

For example:

	
	SELECT * FROM TestConfigurations WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4'
	SELECT * FROM TestConfigurations WHERE ProjectId = '1e313382-5f07-43be-b5ae-1dcfa51ffaf4' AND Id = 7

Insert

The following is an example of inserting into a TestConfigurations table:

INSERT INTO TestConfigurations (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'cdata')

Update

The following is an example of updating a TestConfigurations table:

UPDATE TestConfigurations SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'

Delete

The following is an example of deleting data in a TestConfigurations table:

DELETE FROM TestConfigurations WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '1'

Columns

Name Type ReadOnly References Description
Id [KEY] Integer True

Id of the Test Configuration.

ProjectId String True

Id of the Project.

ProjectName String True

Name of the Project.

Description String False

Description of the test configuration.

IsDefault Boolean False

Is the configuration a default for the test plans.

Name String False

Name of the configuration.

State String False

State of the configuration.

Values String False

Dictionary of Test Variable, Selected Value.

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