unit test using spring-test-dbunit

Question

My case is that I have two tables which one table has foreign key constraint to the other, and the reference is the other table's field 'id' which will auto increment with every insert, and cannot be omitted for this reference relation, and when I run unit test to test DAO's save(INSERT) method, the comparisonFailure occured for the 'id' is not match(expect 1 but real value is more than 1 and increasing by every run).

How to deal with this case?

the 'id' of the table be referenced cannot be omitted.

NullPointer
– NullPointer

2017-10-12 02:06:52 +00:00
Commented Oct 12, 2017 at 2:06 — NullPointer
– NullPointer, Commented Oct 12, 2017 at 2:06

Jeff · Accepted Answer · 2017-10-13 00:06:48Z

0

Use the dbUnit feature to ignore columns in the comparison.

For example, DefaultPrepAndExpectedTestCase.runTest(...) has a parameter "verifyTables" which is type VerifyTableDefinition and has a constructor parameter "excludeColumns".

Directly, can use one of the "exclude column" methods on DefaultColumnFilter, such as excludedColumnsTable(table, columnNames).

answered Oct 13, 2017 at 0:06

Jeff

9528 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

unit test using spring-test-dbunit

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related