DbUnit operations allows to append, update and delete rows.
Append rows
.product
[{db-set-insert}]
,===
id, name, price
3, Carl, 30
,===
When append row:
id | name | price |
---|---|---|
3 |
Carl |
30 |
id | name | price |
---|---|---|
3 | Carl | 30 |
Then row added:
id | name | price |
---|---|---|
1 | Adam | 10.00 |
2 | Bob | 20.00 |
3 | Carl | 30.00 |
Update rows
.product
[{db-set-update}]
,===
id, name, price
2, Bob2, 22
,===
When update row
id | name | price |
---|---|---|
2 |
Bob2 |
22 |
id | name | price |
---|---|---|
2 | Bob2 | 22 |
Then second row updated
id | name | price |
---|---|---|
1 | Adam | 10.00 |
2 | Bob2 | 22.00 |
Delete rows
.product
[{db-set-delete}]
,===
id
2
,===
When delete row
id |
---|
2 |
id |
---|
2 |
Then second row deleted
id | name | price |
---|---|---|
1 | Adam | 10.00 |