track-db-test-library

Test library for Track database challenges

Usage

• API document
• How to develop SQL challenges (ja)

License

This software is released under the MIT License.

Release Note

Version 2.6.0

• [Feat] MySQL support

Version 2.5.0

• [Feat] Allow multiple checks in a single testcase (Runner)
• [Feat] Checks for record length (Runner)
• [Feat] Checks for table schema (API / Runner)
• [Feat] Checks for auto increment (API / Runner)
• [Feat] Checks for last executed SQL (Runner)
• [Feat] Prechecks: column / without (Runner)
• [Feat] Multiple test case generation with a simple template engine
• [Feat] Performance check (Runner)
• [Feat] Checks for column list (Runner)
• [Feat] Combine multiple checks into one testcase (Runner)

Version 2.4.0

• [Feat] Improve error message in recordEqual processing when column names are different.
• [Security] Security updates

Version 2.3.1

• [Bugfix] The precheck process in handling whitespace.

Version 2.3.0

• Bump sqlite3 to 5.0.11

Version 2.2.0

• [Feat] Add precheck.one_command to check if the file contains only one command.

Version 2.1.0

• [Feat] settings/max_display_rows test configuration
• [Feat] --limit, --result=full options to track-db.js
• [Feat] Block comment support
• [Bugfix] diff is not displayed correctly under certain conditions