The Data Charmer Thoughts and notes on software development, databases, and QA

The end of dbdeployer

dbdeployer has come to the end of maintenance, and won’t be updated anymore. I am looking for volunteers to take over the development, if there is still interest in using it. A bit of history dbdeployer has been a project that has kept my attention for 18 years. It started...

Solving testscript problems

In the previous post, we left with the realization that something was still missing to run a full test of dbdeployer with testscript. Let’s recapitulate: We have solved the problem of repeating scripts with minimal variation by using templates and creating the testdata scripts on-the-fly We have created custom commands...

Enhancing testscript tests with custom commands and conditions

In the previous posts we have used built-in testscript commands and conditions. Some commands are exec, stdout, exists. These commands are convenient, but they can’t do everything we need for our testing. Fortunately, testscript allows users to create their own commands. There are two ways of adding custom commands: Using...

Using testscript with dbdeployer and templates

In the previous post we saw several problems with testscript usage. In this post we’ll focus on these three problems: HOME directory and TMPDIR need to be customized MySQL version needs to be repeated for each script The stdout regular expression cannot contain variables. The solution for all the above...

First attempt at testscript with dbdeployer

Getting testscript to do the heavy lifting My main reason for exploring testscript is that I want a framework that allows me to test compiled applications reliably, within regular Go testing files. The app to which I want to apply this experience is dbdeployer, a tool that allows the deployment...