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

A weird testscript behavior.

I have started writing a testscript cookbook, with the intention of showing most of the interesting uses of cookbook. The first recipe I engaged with was Automatic tool build without external commands, and while I was explaining (to myself, more than future readers) some of the intricacies of the command...

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