PlugIns JdbcSlim UserGuide 1ASimpleExample SeparatingSqlCommandsAndRequirements
| 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%' |
To avoid side effects we execute the test in a transaction
| Script | SQLCommand | TransactionDatabase |
| open Connection | ||
| execute | begin transaction | |