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).

Archive Collection: Test-Driven Development

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 😳.  

Enjoy!


Test Driven Development

Python-inspired Doc Tests in VBA
Doc tests are not a replacement for unit or integration testing. But they do provide the best return on investment (ROI) of any type of test, mostly because the effort to write them is near zero.

How to Convert a VBA Function to a SQL Server Scalar Function
MS Access Developers Can Remove All the Risk From This Complex Process With These 3 Words
  1. Identify or create test data in Microsoft Access
  2. Build a "test table population query" in Microsoft Access
  3. Create a temporary test table in SQL Server
  4. Use the results of your Access query to populate the test table
  5. Create a dummy scalar function in SQL Server
  6. Build a test query in SQL Server to return failing tests
  7. Execute the test query in SQL Server to verify it fails
  8. Alter the scalar function to address failures
  9. Execute the test query in SQL Server
  10. Repeat steps 8 & 9 until all tests pass

Using TDD to Calculate Holidays in VBA
This article takes you step-by-step through the Test Driven Design process, unencumbered by the complexity of any sort of testing framework.
Converting VBA Long Color Values to RGB
The VBA RGB() function converts red, green, and blue values into a VBA long integer color value. This simple function works in the other direction.

All original code samples by Mike Wolfe are licensed under CC BY 4.0