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 |