PlugIns JdbcSlim UserGuide 1ASimpleExample WritingGenericRequirementsWithAlias
| Define Properties | FindTestUserIDs |
| key | value |
| .include | TransactionDatabase |
| cmd | select ID, NAME from TestData where Name ='%NAME%' |
| Define Properties | CheckInitalCityOfUsers |
| key | value |
| .include | TransactionDatabase |
| cmd | select City from TestData where ID ='%ID%' |
| Define Properties | RelocateUserToNewCity |
| key | value |
| .include | TransactionDatabase |
| cmd | update TestData set City='%NewCITY%' where ID ='%ID%' |
| Define Properties | CheckFinalCityOfUsers |
| key | value |
| .include | TransactionDatabase |
| cmd | select City from TestData where ID ='%ID%' |
| Script | SQLCommand | FindTestUserIDs |
| $FTU= | get fixture | |
| Define alias | |
| find test users | table: $FTU |
| Script | SQLCommand | CheckInitalCityOfUsers |
| $CICoU= | get fixture | |
| Define alias | |
| check first city of users | table: $CICoU |
| Script | SQLCommand | RelocateUserToNewCity |
| $RUTNC= | get fixture | |
| Define alias | |
| relocate users | table: $RUTNC |
| Script | SQLCommand | CheckFinalCityOfUsers |
| $CFCoU= | get fixture | |
| Define alias | |
| Check city after relocation | table: $CFCoU |
To avoid side effects we execute the test in a transaction
| Script | SQLCommand | TransactionDatabase |
| open Connection | ||
| execute | begin transaction | |