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?

MckMurray November 18, 2015 15:12

Comments

2 comments

Hello MckMurray,

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

Andrew P November 19, 2015 16:55

0
OK, it's been duly added. If anyone wants to vote for this: http://sqltest.uservoice.com/forums/140716-sql-test-forum/suggestions/2428288-automatically-generate-unit-tests

MckMurray November 20, 2015 10:37

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Ability to &quot;record&quot; unit tests?

Comments