STK/Unit

STK/Unit is an open source command-line SQL testing framework, especially designed to work with the MySQL and MariaDB databases. It stores the output in internal tables.

With STK/Unit users will be able to create Base Tests (Stored Procedures), which are part of Test Cases (databases), as well as Test Suites (other Stored Procedures). It was inspired by JUnit and SimpleTest.

The software will record output in MariaDB database tables, which can be later retrieved as HTML or human-readable text. There are high-level assertions which are specifically designed for SQL databases.

What is new in this release:

• Now show_err works on 5.6 and 10.0
• No more obscure exceptions with server versions older than 5.5
• Fixed charset problems
• A Foreign Key now prohibits to change test_run IDs
• Moved meta_schema definition into meta.sql
• Specify missing CHARACTER SET & COLLATION clauses for databases and tables
• Tests: test_databases_character_sets, test_func_character_sets,
• test_routine_params_character_sets
• COMMITs after each SQL file
• meta_schema has changed
• SIGNAL & RESIGNAL executable comments from 5.4.4
• Errors CLASS_ORIGIN is always set to 'STK/Unit'
• Stricter variables during installation
• New asserts (plus not variants)

What is new in version 1.0 RC4:

• Often read options are now cached
• Make sure that AUTO_CLEAN works if foreign_key_checks is off (rare!)
• During installation, server bahavior is now strict
• Some table options for better Aria integrity and MEMORY performance
• BTs are now executed alphabetically, not in undefined order
• added ts() and tc() (was a trivial feature request)
• show_* routines
• Fix: #1174710

What is new in version 1.0 RC3:

• This RC works on ALL MySQL/MariaDB versions, except for My 5.0, with very low delta from previous release.

What is new in version 1.0 RC2:

• This version works with MySQL 5.1 (please read the documentation before installing) and fixes minor problems.