db-check

Creates DbUnit dataset for specified table and verifies it against a database

Overview

e:db-check

<e:db-check caption="optional caption" table="ANDROIDS_TABLE" cols="id, name" separator=",">
    <e:row>1, Adam</e:row>
    <e:row>2, Bob</e:row>
</e:db-check>  

Usage

1. Configure a connection to database via DbPlugin.

2. Use e:db-check tag in specification:

<e:db-check caption="optional caption" table="ANDROIDS_TABLE" cols="id, name" separator=",">
    <e:row>1, Adam</e:row>
    <e:row>2, Bob</e:row>
</e:db-check>  

Attributes

table="androids_table"

cols="id=1..10, name, height=170, manufactured={{now}}"

separator="|"

where="name='andrew'"

where="name='andrew'"

caption="Androids"

orderBy="name, height"

ignoreRowsBefore="2"

ignoreRowsAfter="2"

awaitAtMostSec="4"

awaitPollDelayMillis="1000"

awaitPollIntervalMillis="500"

Each dataset record will be zipped from cols and rows declarations (hence order of cols and order of values inside rows should match).

<e:db-check table="ANDROIDS_TABLE" cols="id, name, height, manufactured">
  <e:row>1, Adam, 170, {{today}}</e:row>
  <e:row>2, Bob, 200, {{today}}</e:row>
</e:db-check>

If all rows should have the same value declaration for specific column, then value assignment may be inlined with column declaration. Values declaration for such columns should be omitted in e:row tag.

The next example produces the same result as the previous one:

<e:db-check table="ANDROIDS_TABLE" cols="id=1..2, name, height, manufactured={{today}}">
  <e:row>Adam, 170</e:row>
  <e:row> Bob, 200</e:row>
</e:db-check>

Examples

Value declaration

Value can be declared as simple text, Handlebar helpers invocation or ranges.

<e:db-check table="ANDROIDS_TABLE" cols="id=1..10, name, weight, manufactured={{today minus='1 d'}}">
  <e:row>Adam, 70</e:row>
  <e:row>Bob , 90</e:row>
</e:db-check>

Trimmed spaces

Values declarations a trimmed by default, if there is a need to preserve spaces, then declaration should be surrounded by '

<e:db-check table="ANDROIDS_TABLE" cols="name, weight">
  <e:row> ' A ' , 70</e:row>
  <e:row> A , 90</e:row>
</e:db-check>

Values with commas

Comma is used as default values separator, so using it as part as the value declaration will break parsing. To workaround this custom value separator may be set by separator attribute.

<e:db-check table="ANDROIDS_TABLE" cols="id=1..10, name, weight" separator="|">
  <e:row> a , b | 70</e:row>
</e:db-check>

Verifying a subset of data

To verify only a subset of actual data satisfying specific condition the where attribute can be used to provide filter in database-specific SQL format. The provided attribute value will be used as-is in WHERE clause of SQL SELECT expression.

<e:db-check table="ANDROIDS_TABLE" cols="name, height" where="name='Adam' and height=170">
  <e:row>Adam, 170</e:row>
</e:db-check>

Verifying table is empty

To verify that table is empty an empty e:db-check tag can be used with single table attribute.

<e:db-check table="ANDROIDS_TABLE"/>

More

• How do check failures look like?