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