Ability to "record" unit tests?
I've been looking around for a product that can "record" and script out a tSQLt test.
But i have not even found a mention of anything like what I'm looking for.
Basically, I imagine building a query and pressing "record test". It would run the query, analyse the outputs and result sets, and then create a tSQLt test which assumes you will get the exact same result every time you run with the same parameters. Of course this assumes the query is deterministic which is not always the case, but it would be a great starting point and also a learning tool for those starting out with tSQLt.
It would be perfect for refactoring code.
How about adding something like this to SQL Test?
But i have not even found a mention of anything like what I'm looking for.
Basically, I imagine building a query and pressing "record test". It would run the query, analyse the outputs and result sets, and then create a tSQLt test which assumes you will get the exact same result every time you run with the same parameters. Of course this assumes the query is deterministic which is not always the case, but it would be a great starting point and also a learning tool for those starting out with tSQLt.
It would be perfect for refactoring code.
How about adding something like this to SQL Test?
Comments
Thanks for posting in the forum!
That sounds like an excellent suggestion for our SQL Test UserVoice forum http://sqltest.uservoice.com/forums/140 ... test-forum
The devs use the forum when determining future work for the tools.
Thanks for the great feedback and I have followed up with you via email as well.
Have a great week!
Warmly,
Andrew Pierce
Technical Sales Engineer
Redgate Software