Project Number Date
Customer Self Service 1 06 Mar 2022, 20:36

Tag Report

Steps Scenarios Features
Tag Passed Failed Skipped Pending Undefined Total Passed Failed Total Duration Status
@sql 10 0 0 0 0 10 4 0 4 0.266 Passed
Feature: Data-Integrity-Testing - Workflow
Tags: @ddl @sql @employee
0.125
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given as a user perform sql query action 0.000
When execute DDL for the given sql details on the on employee 0.125
create table employees (emp_no int, birth_date date,first_name VARCHAR(50),last_name VARCHAR(50), gender VARCHAR(50),hire_date date)
Feature: Data-Integrity-Testing - Workflow
Tags: @sql-insert @sql @employee
0.000
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given as a user perform sql query action 0.000
When execute INSERT for the given sql details on the on employee 0.000
insert into employees (emp_no,birth_date,first_name,last_name, gender,hire_date) values (1, DATE '1983-11-17','Danny', 'Ray', 'Male',DATE '2012-03-24')
Feature: Data-Integrity-Testing - Workflow
Tags: @sql-select @sql-verfiy @sql @store_sql_response @employee
0.141
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given as a user perform sql query action 0.000
When read details on the given query on employee 0.130
select emp_no, to_char(birth_date, 'YYYY-mm-DD') birth_date ,first_name,last_name, gender,to_char(hire_date , 'YYYY-mm-DD') hire_date from employees where emp_no = 1
SelectSql: 
{
    "resource": "employee",
    "sql": "select emp_no, to_char(birth_date, 'YYYY-mm-DD') birth_date ,first_name,last_name, gender,to_char(hire_date , 'YYYY-mm-DD') hire_date from employees where emp_no = 1"
}
SqlResponse: 
[{"EMP_NO":1,"BIRTH_DATE":"1983-11-17","FIRST_NAME":"Danny","LAST_NAME":"Ray","GENDER":"Male","HIRE_DATE":"2012-03-24"}]
Then validate information on the given details on employee 0.011
EMP_NO,BIRTH_DATE,FIRST_NAME,LAST_NAME,GENDER,HIRE_DATE
i~1,1983-11-17,Danny,Ray,Male,2012-03-24
ActualQueryResponse 
[{
    "HIRE_DATE": "2012-03-24",
    "BIRTH_DATE": "1983-11-17",
    "EMP_NO": 1,
    "GENDER": "Male",
    "LAST_NAME": "Ray",
    "FIRST_NAME": "Danny"
}]
ExpectedResponse: 
[{
    "EMP_NO": 1,
    "BIRTH_DATE": "1983-11-17",
    "FIRST_NAME": "Danny",
    "LAST_NAME": "Ray",
    "GENDER": "Male",
    "HIRE_DATE": "2012-03-24"
}]
And store empId as key and query's [0].EMP_NO as value 0.000
Feature: Data-Integrity-Testing - Workflow
Tags: @sql-delete @sql @employee
0.000
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given as a user perform sql query action 0.000
When execute DELETE for the given sql details on the on employee 0.000
delete from employees where emp_no = [empId]