Cucumber Reports (no 676b8b35-c7c3-4fad-8760-e153edbc1169)

Project	Number	Date
Lakeside Mutual - Customer Self-Service - API and Database(test)	676b8b35-c7c3-4fad-8760-e153edbc1169	06 Mar 2022, 20:40

	Steps	Scenarios	Features
@sql_validate	7	0	0	0	0	7	2	0	2	1.420	Passed

Feature: CSS-Accept-DB - Workflow

1.369

Scenario InsuranceQuoteByDB - database action

Hooks

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

Steps

Given as a user perform sql query action 0.000

When read details on the given query on cssdb 1.369

select iqr.id, iq.insurance_premium_amount, iq.insurance_premium_currency, iq.policy_limit_amount from insurancequotes iq INNER JOIN insurancequoterequests iqr on iq.id = iqr.insurance_quote_id and iqr.id = [quoteId]

SelectSql:

{
    "resource": "cssdb",
    "sql": "select iqr.id, iq.insurance_premium_amount, iq.insurance_premium_currency, iq.policy_limit_amount from insurancequotes iq INNER JOIN insurancequoterequests iqr on iq.id = iqr.insurance_quote_id and iqr.id  =  466"
}

SqlResponse:

[{"id":466,"insurance_premium_amount":500.00,"insurance_premium_currency":"CHF","policy_limit_amount":50000.00}]

Then validate information on the given details on cssdb 0.000

id,insurance_premium_amount, insurance_premium_currency, policy_limit_amount

i~[quoteId],d~500.00,CHF,d~50000.00

ActualQueryResponse

[{
    "policy_limit_amount": 50000,
    "insurance_premium_amount": 500,
    "id": 466,
    "insurance_premium_currency": "CHF"
}]

ExpectedResponse:

[{
    "id": 466,
    "insurance_premium_amount": 500,
    "insurance_premium_currency": "CHF",
    "policy_limit_amount": 50000
}]

And store policy_limit_amount as key and query's [0].policy_limit_amount as value 0.000

Feature: CSS-Reject-DB - Workflow