Multi-operation SQL testing in TestComplete
Hello all, I have been using TestComplete a long time to test our Delphi application with an MS SQL database. I have quite a few SQL validation tests, but they're all in the nature of building...
Forum Discussion
Most of the testing involves procedure calls where I don't necessarily need to know what's going on inside of them (many tables and other procedures may be involved), only some resulting data changes. So unfortunately sucking the data into local tables and then deleting them afterwards is not really feasible.
I'm really looking for some way to leverage the SQL ability to perform multiple operations in a transaction, then use the rollback command to undo the entire transaction. That way SQL handles all the work of tracking what needs to be undone.
Thanks.
Allen
PS I've been doing this with an open source tool called DBFit based on FitNesse, but after years of neglect by the developer it's getting very fragile and I'm looking for a replacement.
I'm really looking for some way to leverage the SQL ability to perform multiple operations in a transaction, then use the rollback command to undo the entire transaction. That way SQL handles all the work of tracking what needs to be undone.
Thanks.
Allen
PS I've been doing this with an open source tool called DBFit based on FitNesse, but after years of neglect by the developer it's getting very fragile and I'm looking for a replacement.