Column Descriptions and Example Queries

Datastore Columns

The data store tables include the following columns:

cycle_test_execution table

Column Name Description Constraint Required? MSSQL Oracle MySQL DB2 H2
execution_id Unique execution of a test Primary Key nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
execution_start_ts Timestamp of the start of the test datetime2(7) timestamp(6) datetime(3) TIMESTAMP TIMESTAMP
cycle_user The Cycle user who executed the test nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
cycle_version The version of Cycle which executed the test nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
hardware_id The serial number of the computer which executed the test nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
computer_username The user logged into the computer nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
os The OS Version for the computer that executed the test nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
invoker Indicates whether the test was run from Cycle-CLI or the Cycle Client nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)

cycle_execution_results table

Column Name Description Constraint Required? MSSQL Oracle MySQL DB2 H2
execution_id Unique execution of a test Primary Key, Foreign Key nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
node_id Unique ID for an item in a test, e.g., a Step, a Scenario, a Feature, etc. Primary Key nvarchar(255) VARCHAR2(255) varchar(255) VARCHAR(255) VARCHAR(255)
parent_node_id The immediate parent of this node. E.g., the ID of the Scenario to which a Step belongs nvarchar(255) VARCHAR2(255) varchar(255) VARCHAR(255) VARCHAR(255)
sending_node_id The Feature, Playlist, or Group which is the ancestor of this node. This is primarily for sorting data in Group Tests. nvarchar(255) VARCHAR2(255) varchar(255) VARCHAR(255) VARCHAR(255)
node_sequence Used for sorting sequence of nodes within a Feature int int int(11) int int
node_type Indicates whether a node is a Playlist, Group Test, Group, Feature, Scenario, Step Block, or Step nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
block_type If the node is a Step Block, is this a Background, After Scenario, top level Scenario, inner Sceanrio, or a group of steps that are part of a conditional statement nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
name The name of the Feature, Scenario, Step, etc. text VARCHAR2(1000) text VARCHAR2(1000) VARCHAR
status Started, Pass, Fail, True, False, Stopped, or Restarted nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
message Any return value provided by a Step text VARCHAR2(1000) text VARCHAR2(1000) VARCHAR
error_message Any error message provided by a false or failure text VARCHAR2(1000) text VARCHAR2(1000) VARCHAR
file_uri The location of the file that produced this node text VARCHAR2(1000) text VARCHAR2(1000) VARCHAR
start_line The first line that produced this node in the Feature file for the Step, Scenario, etc. int int int(11) int int
end_line The last line that produced this node in the Feature file for the Step, Scenario, etc., int int int(11) int int
data_file_path For a Group Test, the CSV file that provided the worker data text VARCHAR2(1000) text VARCHAR2(1000) VARCHAR
worker_name The worker name (if this node is a Feature which represents a worker in a group) text VARCHAR2(1000) text VARCHAR2(1000) VARCHAR
tags If this node is a Scenario, any tags text VARCHAR2(1000) text VARCHAR2(1000) VARCHAR
step_id If this node is a Step, the step ID, which can be found in the step guide nvarchar(100) VARCHAR2(100) varchar(100) VARCHAR(100) VARCHAR(100)
delay_start_time If this node is a Step with a non-zero step delay, this field will be the time at which the delay began datetime2(7) timestamp(6) datetime(3) TIMESTAMP TIMESTAMP
start_time The time at which execution of the node began datetime2(7) timestamp(6) datetime(3) TIMESTAMP TIMESTAMP
end_time The time at which execution of this node finished datetime2(7) timestamp(6) datetime(3) TIMESTAMP TIMESTAMP

results matching ""

    No results matching ""