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 |