Most Tests require three steps.
1. Preparing test data
2. Execution some business functions
3. Validating the impact on the test data
Lets assume we have a database with some information about people and a we need to test a business function that relocates a person into a new city.
1 Preparing test data
To avoid side effects we execute the test in a transaction
| Script |
SQLCommand |
TransactionDatabase |
| open Connection |
| execute |
begin transaction |
To prepare test data two approaches are possible:
1.1 Inserting new data into a database
1.2 Finding suitable existing data in the database
In this examples we use the second approach and find the ID of users named Ben and Sarah which should move.
We store the Id of the users in a Slim Symbol '$TestID' for future reference.
| SQLCommand |
TransactionDatabase |
select ID, NAME from TestData where Name ='%NAME%' |
| ID? |
NAME |
| $TestID1= |
Ben |
| $TestID2= |
Sarah |
Before we proceed we validate that Ben and Sarah still live in the old Cities: Denver and Paris
| SQLCommand |
TransactionDatabase |
select City from TestData where ID ='%ID%' |
| ID |
CITY? |
| $TestID1 |
Denver |
| $TestID2 |
Paris |
Execution some business functions
Here calls to your business code will go.
A simple update statement which can do the job is given below.
| SQLCommand |
TransactionDatabase |
update TestData set City='%NewCITY%' where ID ='%ID%' |
|
| ID |
NewCITY |
Count? |
| $TestID1 |
HongKong |
1 |
| $TestID2 |
Tokyo |
1 |
Validating the impact on the test data
Finally we check that Ben now lives in Hong Kong and Sarah in Tokyo
| SQLCommand |
TransactionDatabase |
select City from TestData where ID ='%ID%' |
| ID |
CITY? |
| $TestID1 |
HongKong |
| $TestID2 |
Tokyo |
Rollback the change to not impact future tests
| Script |
SQLCommand |
TransactionDatabase |
| open Connection |
| execute |
rollback |
| close Connection |
Check that the rollback worked
| SQLCommand |
TransactionDatabase |
select City from TestData where ID ='%ID%' |
| ID |
CITY? |
| $TestID1 |
Denver |
| $TestID2 |
Paris |