Archive Collection: Test-Driven Development
I'm on vacation! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: Test-Driven Development (TDD).
I've been writing a daily article here since September 1, 2020; that's over 800 articles. I haven't missed a day yet, and that includes Christmas and Easter. Well, I'm taking my first family vacation since I started writing this blog. Our only other family vacation (which predates the blog) was a National Lampoon's-style disaster. I hope this one is going better.
I'm writing this in the present tense, but I'm writing it for future publication with links to past articles. Let's hope the time-space continuum holds up.
In any case, as the slacker Firstie says to the Stony Lonesome Gate guard twenty minutes before Taps, let me get to the Point. I've got a daily publishing streak to keep up. But I don't want to be writing and publishing articles on vacation. And I still want to provide you with something of value to read each day. So I settled on creating a series of curated article lists that I think you'll find beneficial.
I'm hoping at least some of these articles are ones you haven't read before. And if you're so obsessed with me that you have read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.
Test Driven Development
- Identify or create test data in Microsoft Access
- Build a "test table population query" in Microsoft Access
- Create a temporary test table in SQL Server
- Use the results of your Access query to populate the test table
- Create a dummy scalar function in SQL Server
- Build a test query in SQL Server to return failing tests
- Execute the test query in SQL Server to verify it fails
- Alter the scalar function to address failures
- Execute the test query in SQL Server
- Repeat steps 8 & 9 until all tests pass