Project Number Date
Kafka DB API Testing live(dev) a0b6f62e-3107-4d69-a080-7c50b94ec999 06 Mar 2022, 20:41

Tag Report

Steps Scenarios Features
Tag Passed Failed Skipped Pending Undefined Total Passed Failed Total Duration Status
@employee 8 0 0 0 0 8 3 0 3 0.029 Passed
Feature: API-KAFKA-DB-Examples - Workflow
Tags: @employee
0.019
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
And create variable empId as key and 1 as value 0.000
When execute DDL for the given sql details on the on employee 0.019
create table employees (emp_no int, birth_date date,first_name VARCHAR(50),last_name VARCHAR(50), gender VARCHAR(50),hire_date date)
Feature: API-KAFKA-DB-Examples - Workflow
Tags: @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 ([empId], DATE '1983-11-17','Danny', 'Ray', 'Male',DATE '2012-03-24')
Feature: API-KAFKA-DB-Examples - Workflow
Tags: @employee
0.008
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.007
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 = [empId]
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.000
EMP_NO,BIRTH_DATE,FIRST_NAME,LAST_NAME,GENDER,HIRE_DATE
i~[empId],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"
}]