assertj / assertj/assertj-db

row(index).column("ABC") and row().row().row().column("ABC") always referring to row 0 itself

Open
#290 1 comment 0 reactions 0 assignees View on GitHub
question
Dominant language
Java
Stars
130
Forks
21
PR merge metrics
No merged PRs in 30d

Description

Hi,
I am trying to read the value at ROW index 3 and column ABC, when i execute below code, getting below error message.
Source source = new Source("jdbc:sqlserver://localhost;database=KMSupportShipping_Office;encrypt=true;trustServerCertificate=true;integratedSecurity=True","","");

String Query1 = " select * from bu_customer where id='I15910'";
Table TABLE_BU_Customer = new Table(source, "bu_customer");
assertThat(TABLE_BU_Customer)
.row(3)
.column(7)
.value().isEqualTo("700");

Error:

java.lang.AssertionError: [Value at **index 0** of Column at index 7 (column name : AMOUNT) of bu_customer table]
Expecting:
<"100000.0000">
to be equal to:
<"700">

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.