Data Store DDLs
When manually running these DDLs, begin with the 2.2.0 DDLs, followed by 2.3.0, 2.5.0, and lastly 2.7.0.
JDBC database DDLs
MySQL for Cycle version 2.2.0 (run first)
CREATE TABLE cycle_test_execution (
execution_id varchar(100) NOT NULL,
execution_start_ts datetime(3) NOT NULL,
cycle_user varchar(100) NOT NULL,
cycle_version varchar(100) NOT NULL,
hardware_id varchar(100) NOT NULL,
computer_username varchar(100) NOT NULL,
os varchar(100) NOT NULL,
invoker varchar(100) NOT NULL,
PRIMARY KEY (execution_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE cycle_execution_results (
execution_id varchar(100) NOT NULL,
node_id varchar(255) NOT NULL,
parent_node_id varchar(255) DEFAULT NULL,
sending_node_id varchar(255) NOT NULL,
node_sequence int(11) NOT NULL,
node_type varchar(100) NOT NULL,
block_type varchar(100) DEFAULT NULL,
name TEXT DEFAULT NULL,
status varchar(100) NOT NULL,
message TEXT DEFAULT NULL,
error_message TEXT DEFAULT NULL,
file_uri TEXT DEFAULT NULL,
start_line int(11) DEFAULT NULL,
end_line int(11) DEFAULT NULL,
data_file_path TEXT DEFAULT NULL,
worker_name TEXT DEFAULT NULL,
tags TEXT DEFAULT NULL,
step_id varchar(100) DEFAULT NULL,
delay_start_time datetime(3) DEFAULT NULL,
start_time datetime(3) NOT NULL,
end_time datetime(3) DEFAULT NULL,
PRIMARY KEY (execution_id,node_id),
CONSTRAINT FK_cycle_execution_results FOREIGN KEY (execution_id) REFERENCES cycle_test_execution (execution_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE INDEX cycle_node_type_IDX ON cycle_execution_results (node_type) USING BTREE;;
CREATE INDEX cycle_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id) USING BTREE;;
CREATE INDEX cycle_sending_node_IDX ON cycle_execution_results (execution_id,sending_node_id) USING BTREE;;
CREATE VIEW cycle_execution_view AS
SELECT test.execution_id,
test.cycle_user,
test.os,
test.computer_username,
test.hardware_id,
test.cycle_version,
cyc_group.name as group_name,
cyc_group.data_file_path,
worker.worker_name,
dtl.node_id,
dtl.node_type,
dtl.name,
dtl.block_type,
dtl.tags,
dtl.status,
dtl.message,
dtl.error_message,
dtl.file_uri,
dtl.start_line,
dtl.end_line,
dtl.delay_start_time,
dtl.start_time,
dtl.end_time,
CEIL((dtl.end_time - dtl.start_time) * 1000) as duration,
CEIL((dtl.end_time - dtl.delay_start_time) * 1000) as duration_with_delay,
dtl.node_sequence
from cycle_test_execution as test
join cycle_execution_results as dtl
on test.execution_id = dtl.execution_id
and node_type not in ('Group','GroupTest','ConditionalBlock','ConditionalExpression')
left join (select execution_id, node_id, parent_node_id, sending_node_id, worker_name from cycle_execution_results where node_type = 'Feature') as worker
on dtl.execution_id = worker.execution_id
and dtl.sending_node_id = worker.node_id
left join (select execution_id, node_id, name, data_file_path from cycle_execution_results where node_type = 'Group') as cyc_group
on worker.execution_id = cyc_group.execution_id
and worker.parent_node_id = cyc_group.node_id;
MySQL for Cycle version 2.3.0 (run second)
CREATE TABLE cycle_image (
id varchar(100) NOT NULL,
image LONGBLOB,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE cycle_image_results (
id varchar(100) NOT NULL,
execution_id varchar(100) NOT NULL,
node_id varchar(255) NOT NULL,
template_file TEXT,
template_image_id varchar(100) DEFAULT NULL,
screenshot_image_id varchar(100) DEFAULT NULL,
found_image BOOL DEFAULT NULL,
min_value DOUBLE DEFAULT NULL,
max_value DOUBLE DEFAULT NULL,
min_location_x int(11) DEFAULT NULL,
min_location_y int(11) DEFAULT NULL,
max_location_x int(11) DEFAULT NULL,
max_location_y int(11) DEFAULT NULL,
source_width int(11) DEFAULT NULL,
source_height int(11) DEFAULT NULL,
template_width int(11) DEFAULT NULL,
template_height int(11) DEFAULT NULL,
correlation_threshold DOUBLE DEFAULT NULL,
PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_IMAGE_RESULTS FOREIGN KEY (execution_id, node_id) REFERENCES cycle_execution_results (execution_id,node_id) ,
CONSTRAINT FK_CYCLE_TERMINAL_T FOREIGN KEY (template_image_id) REFERENCES cycle_image (id) ,
CONSTRAINT FK_CYCLE_TERMINAL_S FOREIGN KEY (screenshot_image_id) REFERENCES cycle_image (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE cycle_terminal_screens (
id varchar(100) NOT NULL,
execution_id varchar(100) NOT NULL,
node_id varchar(255) NOT NULL,
screen TEXT,
PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_TERMINAL FOREIGN KEY (execution_id,node_id) REFERENCES cycle_execution_results (execution_id,node_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE cycle_file_diagnostics (
id varchar(100) NOT NULL,
execution_id varchar(100) NOT NULL,
node_id varchar(255) NOT NULL,
start_line int(11),
start_character int(11),
end_line int(11),
end_character int(11),
message TEXT,
severity varchar(100),
code int(11),
source TEXT,
PRIMARY KEY (id) ,
CONSTRAINT FK_FILE_DIAGNOSTICS FOREIGN KEY (execution_id,node_id) REFERENCES cycle_execution_results (execution_id,node_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
MySQL for Cycle version 2.5.0 (run third)
CREATE TABLE data_type_lookup (
id int(11) NOT NULL ,
datatype_desc varchar(100) NOT NULL ,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
insert into data_type_lookup values (1, 'STRING');
insert into data_type_lookup values (2, 'INT');
insert into data_type_lookup values (3, 'FLOAT');
CREATE TABLE test_plan (
id varchar(100) NOT NULL ,
name varchar(255) NOT NULL ,
is_default BOOL ,
description TEXT ,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE test_data_tag (
id varchar(100) NOT NULL ,
name varchar(255) NOT NULL ,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE test_data_set (
id varchar(100) NOT NULL ,
test_plan_id varchar(100) NOT NULL ,
name varchar(255) NOT NULL ,
description TEXT ,
PRIMARY KEY (id) ,
CONSTRAINT test_data_set_FK FOREIGN KEY (test_plan_id) REFERENCES test_plan (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE UNIQUE INDEX test_data_set_UN ON test_data_set (test_plan_id,name) USING BTREE;
CREATE TABLE test_data_column (
id varchar(100) NOT NULL ,
test_data_set_id varchar(100) NOT NULL ,
name varchar(255) NOT NULL ,
datatype int(11) NOT NULL ,
sort_sequence int(11) NOT NULL ,
PRIMARY KEY (id) ,
CONSTRAINT test_data_column_FK FOREIGN KEY (test_data_set_id) REFERENCES test_data_set (id) ,
CONSTRAINT test_data_type_FK FOREIGN KEY (datatype) REFERENCES data_type_lookup (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE test_data_record (
id varchar(100) NOT NULL ,
test_data_set_id varchar(100) NOT NULL ,
sort_sequence int(11) NOT NULL ,
PRIMARY KEY (id) ,
CONSTRAINT test_data_record_FK FOREIGN KEY (test_data_set_id) REFERENCES test_data_set (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE test_data_record_tag (
id varchar(100) NOT NULL ,
test_data_tag_id varchar(100) NOT NULL ,
test_data_record_id varchar(100) NOT NULL ,
PRIMARY KEY (id) ,
CONSTRAINT test_data_tag_FK FOREIGN KEY (test_data_tag_id) REFERENCES test_data_tag (id) ,
CONSTRAINT test_data_record_tag_FK FOREIGN KEY (test_data_record_id) REFERENCES test_data_record (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE test_data_value (
id varchar(100) NOT NULL ,
test_data_record_id varchar(100) NOT NULL ,
test_data_column_id varchar(100) NOT NULL ,
data_value TEXT ,
PRIMARY KEY (id) ,
CONSTRAINT test_data_record_val_FK FOREIGN KEY (test_data_record_id) REFERENCES test_data_record (id) ,
CONSTRAINT test_data_column_val_FK FOREIGN KEY (test_data_column_id) REFERENCES test_data_column (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
MySQL for Cycle version 2.7.0 (run fourth)
ALTER TABLE test_data_tag
ADD CONSTRAINT test_data_tag_UC UNIQUE (name);
ALTER TABLE test_data_column
ADD CONSTRAINT test_data_column_UC UNIQUE (test_data_set_id,name);
SQL Server for Cycle version 2.2.0 (run first)
CREATE TABLE cycle_test_execution (
execution_id nvarchar(100) NOT NULL,
execution_start_ts datetime2(7) NOT NULL,
cycle_user nvarchar(100) NOT NULL,
cycle_version nvarchar(100) NOT NULL,
hardware_id nvarchar(100) NOT NULL,
computer_username nvarchar(100) NOT NULL,
os nvarchar(100) NOT NULL,
invoker nvarchar(100) NOT NULL,
CONSTRAINT PK_test_execution PRIMARY KEY (execution_id)
) ;
CREATE TABLE cycle_execution_results (
execution_id nvarchar(100) NOT NULL,
node_id nvarchar(255) NOT NULL,
parent_node_id nvarchar(255) DEFAULT NULL,
sending_node_id nvarchar(255) NOT NULL,
node_sequence int NOT NULL,
node_type nvarchar(100) NOT NULL,
block_type nvarchar(100) DEFAULT NULL,
name TEXT DEFAULT NULL,
status nvarchar(100) NOT NULL,
message TEXT DEFAULT NULL,
error_message TEXT DEFAULT NULL,
file_uri TEXT DEFAULT NULL,
start_line int DEFAULT NULL,
end_line int DEFAULT NULL,
data_file_path TEXT DEFAULT NULL,
worker_name TEXT DEFAULT NULL,
tags TEXT DEFAULT NULL,
step_id nvarchar(100) DEFAULT NULL,
delay_start_time datetime2(7) DEFAULT NULL,
start_time datetime2(7) NOT NULL,
end_time datetime2(7) DEFAULT NULL,
CONSTRAINT PK_cycle_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT FK_cycle_execution_results FOREIGN KEY (execution_id) REFERENCES cycle_test_execution(execution_id)
) ;
CREATE INDEX cycle_node_type_IDX ON cycle_execution_results (node_type);;
CREATE INDEX cycle_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id);;
CREATE INDEX cycle_sending_node_IDX ON cycle_execution_results (execution_id,sending_node_id);;
CREATE VIEW cycle_execution_view AS
SELECT test.execution_id,
test.cycle_user,
test.os,
test.computer_username,
test.hardware_id,
test.cycle_version,
cyc_group.name as group_name,
cyc_group.data_file_path,
worker.worker_name,
dtl.node_id,
dtl.node_type,
dtl.name,
dtl.block_type,
dtl.tags,
dtl.status,
dtl.message,
dtl.error_message,
dtl.file_uri,
dtl.start_line,
dtl.end_line,
dtl.delay_start_time,
dtl.start_time,
dtl.end_time,
DATEDIFF(millisecond, dtl.start_time, dtl.end_time) as duration,
DATEDIFF(millisecond, dtl.delay_start_time, dtl.end_time) as duration_with_delay,
dtl.node_sequence
from cycle_test_execution as test
join cycle_execution_results as dtl
on test.execution_id = dtl.execution_id
and node_type not in ('Group','GroupTest','ConditionalBlock','ConditionalExpression')
left join (select execution_id, node_id, parent_node_id, sending_node_id, worker_name from cycle_execution_results where node_type = 'Feature') as worker
on dtl.execution_id = worker.execution_id
and dtl.sending_node_id = worker.node_id
left join (select execution_id, node_id, name, data_file_path from cycle_execution_results where node_type = 'Group') as cyc_group
on worker.execution_id = cyc_group.execution_id
and worker.parent_node_id = cyc_group.node_id;
SQL Server for Cycle version 2.3.0 (run second)
CREATE TABLE cycle_image (
id nvarchar(100) NOT NULL,
image varbinary(MAX),
CONSTRAINT PK_CYCLE_IMAGE PRIMARY KEY (id)
) ;
CREATE TABLE cycle_image_results (
id nvarchar(100) NOT NULL,
execution_id nvarchar(100) NOT NULL,
node_id nvarchar(255) NOT NULL,
template_file TEXT,
template_image_id nvarchar(100) DEFAULT NULL,
screenshot_image_id nvarchar(100) DEFAULT NULL,
found_image BIT DEFAULT NULL,
min_value FLOAT DEFAULT NULL,
max_value FLOAT DEFAULT NULL,
min_location_x int DEFAULT NULL,
min_location_y int DEFAULT NULL,
max_location_x int DEFAULT NULL,
max_location_y int DEFAULT NULL,
source_width int DEFAULT NULL,
source_height int DEFAULT NULL,
template_width int DEFAULT NULL,
template_height int DEFAULT NULL,
correlation_threshold FLOAT DEFAULT NULL,
CONSTRAINT PK_CYCLE_IMAGE_RESULTS PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_IMAGE_RESULTS FOREIGN KEY (execution_id, node_id) REFERENCES cycle_execution_results(execution_id,node_id) ,
CONSTRAINT FK_CYCLE_TERMINAL_T FOREIGN KEY (template_image_id) REFERENCES cycle_image(id) ,
CONSTRAINT FK_CYCLE_TERMINAL_S FOREIGN KEY (screenshot_image_id) REFERENCES cycle_image(id)
) ;
CREATE TABLE cycle_terminal_screens (
id nvarchar(100) NOT NULL,
execution_id nvarchar(100) NOT NULL,
node_id nvarchar(255) NOT NULL,
screen TEXT,
CONSTRAINT PK_CYCLE_TERMINAL PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_TERMINAL FOREIGN KEY (execution_id,node_id) REFERENCES cycle_execution_results(execution_id,node_id)
) ;
CREATE TABLE cycle_file_diagnostics (
id nvarchar(100) NOT NULL,
execution_id nvarchar(100) NOT NULL,
node_id nvarchar(255) NOT NULL,
start_line int,
start_character int,
end_line int,
end_character int,
message TEXT,
severity nvarchar(100),
code int,
source TEXT,
CONSTRAINT PK_FILE_DIAGNOSTICS PRIMARY KEY (id) ,
CONSTRAINT FK_FILE_DIAGNOSTICS FOREIGN KEY (execution_id,node_id) REFERENCES cycle_execution_results(execution_id,node_id)
) ;
SQL Server for Cycle version 2.5.0 (run third)
CREATE TABLE data_type_lookup (
id int NOT NULL ,
datatype_desc nvarchar(100) NOT NULL ,
CONSTRAINT data_type_lookup_PK PRIMARY KEY (id)
) ;
insert into data_type_lookup values (1, 'STRING');
insert into data_type_lookup values (2, 'INT');
insert into data_type_lookup values (3, 'FLOAT');
CREATE TABLE test_plan (
id nvarchar(100) NOT NULL ,
name nvarchar(255) NOT NULL ,
is_default BIT ,
description TEXT ,
CONSTRAINT test_plan_PK PRIMARY KEY (id)
) ;
CREATE TABLE test_data_tag (
id nvarchar(100) NOT NULL ,
name nvarchar(255) NOT NULL ,
CONSTRAINT test_data_tag_PK PRIMARY KEY (id)
) ;
CREATE TABLE test_data_set (
id nvarchar(100) NOT NULL ,
test_plan_id nvarchar(100) NOT NULL ,
name nvarchar(255) NOT NULL ,
description TEXT ,
CONSTRAINT test_data_set_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_set_FK FOREIGN KEY (test_plan_id) REFERENCES test_plan(id)
) ;
CREATE UNIQUE INDEX test_data_set_UN ON test_data_set (test_plan_id,name);
CREATE TABLE test_data_column (
id nvarchar(100) NOT NULL ,
test_data_set_id nvarchar(100) NOT NULL ,
name nvarchar(255) NOT NULL ,
datatype int NOT NULL ,
sort_sequence int NOT NULL ,
CONSTRAINT test_data_column_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_column_FK FOREIGN KEY (test_data_set_id) REFERENCES test_data_set(id) ,
CONSTRAINT test_data_type_FK FOREIGN KEY (datatype) REFERENCES data_type_lookup(id)
) ;
CREATE TABLE test_data_record (
id nvarchar(100) NOT NULL ,
test_data_set_id nvarchar(100) NOT NULL ,
sort_sequence int NOT NULL ,
CONSTRAINT test_data_record_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_record_FK FOREIGN KEY (test_data_set_id) REFERENCES test_data_set(id)
) ;
CREATE TABLE test_data_record_tag (
id nvarchar(100) NOT NULL ,
test_data_tag_id nvarchar(100) NOT NULL ,
test_data_record_id nvarchar(100) NOT NULL ,
CONSTRAINT test_data_record_tag_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_tag_FK FOREIGN KEY (test_data_tag_id) REFERENCES test_data_tag(id) ,
CONSTRAINT test_data_record_tag_FK FOREIGN KEY (test_data_record_id) REFERENCES test_data_record(id)
) ;
CREATE TABLE test_data_value (
id nvarchar(100) NOT NULL ,
test_data_record_id nvarchar(100) NOT NULL ,
test_data_column_id nvarchar(100) NOT NULL ,
data_value TEXT ,
CONSTRAINT test_data_value_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_record_val_FK FOREIGN KEY (test_data_record_id) REFERENCES test_data_record(id) ,
CONSTRAINT test_data_column_val_FK FOREIGN KEY (test_data_column_id) REFERENCES test_data_column(id)
) ;
SQL Server for Cycle version 2.7.0 (run fourth)
ALTER TABLE test_data_tag
ADD CONSTRAINT test_data_tag_UC UNIQUE (name);
ALTER TABLE test_data_column
ADD CONSTRAINT test_data_column_UC UNIQUE (test_data_set_id,name);
Oracle for Cycle version 2.2.0 (run first)
CREATE TABLE cycle_test_execution (
execution_id VARCHAR2(100) NOT NULL,
execution_start_ts timestamp(6) NOT NULL,
cycle_user VARCHAR2(100) NOT NULL,
cycle_version VARCHAR2(100) NOT NULL,
hardware_id VARCHAR2(100) NOT NULL,
computer_username VARCHAR2(100) NOT NULL,
os VARCHAR2(100) NOT NULL,
invoker VARCHAR2(100) NOT NULL,
CONSTRAINT PK_test_execution PRIMARY KEY (execution_id)
) ;
CREATE TABLE cycle_execution_results (
execution_id VARCHAR2(100) NOT NULL,
node_id VARCHAR2(255) NOT NULL,
parent_node_id VARCHAR2(255) DEFAULT NULL,
sending_node_id VARCHAR2(255) NOT NULL,
node_sequence int NOT NULL,
node_type VARCHAR2(100) NOT NULL,
block_type VARCHAR2(100) DEFAULT NULL,
name VARCHAR2(4000) DEFAULT NULL,
status VARCHAR2(100) NOT NULL,
message VARCHAR2(4000) DEFAULT NULL,
error_message VARCHAR2(4000) DEFAULT NULL,
file_uri VARCHAR2(4000) DEFAULT NULL,
start_line int DEFAULT NULL,
end_line int DEFAULT NULL,
data_file_path VARCHAR2(4000) DEFAULT NULL,
worker_name VARCHAR2(4000) DEFAULT NULL,
tags VARCHAR2(4000) DEFAULT NULL,
step_id VARCHAR2(100) DEFAULT NULL,
delay_start_time timestamp(6) DEFAULT NULL,
start_time timestamp(6) NOT NULL,
end_time timestamp(6) DEFAULT NULL,
CONSTRAINT PK_cycle_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT FK_cycle_execution_results FOREIGN KEY (execution_id) REFERENCES cycle_test_execution (execution_id)
) ;
CREATE INDEX cycle_node_type_IDX ON cycle_execution_results (node_type);;
CREATE INDEX cycle_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id);;
CREATE INDEX cycle_sending_node_IDX ON cycle_execution_results (execution_id,sending_node_id);;
CREATE VIEW cycle_execution_view AS
SELECT test.execution_id,
test.cycle_user,
test.os,
test.computer_username,
test.hardware_id,
test.cycle_version,
cyc_group.name as group_name,
cyc_group.data_file_path,
worker.worker_name,
dtl.node_id,
dtl.node_type,
dtl.name,
dtl.block_type,
dtl.tags,
dtl.status,
dtl.message,
dtl.error_message,
dtl.file_uri,
dtl.start_line,
dtl.end_line,
dtl.delay_start_time,
dtl.start_time,
dtl.end_time,
(sysdate + (dtl.end_time - dtl.start_time) * 1000 - sysdate) * 86400 as duration,
(sysdate + (dtl.end_time - dtl.delay_start_time) * 1000 - sysdate) * 86400 as duration_with_delay,
dtl.node_sequence
from cycle_test_execution test
join cycle_execution_results dtl
on test.execution_id = dtl.execution_id
and node_type not in ('Group','GroupTest','ConditionalBlock','ConditionalExpression')
left join (select execution_id, node_id, parent_node_id, sending_node_id, worker_name from cycle_execution_results where node_type = 'Feature') worker
on dtl.execution_id = worker.execution_id
and dtl.sending_node_id = worker.node_id
left join (select execution_id, node_id, name, data_file_path from cycle_execution_results where node_type = 'Group') cyc_group
on worker.execution_id = cyc_group.execution_id
and worker.parent_node_id = cyc_group.node_id;
Oracle for Cycle version 2.3.0 (run second)
CREATE TABLE cycle_image (
id VARCHAR2(100) NOT NULL,
image BLOB,
CONSTRAINT PK_CYCLE_IMAGE PRIMARY KEY (id)
) ;
CREATE TABLE cycle_image_results (
id VARCHAR2(100) NOT NULL,
execution_id VARCHAR2(100) NOT NULL,
node_id VARCHAR2(255) NOT NULL,
template_file VARCHAR2(4000),
template_image_id VARCHAR2(100) DEFAULT NULL,
screenshot_image_id VARCHAR2(100) DEFAULT NULL,
found_image CHAR(1) DEFAULT NULL,
min_value BINARY_DOUBLE DEFAULT NULL,
max_value BINARY_DOUBLE DEFAULT NULL,
min_location_x int DEFAULT NULL,
min_location_y int DEFAULT NULL,
max_location_x int DEFAULT NULL,
max_location_y int DEFAULT NULL,
source_width int DEFAULT NULL,
source_height int DEFAULT NULL,
template_width int DEFAULT NULL,
template_height int DEFAULT NULL,
correlation_threshold BINARY_DOUBLE DEFAULT NULL,
CONSTRAINT PK_CYCLE_IMAGE_RESULTS PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_IMAGE_RESULTS FOREIGN KEY (execution_id, node_id) REFERENCES cycle_execution_results (execution_id,node_id) ,
CONSTRAINT FK_CYCLE_TERMINAL_T FOREIGN KEY (template_image_id) REFERENCES cycle_image (id) ,
CONSTRAINT FK_CYCLE_TERMINAL_S FOREIGN KEY (screenshot_image_id) REFERENCES cycle_image (id)
) ;
CREATE TABLE cycle_terminal_screens (
id VARCHAR2(100) NOT NULL,
execution_id VARCHAR2(100) NOT NULL,
node_id VARCHAR2(255) NOT NULL,
screen VARCHAR2(4000),
CONSTRAINT PK_CYCLE_TERMINAL PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_TERMINAL FOREIGN KEY (execution_id,node_id) REFERENCES cycle_execution_results (execution_id,node_id)
) ;
CREATE TABLE cycle_file_diagnostics (
id VARCHAR2(100) NOT NULL,
execution_id VARCHAR2(100) NOT NULL,
node_id VARCHAR2(255) NOT NULL,
start_line int,
start_character int,
end_line int,
end_character int,
message VARCHAR2(4000),
severity VARCHAR2(100),
code int,
source VARCHAR2(4000),
CONSTRAINT PK_FILE_DIAGNOSTICS PRIMARY KEY (id) ,
CONSTRAINT FK_FILE_DIAGNOSTICS FOREIGN KEY (execution_id,node_id) REFERENCES cycle_execution_results (execution_id,node_id)
) ;
Oracle for Cycle version 2.5.0 (run third)
CREATE TABLE data_type_lookup (
id int NOT NULL ,
datatype_desc VARCHAR2(100) NOT NULL ,
CONSTRAINT data_type_lookup_PK PRIMARY KEY (id)
) ;
insert into data_type_lookup values (1, 'STRING');
insert into data_type_lookup values (2, 'INT');
insert into data_type_lookup values (3, 'FLOAT');
CREATE TABLE test_plan (
id VARCHAR2(100) NOT NULL ,
name VARCHAR2(255) NOT NULL ,
is_default CHAR(1) ,
description VARCHAR2(4000) ,
CONSTRAINT test_plan_PK PRIMARY KEY (id)
) ;
CREATE TABLE test_data_tag (
id VARCHAR2(100) NOT NULL ,
name VARCHAR2(255) NOT NULL ,
CONSTRAINT test_data_tag_PK PRIMARY KEY (id)
) ;
CREATE TABLE test_data_set (
id VARCHAR2(100) NOT NULL ,
test_plan_id VARCHAR2(100) NOT NULL ,
name VARCHAR2(255) NOT NULL ,
description VARCHAR2(4000) ,
CONSTRAINT test_data_set_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_set_FK FOREIGN KEY (test_plan_id) REFERENCES test_plan (id)
) ;
CREATE UNIQUE INDEX test_data_set_UN ON test_data_set (test_plan_id,name);
CREATE TABLE test_data_column (
id VARCHAR2(100) NOT NULL ,
test_data_set_id VARCHAR2(100) NOT NULL ,
name VARCHAR2(255) NOT NULL ,
datatype int NOT NULL ,
sort_sequence int NOT NULL ,
CONSTRAINT test_data_column_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_column_FK FOREIGN KEY (test_data_set_id) REFERENCES test_data_set (id) ,
CONSTRAINT test_data_type_FK FOREIGN KEY (datatype) REFERENCES data_type_lookup (id)
) ;
CREATE TABLE test_data_record (
id VARCHAR2(100) NOT NULL ,
test_data_set_id VARCHAR2(100) NOT NULL ,
sort_sequence int NOT NULL ,
CONSTRAINT test_data_record_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_record_FK FOREIGN KEY (test_data_set_id) REFERENCES test_data_set (id)
) ;
CREATE TABLE test_data_record_tag (
id VARCHAR2(100) NOT NULL ,
test_data_tag_id VARCHAR2(100) NOT NULL ,
test_data_record_id VARCHAR2(100) NOT NULL ,
CONSTRAINT test_data_record_tag_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_tag_FK FOREIGN KEY (test_data_tag_id) REFERENCES test_data_tag (id) ,
CONSTRAINT test_data_record_tag_FK FOREIGN KEY (test_data_record_id) REFERENCES test_data_record (id)
) ;
CREATE TABLE test_data_value (
id VARCHAR2(100) NOT NULL ,
test_data_record_id VARCHAR2(100) NOT NULL ,
test_data_column_id VARCHAR2(100) NOT NULL ,
data_value VARCHAR2(4000) ,
CONSTRAINT test_data_value_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_record_val_FK FOREIGN KEY (test_data_record_id) REFERENCES test_data_record (id) ,
CONSTRAINT test_data_column_val_FK FOREIGN KEY (test_data_column_id) REFERENCES test_data_column (id)
) ;
Oracle for Cycle version 2.7.0 (run fourth)
ALTER TABLE test_data_tag
ADD CONSTRAINT test_data_tag_UC UNIQUE (name);
ALTER TABLE test_data_column
ADD CONSTRAINT test_data_column_UC UNIQUE (test_data_set_id,name);
H2 for Cycle version 2.2.0 (run first)
CREATE TABLE cycle_test_execution (
execution_id VARCHAR(100) NOT NULL,
execution_start_ts TIMESTAMP NOT NULL,
cycle_user VARCHAR(100) NOT NULL,
cycle_version VARCHAR(100) NOT NULL,
hardware_id VARCHAR(100) NOT NULL,
computer_username VARCHAR(100) NOT NULL,
os VARCHAR(100) NOT NULL,
invoker VARCHAR(100) NOT NULL,
CONSTRAINT PK_test_execution PRIMARY KEY (execution_id)
) ;
CREATE TABLE cycle_execution_results (
execution_id VARCHAR(100) NOT NULL,
node_id VARCHAR(255) NOT NULL,
parent_node_id VARCHAR(255) DEFAULT NULL,
sending_node_id VARCHAR(255) NOT NULL,
node_sequence INT NOT NULL,
node_type VARCHAR(100) NOT NULL,
block_type VARCHAR(100) DEFAULT NULL,
name VARCHAR DEFAULT NULL,
status VARCHAR(100) NOT NULL,
message VARCHAR DEFAULT NULL,
error_message VARCHAR DEFAULT NULL,
file_uri VARCHAR DEFAULT NULL,
start_line INT DEFAULT NULL,
end_line INT DEFAULT NULL,
data_file_path VARCHAR DEFAULT NULL,
worker_name VARCHAR DEFAULT NULL,
tags VARCHAR DEFAULT NULL,
step_id VARCHAR(100) DEFAULT NULL,
delay_start_time TIMESTAMP DEFAULT NULL,
start_time TIMESTAMP NOT NULL,
end_time TIMESTAMP DEFAULT NULL,
CONSTRAINT PK_cycle_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT FK_cycle_execution_results FOREIGN KEY (execution_id) REFERENCES cycle_test_execution(execution_id)
) ;
CREATE INDEX cycle_node_type_IDX ON cycle_execution_results (node_type);;
CREATE INDEX cycle_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id);;
CREATE INDEX cycle_sending_node_IDX ON cycle_execution_results (execution_id,sending_node_id);;
CREATE VIEW cycle_execution_view AS
SELECT test.execution_id,
test.cycle_user,
test.os,
test.computer_username,
test.hardware_id,
test.cycle_version,
cyc_group.name as group_name,
cyc_group.data_file_path,
worker.worker_name,
dtl.node_id,
dtl.node_type,
dtl.name,
dtl.block_type,
dtl.tags,
dtl.status,
dtl.message,
dtl.error_message,
dtl.file_uri,
dtl.start_line,
dtl.end_line,
dtl.delay_start_time,
dtl.start_time,
dtl.end_time,
datediff('ms', dtl.start_time, dtl.end_time) as duration,
datediff('ms', dtl.delay_start_time, dtl.end_time) as duration_with_delay,
dtl.node_sequence
from cycle_test_execution as test
join cycle_execution_results as dtl
on test.execution_id = dtl.execution_id
and node_type not in ('Group','GroupTest','ConditionalBlock','ConditionalExpression')
left join (select execution_id, node_id, parent_node_id, sending_node_id, worker_name from cycle_execution_results where node_type = 'Feature') as worker
on dtl.execution_id = worker.execution_id
and dtl.sending_node_id = worker.node_id
left join (select execution_id, node_id, name, data_file_path from cycle_execution_results where node_type = 'Group') as cyc_group
on worker.execution_id = cyc_group.execution_id
and worker.parent_node_id = cyc_group.node_id;
H2 for Cycle version 2.3.0 (run second)
CREATE TABLE cycle_image (
id VARCHAR(100) NOT NULL,
image LONGBLOB,
CONSTRAINT PK_CYCLE_IMAGE PRIMARY KEY (id)
) ;
CREATE TABLE cycle_image_results (
id VARCHAR(100) NOT NULL,
execution_id VARCHAR(100) NOT NULL,
node_id VARCHAR(255) NOT NULL,
template_file VARCHAR,
template_image_id VARCHAR(100) DEFAULT NULL,
screenshot_image_id VARCHAR(100) DEFAULT NULL,
found_image BOOLEAN DEFAULT NULL,
min_value DOUBLE DEFAULT NULL,
max_value DOUBLE DEFAULT NULL,
min_location_x INT DEFAULT NULL,
min_location_y INT DEFAULT NULL,
max_location_x INT DEFAULT NULL,
max_location_y INT DEFAULT NULL,
source_width INT DEFAULT NULL,
source_height INT DEFAULT NULL,
template_width INT DEFAULT NULL,
template_height INT DEFAULT NULL,
correlation_threshold DOUBLE DEFAULT NULL,
CONSTRAINT PK_CYCLE_IMAGE_RESULTS PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_IMAGE_RESULTS FOREIGN KEY (execution_id, node_id) REFERENCES cycle_execution_results(execution_id,node_id) ,
CONSTRAINT FK_CYCLE_TERMINAL_T FOREIGN KEY (template_image_id) REFERENCES cycle_image(id) ,
CONSTRAINT FK_CYCLE_TERMINAL_S FOREIGN KEY (screenshot_image_id) REFERENCES cycle_image(id)
) ;
CREATE TABLE cycle_terminal_screens (
id VARCHAR(100) NOT NULL,
execution_id VARCHAR(100) NOT NULL,
node_id VARCHAR(255) NOT NULL,
screen VARCHAR,
CONSTRAINT PK_CYCLE_TERMINAL PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_TERMINAL FOREIGN KEY (execution_id,node_id) REFERENCES cycle_execution_results(execution_id,node_id)
) ;
CREATE TABLE cycle_file_diagnostics (
id VARCHAR(100) NOT NULL,
execution_id VARCHAR(100) NOT NULL,
node_id VARCHAR(255) NOT NULL,
start_line INT,
start_character INT,
end_line INT,
end_character INT,
message VARCHAR,
severity VARCHAR(100),
code INT,
source VARCHAR,
CONSTRAINT PK_FILE_DIAGNOSTICS PRIMARY KEY (id) ,
CONSTRAINT FK_FILE_DIAGNOSTICS FOREIGN KEY (execution_id,node_id) REFERENCES cycle_execution_results(execution_id,node_id)
) ;
H2 for Cycle version 2.5.0 (run third)
CREATE TABLE data_type_lookup (
id INT NOT NULL ,
datatype_desc VARCHAR(100) NOT NULL ,
CONSTRAINT data_type_lookup_PK PRIMARY KEY (id)
) ;
insert into data_type_lookup values (1, 'STRING');
insert into data_type_lookup values (2, 'INT');
insert into data_type_lookup values (3, 'FLOAT');
CREATE TABLE test_plan (
id VARCHAR(100) NOT NULL ,
name VARCHAR(255) NOT NULL ,
is_default BOOLEAN ,
description VARCHAR ,
CONSTRAINT test_plan_PK PRIMARY KEY (id)
) ;
CREATE TABLE test_data_tag (
id VARCHAR(100) NOT NULL ,
name VARCHAR(255) NOT NULL ,
CONSTRAINT test_data_tag_PK PRIMARY KEY (id)
) ;
CREATE TABLE test_data_set (
id VARCHAR(100) NOT NULL ,
test_plan_id VARCHAR(100) NOT NULL ,
name VARCHAR(255) NOT NULL ,
description VARCHAR ,
CONSTRAINT test_data_set_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_set_FK FOREIGN KEY (test_plan_id) REFERENCES test_plan(id)
) ;
CREATE UNIQUE INDEX test_data_set_UN ON test_data_set (test_plan_id,name);
CREATE TABLE test_data_column (
id VARCHAR(100) NOT NULL ,
test_data_set_id VARCHAR(100) NOT NULL ,
name VARCHAR(255) NOT NULL ,
datatype INT NOT NULL ,
sort_sequence INT NOT NULL ,
CONSTRAINT test_data_column_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_column_FK FOREIGN KEY (test_data_set_id) REFERENCES test_data_set(id) ,
CONSTRAINT test_data_type_FK FOREIGN KEY (datatype) REFERENCES data_type_lookup(id)
) ;
CREATE TABLE test_data_record (
id VARCHAR(100) NOT NULL ,
test_data_set_id VARCHAR(100) NOT NULL ,
sort_sequence INT NOT NULL ,
CONSTRAINT test_data_record_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_record_FK FOREIGN KEY (test_data_set_id) REFERENCES test_data_set(id)
) ;
CREATE TABLE test_data_record_tag (
id VARCHAR(100) NOT NULL ,
test_data_tag_id VARCHAR(100) NOT NULL ,
test_data_record_id VARCHAR(100) NOT NULL ,
CONSTRAINT test_data_record_tag_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_tag_FK FOREIGN KEY (test_data_tag_id) REFERENCES test_data_tag(id) ,
CONSTRAINT test_data_record_tag_FK FOREIGN KEY (test_data_record_id) REFERENCES test_data_record(id)
) ;
CREATE TABLE test_data_value (
id VARCHAR(100) NOT NULL ,
test_data_record_id VARCHAR(100) NOT NULL ,
test_data_column_id VARCHAR(100) NOT NULL ,
data_value VARCHAR ,
CONSTRAINT test_data_value_PK PRIMARY KEY (id) ,
CONSTRAINT test_data_record_val_FK FOREIGN KEY (test_data_record_id) REFERENCES test_data_record(id) ,
CONSTRAINT test_data_column_val_FK FOREIGN KEY (test_data_column_id) REFERENCES test_data_column(id)
) ;
H2 for Cycle version 2.7.0 (run fourth)
ALTER TABLE test_data_tag
ADD CONSTRAINT test_data_tag_UC UNIQUE (name);
ALTER TABLE test_data_column
ADD CONSTRAINT test_data_column_UC UNIQUE (test_data_set_id,name);
MOCA database DDLs
MOCA SQL Server for Cycle version 2.2.0 (run first)
CREATE TABLE uc_cycle_test_execution (
execution_id nvarchar(100) NOT NULL,
execution_start_ts datetime2(7) NOT NULL,
cycle_user nvarchar(100) NOT NULL,
cycle_version nvarchar(100) NOT NULL,
hardware_id nvarchar(100) NOT NULL,
computer_username nvarchar(100) NOT NULL,
os nvarchar(100) NOT NULL,
invoker nvarchar(100) NOT NULL,
CONSTRAINT PK_test_execution PRIMARY KEY (execution_id)
) ;
CREATE TABLE uc_cycle_execution_results (
execution_id nvarchar(100) NOT NULL,
node_id nvarchar(255) NOT NULL,
parent_node_id nvarchar(255) DEFAULT NULL,
sending_node_id nvarchar(255) NOT NULL,
node_sequence int NOT NULL,
node_type nvarchar(100) NOT NULL,
block_type nvarchar(100) DEFAULT NULL,
name TEXT DEFAULT NULL,
status nvarchar(100) NOT NULL,
message TEXT DEFAULT NULL,
error_message TEXT DEFAULT NULL,
file_uri TEXT DEFAULT NULL,
start_line int DEFAULT NULL,
end_line int DEFAULT NULL,
data_file_path TEXT DEFAULT NULL,
worker_name TEXT DEFAULT NULL,
tags TEXT DEFAULT NULL,
step_id nvarchar(100) DEFAULT NULL,
delay_start_time datetime2(7) DEFAULT NULL,
start_time datetime2(7) NOT NULL,
end_time datetime2(7) DEFAULT NULL,
CONSTRAINT PK_cycle_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT FK_cycle_execution_results FOREIGN KEY (execution_id) REFERENCES uc_cycle_test_execution(execution_id)
) ;
CREATE INDEX cycle_node_type_IDX ON uc_cycle_execution_results (node_type);;
CREATE INDEX cycle_parent_node_IDX ON uc_cycle_execution_results (execution_id,parent_node_id);;
CREATE INDEX cycle_sending_node_IDX ON uc_cycle_execution_results (execution_id,sending_node_id);;
CREATE VIEW uc_cycle_execution_view AS
SELECT test.execution_id,
test.cycle_user,
test.os,
test.computer_username,
test.hardware_id,
test.cycle_version,
cyc_group.name as group_name,
cyc_group.data_file_path,
worker.worker_name,
dtl.node_id,
dtl.node_type,
dtl.name,
dtl.block_type,
dtl.tags,
dtl.status,
dtl.message,
dtl.error_message,
dtl.file_uri,
dtl.start_line,
dtl.end_line,
dtl.delay_start_time,
dtl.start_time,
dtl.end_time,
DATEDIFF(millisecond, dtl.start_time, dtl.end_time) as duration,
DATEDIFF(millisecond, dtl.delay_start_time, dtl.end_time) as duration_with_delay,
dtl.node_sequence
from uc_cycle_test_execution as test
join uc_cycle_execution_results as dtl
on test.execution_id = dtl.execution_id
and node_type not in ('Group','GroupTest','ConditionalBlock','ConditionalExpression')
left join (select execution_id, node_id, parent_node_id, sending_node_id, worker_name from uc_cycle_execution_results where node_type = 'Feature') as worker
on dtl.execution_id = worker.execution_id
and dtl.sending_node_id = worker.node_id
left join (select execution_id, node_id, name, data_file_path from uc_cycle_execution_results where node_type = 'Group') as cyc_group
on worker.execution_id = cyc_group.execution_id
and worker.parent_node_id = cyc_group.node_id;
MOCA SQL Server for Cycle version 2.3.0 (run second)
CREATE TABLE uc_cycle_image (
id nvarchar(100) NOT NULL,
image varbinary(MAX),
CONSTRAINT PK_CYCLE_IMAGE PRIMARY KEY (id)
) ;
CREATE TABLE uc_cycle_image_results (
id nvarchar(100) NOT NULL,
execution_id nvarchar(100) NOT NULL,
node_id nvarchar(255) NOT NULL,
template_file TEXT,
template_image_id nvarchar(100) DEFAULT NULL,
screenshot_image_id nvarchar(100) DEFAULT NULL,
found_image BIT DEFAULT NULL,
min_value FLOAT DEFAULT NULL,
max_value FLOAT DEFAULT NULL,
min_location_x int DEFAULT NULL,
min_location_y int DEFAULT NULL,
max_location_x int DEFAULT NULL,
max_location_y int DEFAULT NULL,
source_width int DEFAULT NULL,
source_height int DEFAULT NULL,
template_width int DEFAULT NULL,
template_height int DEFAULT NULL,
correlation_threshold FLOAT DEFAULT NULL,
CONSTRAINT PK_CYCLE_IMAGE_RESULTS PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_IMAGE_RESULTS FOREIGN KEY (execution_id, node_id) REFERENCES uc_cycle_execution_results(execution_id,node_id) ,
CONSTRAINT FK_CYCLE_TERMINAL_T FOREIGN KEY (template_image_id) REFERENCES uc_cycle_image(id) ,
CONSTRAINT FK_CYCLE_TERMINAL_S FOREIGN KEY (screenshot_image_id) REFERENCES uc_cycle_image(id)
) ;
CREATE TABLE uc_cycle_terminal_screens (
id nvarchar(100) NOT NULL,
execution_id nvarchar(100) NOT NULL,
node_id nvarchar(255) NOT NULL,
screen TEXT,
CONSTRAINT PK_CYCLE_TERMINAL PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_TERMINAL FOREIGN KEY (execution_id,node_id) REFERENCES uc_cycle_execution_results(execution_id,node_id)
) ;
CREATE TABLE uc_cycle_file_diagnostics (
id nvarchar(100) NOT NULL,
execution_id nvarchar(100) NOT NULL,
node_id nvarchar(255) NOT NULL,
start_line int,
start_character int,
end_line int,
end_character int,
message TEXT,
severity nvarchar(100),
code int,
source TEXT,
CONSTRAINT PK_FILE_DIAGNOSTICS PRIMARY KEY (id) ,
CONSTRAINT FK_FILE_DIAGNOSTICS FOREIGN KEY (execution_id,node_id) REFERENCES uc_cycle_execution_results(execution_id,node_id)
) ;
MOCA SQL Server for Cycle version 2.5.0 (run third)
CREATE TABLE uc_data_type_lookup (
id int NOT NULL ,
datatype_desc nvarchar(100) NOT NULL ,
CONSTRAINT uc_data_type_lookup_PK PRIMARY KEY (id)
) ;
insert into uc_data_type_lookup values (1, 'STRING');
insert into uc_data_type_lookup values (2, 'INT');
insert into uc_data_type_lookup values (3, 'FLOAT');
CREATE TABLE uc_test_plan (
id nvarchar(100) NOT NULL ,
name nvarchar(255) NOT NULL ,
is_default BIT ,
description TEXT ,
CONSTRAINT uc_test_plan_PK PRIMARY KEY (id)
) ;
CREATE TABLE uc_test_data_tag (
id nvarchar(100) NOT NULL ,
name nvarchar(255) NOT NULL ,
CONSTRAINT uc_test_data_tag_PK PRIMARY KEY (id)
) ;
CREATE TABLE uc_test_data_set (
id nvarchar(100) NOT NULL ,
test_plan_id nvarchar(100) NOT NULL ,
name nvarchar(255) NOT NULL ,
description TEXT ,
CONSTRAINT uc_test_data_set_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_set_FK FOREIGN KEY (test_plan_id) REFERENCES uc_test_plan(id)
) ;
CREATE UNIQUE INDEX uc_test_data_set_UN ON uc_test_data_set (test_plan_id,name);
CREATE TABLE uc_test_data_column (
id nvarchar(100) NOT NULL ,
test_data_set_id nvarchar(100) NOT NULL ,
name nvarchar(255) NOT NULL ,
datatype int NOT NULL ,
sort_sequence int NOT NULL ,
CONSTRAINT uc_test_data_column_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_column_FK FOREIGN KEY (test_data_set_id) REFERENCES uc_test_data_set(id) ,
CONSTRAINT uc_test_data_type_FK FOREIGN KEY (datatype) REFERENCES uc_data_type_lookup(id)
) ;
CREATE TABLE uc_test_data_record (
id nvarchar(100) NOT NULL ,
test_data_set_id nvarchar(100) NOT NULL ,
sort_sequence int NOT NULL ,
CONSTRAINT uc_test_data_record_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_record_FK FOREIGN KEY (test_data_set_id) REFERENCES uc_test_data_set(id)
) ;
CREATE TABLE uc_test_data_record_tag (
id nvarchar(100) NOT NULL ,
test_data_tag_id nvarchar(100) NOT NULL ,
test_data_record_id nvarchar(100) NOT NULL ,
CONSTRAINT uc_test_data_record_tag_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_tag_FK FOREIGN KEY (test_data_tag_id) REFERENCES uc_test_data_tag(id) ,
CONSTRAINT uc_test_data_record_tag_FK FOREIGN KEY (test_data_record_id) REFERENCES uc_test_data_record(id)
) ;
CREATE TABLE uc_test_data_value (
id nvarchar(100) NOT NULL ,
test_data_record_id nvarchar(100) NOT NULL ,
test_data_column_id nvarchar(100) NOT NULL ,
data_value TEXT ,
CONSTRAINT uc_test_data_value_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_record_val_FK FOREIGN KEY (test_data_record_id) REFERENCES uc_test_data_record(id) ,
CONSTRAINT uc_test_data_column_val_FK FOREIGN KEY (test_data_column_id) REFERENCES uc_test_data_column(id)
) ;
MOCA SQL Server for Cycle version 2.7.0 (run fourth)
ALTER TABLE uc_test_data_tag
ADD CONSTRAINT uc_test_data_tag_UC UNIQUE (name);
ALTER TABLE uc_test_data_column
ADD CONSTRAINT uc_test_data_column_UC UNIQUE (test_data_set_id,name);
MOCA Oracle for Cycle version 2.2.0 (run first)
CREATE TABLE uc_cycle_test_execution (
execution_id VARCHAR2(100) NOT NULL,
execution_start_ts timestamp(6) NOT NULL,
cycle_user VARCHAR2(100) NOT NULL,
cycle_version VARCHAR2(100) NOT NULL,
hardware_id VARCHAR2(100) NOT NULL,
computer_username VARCHAR2(100) NOT NULL,
os VARCHAR2(100) NOT NULL,
invoker VARCHAR2(100) NOT NULL,
CONSTRAINT PK_test_execution PRIMARY KEY (execution_id)
) ;
CREATE TABLE uc_cycle_execution_results (
execution_id VARCHAR2(100) NOT NULL,
node_id VARCHAR2(255) NOT NULL,
parent_node_id VARCHAR2(255) DEFAULT NULL,
sending_node_id VARCHAR2(255) NOT NULL,
node_sequence int NOT NULL,
node_type VARCHAR2(100) NOT NULL,
block_type VARCHAR2(100) DEFAULT NULL,
name VARCHAR2(4000) DEFAULT NULL,
status VARCHAR2(100) NOT NULL,
message VARCHAR2(4000) DEFAULT NULL,
error_message VARCHAR2(4000) DEFAULT NULL,
file_uri VARCHAR2(4000) DEFAULT NULL,
start_line int DEFAULT NULL,
end_line int DEFAULT NULL,
data_file_path VARCHAR2(4000) DEFAULT NULL,
worker_name VARCHAR2(4000) DEFAULT NULL,
tags VARCHAR2(4000) DEFAULT NULL,
step_id VARCHAR2(100) DEFAULT NULL,
delay_start_time timestamp(6) DEFAULT NULL,
start_time timestamp(6) NOT NULL,
end_time timestamp(6) DEFAULT NULL,
CONSTRAINT PK_cycle_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT FK_cycle_execution_results FOREIGN KEY (execution_id) REFERENCES uc_cycle_test_execution (execution_id)
) ;
CREATE INDEX cycle_node_type_IDX ON uc_cycle_execution_results (node_type);;
CREATE INDEX cycle_parent_node_IDX ON uc_cycle_execution_results (execution_id,parent_node_id);;
CREATE INDEX cycle_sending_node_IDX ON uc_cycle_execution_results (execution_id,sending_node_id);;
CREATE VIEW uc_cycle_execution_view AS
SELECT test.execution_id,
test.cycle_user,
test.os,
test.computer_username,
test.hardware_id,
test.cycle_version,
cyc_group.name as group_name,
cyc_group.data_file_path,
worker.worker_name,
dtl.node_id,
dtl.node_type,
dtl.name,
dtl.block_type,
dtl.tags,
dtl.status,
dtl.message,
dtl.error_message,
dtl.file_uri,
dtl.start_line,
dtl.end_line,
dtl.delay_start_time,
dtl.start_time,
dtl.end_time,
(sysdate + (dtl.end_time - dtl.start_time) * 1000 - sysdate) * 86400 as duration,
(sysdate + (dtl.end_time - dtl.delay_start_time) * 1000 - sysdate) * 86400 as duration_with_delay,
dtl.node_sequence
from uc_cycle_test_execution test
join uc_cycle_execution_results dtl
on test.execution_id = dtl.execution_id
and node_type not in ('Group','GroupTest','ConditionalBlock','ConditionalExpression')
left join (select execution_id, node_id, parent_node_id, sending_node_id, worker_name from uc_cycle_execution_results where node_type = 'Feature') worker
on dtl.execution_id = worker.execution_id
and dtl.sending_node_id = worker.node_id
left join (select execution_id, node_id, name, data_file_path from uc_cycle_execution_results where node_type = 'Group') cyc_group
on worker.execution_id = cyc_group.execution_id
and worker.parent_node_id = cyc_group.node_id;
MOCA Oracle for Cycle version 2.3.0 (run second)
CREATE TABLE uc_cycle_image (
id VARCHAR2(100) NOT NULL,
image BLOB,
CONSTRAINT PK_CYCLE_IMAGE PRIMARY KEY (id)
) ;
CREATE TABLE uc_cycle_image_results (
id VARCHAR2(100) NOT NULL,
execution_id VARCHAR2(100) NOT NULL,
node_id VARCHAR2(255) NOT NULL,
template_file VARCHAR2(4000),
template_image_id VARCHAR2(100) DEFAULT NULL,
screenshot_image_id VARCHAR2(100) DEFAULT NULL,
found_image CHAR(1) DEFAULT NULL,
min_value BINARY_DOUBLE DEFAULT NULL,
max_value BINARY_DOUBLE DEFAULT NULL,
min_location_x int DEFAULT NULL,
min_location_y int DEFAULT NULL,
max_location_x int DEFAULT NULL,
max_location_y int DEFAULT NULL,
source_width int DEFAULT NULL,
source_height int DEFAULT NULL,
template_width int DEFAULT NULL,
template_height int DEFAULT NULL,
correlation_threshold BINARY_DOUBLE DEFAULT NULL,
CONSTRAINT PK_CYCLE_IMAGE_RESULTS PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_IMAGE_RESULTS FOREIGN KEY (execution_id, node_id) REFERENCES uc_cycle_execution_results (execution_id,node_id) ,
CONSTRAINT FK_CYCLE_TERMINAL_T FOREIGN KEY (template_image_id) REFERENCES uc_cycle_image (id) ,
CONSTRAINT FK_CYCLE_TERMINAL_S FOREIGN KEY (screenshot_image_id) REFERENCES uc_cycle_image (id)
) ;
CREATE TABLE uc_cycle_terminal_screens (
id VARCHAR2(100) NOT NULL,
execution_id VARCHAR2(100) NOT NULL,
node_id VARCHAR2(255) NOT NULL,
screen VARCHAR2(4000),
CONSTRAINT PK_CYCLE_TERMINAL PRIMARY KEY (id) ,
CONSTRAINT FK_CYCLE_TERMINAL FOREIGN KEY (execution_id,node_id) REFERENCES uc_cycle_execution_results (execution_id,node_id)
) ;
CREATE TABLE uc_cycle_file_diagnostics (
id VARCHAR2(100) NOT NULL,
execution_id VARCHAR2(100) NOT NULL,
node_id VARCHAR2(255) NOT NULL,
start_line int,
start_character int,
end_line int,
end_character int,
message VARCHAR2(4000),
severity VARCHAR2(100),
code int,
source VARCHAR2(4000),
CONSTRAINT PK_FILE_DIAGNOSTICS PRIMARY KEY (id) ,
CONSTRAINT FK_FILE_DIAGNOSTICS FOREIGN KEY (execution_id,node_id) REFERENCES uc_cycle_execution_results (execution_id,node_id)
) ;
MOCA Oracle for Cycle version 2.5.0 (run third)
CREATE TABLE uc_data_type_lookup (
id int NOT NULL ,
datatype_desc VARCHAR2(100) NOT NULL ,
CONSTRAINT uc_data_type_lookup_PK PRIMARY KEY (id)
) ;
insert into uc_data_type_lookup values (1, 'STRING');
insert into uc_data_type_lookup values (2, 'INT');
insert into uc_data_type_lookup values (3, 'FLOAT');
CREATE TABLE uc_test_plan (
id VARCHAR2(100) NOT NULL ,
name VARCHAR2(255) NOT NULL ,
is_default CHAR(1) ,
description VARCHAR2(4000) ,
CONSTRAINT uc_test_plan_PK PRIMARY KEY (id)
) ;
CREATE TABLE uc_test_data_tag (
id VARCHAR2(100) NOT NULL ,
name VARCHAR2(255) NOT NULL ,
CONSTRAINT uc_test_data_tag_PK PRIMARY KEY (id)
) ;
CREATE TABLE uc_test_data_set (
id VARCHAR2(100) NOT NULL ,
test_plan_id VARCHAR2(100) NOT NULL ,
name VARCHAR2(255) NOT NULL ,
description VARCHAR2(4000) ,
CONSTRAINT uc_test_data_set_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_set_FK FOREIGN KEY (test_plan_id) REFERENCES uc_test_plan (id)
) ;
CREATE UNIQUE INDEX uc_test_data_set_UN ON uc_test_data_set (test_plan_id,name);
CREATE TABLE uc_test_data_column (
id VARCHAR2(100) NOT NULL ,
test_data_set_id VARCHAR2(100) NOT NULL ,
name VARCHAR2(255) NOT NULL ,
datatype int NOT NULL ,
sort_sequence int NOT NULL ,
CONSTRAINT uc_test_data_column_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_column_FK FOREIGN KEY (test_data_set_id) REFERENCES uc_test_data_set (id) ,
CONSTRAINT uc_test_data_type_FK FOREIGN KEY (datatype) REFERENCES uc_data_type_lookup (id)
) ;
CREATE TABLE uc_test_data_record (
id VARCHAR2(100) NOT NULL ,
test_data_set_id VARCHAR2(100) NOT NULL ,
sort_sequence int NOT NULL ,
CONSTRAINT uc_test_data_record_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_record_FK FOREIGN KEY (test_data_set_id) REFERENCES uc_test_data_set (id)
) ;
CREATE TABLE uc_test_data_record_tag (
id VARCHAR2(100) NOT NULL ,
test_data_tag_id VARCHAR2(100) NOT NULL ,
test_data_record_id VARCHAR2(100) NOT NULL ,
CONSTRAINT uc_test_data_record_tag_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_tag_FK FOREIGN KEY (test_data_tag_id) REFERENCES uc_test_data_tag (id) ,
CONSTRAINT uc_test_data_record_tag_FK FOREIGN KEY (test_data_record_id) REFERENCES uc_test_data_record (id)
) ;
CREATE TABLE uc_test_data_value (
id VARCHAR2(100) NOT NULL ,
test_data_record_id VARCHAR2(100) NOT NULL ,
test_data_column_id VARCHAR2(100) NOT NULL ,
data_value VARCHAR2(4000) ,
CONSTRAINT uc_test_data_value_PK PRIMARY KEY (id) ,
CONSTRAINT uc_test_data_record_val_FK FOREIGN KEY (test_data_record_id) REFERENCES uc_test_data_record (id) ,
CONSTRAINT uc_test_data_column_val_FK FOREIGN KEY (test_data_column_id) REFERENCES uc_test_data_column (id)
) ;
MOCA Oracle for Cycle version 2.7.0 (run fourth)
ALTER TABLE uc_test_data_tag
ADD CONSTRAINT uc_test_data_tag_UC UNIQUE (name);
ALTER TABLE uc_test_data_column
ADD CONSTRAINT uc_test_data_column_UC UNIQUE (test_data_set_id,name);