Data Store DDLs

JDBC Database

DDLs for table creation -

MySQL, SQL Server, Oracle, DB2 Linux, DB2 AS400, H2

DB: mysql
DDL:
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 execution_results_test_execution_FK FOREIGN KEY (execution_id) REFERENCES cycle_test_execution (execution_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE  INDEX execution_results_node_type_IDX ON cycle_execution_results (node_type) USING BTREE;
CREATE  INDEX execution_results_execution_id_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id) USING BTREE;
CREATE  INDEX execution_results_execution_id_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;
----------
DB: sqlserver
DDL:
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_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT execution_results_test_execution_FK FOREIGN KEY (execution_id) REFERENCES cycle_test_execution(execution_id)
);
CREATE  INDEX execution_results_node_type_IDX ON cycle_execution_results (node_type);
CREATE  INDEX execution_results_execution_id_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id);
CREATE  INDEX execution_results_execution_id_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;
----------
DB: oracle
DDL:
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(1000) DEFAULT NULL,
status VARCHAR2(100) NOT NULL,
message VARCHAR2(1000) DEFAULT NULL,
error_message VARCHAR2(1000) DEFAULT NULL,
file_uri VARCHAR2(1000) DEFAULT NULL,
start_line int DEFAULT NULL,
end_line int DEFAULT NULL,
data_file_path VARCHAR2(1000) DEFAULT NULL,
worker_name VARCHAR2(1000) DEFAULT NULL,
tags VARCHAR2(1000) 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_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT execution_results_test_execution_FK FOREIGN KEY (execution_id) REFERENCES cycle_test_execution (execution_id)
);
CREATE  INDEX execution_results_node_type_IDX ON cycle_execution_results (node_type);
CREATE  INDEX execution_results_execution_id_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id);
CREATE  INDEX execution_results_execution_id_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 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;
----------
DB: db2linux
DDL:
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 VARCHAR2(1000) DEFAULT NULL,
status VARCHAR(100) NOT NULL,
message VARCHAR2(1000) DEFAULT NULL,
error_message VARCHAR2(1000) DEFAULT NULL,
file_uri VARCHAR2(1000) DEFAULT NULL,
start_line INT DEFAULT NULL,
end_line INT DEFAULT NULL,
data_file_path VARCHAR2(1000) DEFAULT NULL,
worker_name VARCHAR2(1000) DEFAULT NULL,
tags VARCHAR2(1000) 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_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT execution_results_test_execution_FK FOREIGN KEY (execution_id) REFERENCES cycle_test_execution(execution_id)
);
CREATE  INDEX execution_results_node_type_IDX ON cycle_execution_results (node_type);
CREATE  INDEX execution_results_execution_id_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id);
CREATE  INDEX execution_results_execution_id_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,
   timestampdiff(1, char(dtl.end_time - dtl.start_time)) / 1000 as duration,
   timestampdiff(1, char(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;
----------
DB: db2as400
DDL:
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 VARCHAR2(1000) DEFAULT NULL,
status VARCHAR(100) NOT NULL,
message VARCHAR2(1000) DEFAULT NULL,
error_message VARCHAR2(1000) DEFAULT NULL,
file_uri VARCHAR2(1000) DEFAULT NULL,
start_line INT DEFAULT NULL,
end_line INT DEFAULT NULL,
data_file_path VARCHAR2(1000) DEFAULT NULL,
worker_name VARCHAR2(1000) DEFAULT NULL,
tags VARCHAR2(1000) 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_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT execution_results_test_execution_FK FOREIGN KEY (execution_id) REFERENCES cycle_test_execution(execution_id)
);
CREATE  INDEX execution_results_node_type_IDX ON cycle_execution_results (node_type);
CREATE  INDEX execution_results_execution_id_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id);
CREATE  INDEX execution_results_execution_id_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,
   timestampdiff(1, char(dtl.end_time - dtl.start_time)) / 1000 as duration,
   timestampdiff(1, char(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;
----------
DB: h2
DDL:
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_execution_results PRIMARY KEY (execution_id,node_id),
CONSTRAINT execution_results_test_execution_FK FOREIGN KEY (execution_id) REFERENCES cycle_test_execution(execution_id)
);
CREATE  INDEX execution_results_node_type_IDX ON cycle_execution_results (node_type);
CREATE  INDEX execution_results_execution_id_parent_node_IDX ON cycle_execution_results (execution_id,parent_node_id);
CREATE  INDEX execution_results_execution_id_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;
----------

MOCA Database

DDLs for Table Creation -

SQL Server, Oracle, and DB2

MOCA: SQL Server
[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_execution_results PRIMARY KEY (execution_id,node_id),
  CONSTRAINT execution_results_test_execution_FK FOREIGN KEY (execution_id) REFERENCES uc_cycle_test_execution(execution_id)
)];
[CREATE  INDEX execution_results_node_type_IDX ON uc_cycle_execution_results (node_type)];
[CREATE  INDEX execution_results_execution_id_parent_node_IDX ON uc_cycle_execution_results (execution_id,parent_node_id)];
[CREATE  INDEX execution_results_execution_id_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: Oracle
[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(1000) DEFAULT NULL,
  status VARCHAR2(100) NOT NULL,
  message VARCHAR2(1000) DEFAULT NULL,
  error_message VARCHAR2(1000) DEFAULT NULL,
  file_uri VARCHAR2(1000) DEFAULT NULL,
  start_line int DEFAULT NULL,
  end_line int DEFAULT NULL,
  data_file_path VARCHAR2(1000) DEFAULT NULL,
  worker_name VARCHAR2(1000) DEFAULT NULL,
  tags VARCHAR2(1000) 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_execution_results PRIMARY KEY (execution_id,node_id),
  CONSTRAINT execution_results_test_execution_FK FOREIGN KEY (execution_id) REFERENCES uc_cycle_test_execution (execution_id)
)];
[CREATE  INDEX execution_results_node_type_IDX ON uc_cycle_execution_results (node_type)];
[CREATE  INDEX execution_results_execution_id_parent_node_IDX ON uc_cycle_execution_results (execution_id,parent_node_id)];
[CREATE  INDEX execution_results_execution_id_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 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: DB2
[CREATE TABLE uc_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 uc_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 VARCHAR2(1000) DEFAULT NULL,
  status VARCHAR(100) NOT NULL,
  message VARCHAR2(1000) DEFAULT NULL,
  error_message VARCHAR2(1000) DEFAULT NULL,
  file_uri VARCHAR2(1000) DEFAULT NULL,
  start_line INT DEFAULT NULL,
  end_line INT DEFAULT NULL,
  data_file_path VARCHAR2(1000) DEFAULT NULL,
  worker_name VARCHAR2(1000) DEFAULT NULL,
  tags VARCHAR2(1000) 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_execution_results PRIMARY KEY (execution_id,node_id),
  CONSTRAINT execution_results_test_execution_FK FOREIGN KEY (execution_id) REFERENCES uc_cycle_test_execution(execution_id)
)];
[CREATE  INDEX execution_results_node_type_IDX ON uc_cycle_execution_results (node_type)];
[CREATE  INDEX execution_results_execution_id_parent_node_IDX ON uc_cycle_execution_results (execution_id,parent_node_id)];
[CREATE  INDEX execution_results_execution_id_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,
       timestampdiff(1, char(dtl.end_time - dtl.start_time)) / 1000 as duration,
       timestampdiff(1, char(dtl.end_time - dtl.delay_start_time)) / 1000 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]
    ----------

results matching ""

    No results matching ""