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-select 4 0 0 0 0 4 1 0 1 0.141 Passed
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