Utility to facilitate fast feedback for learning SQL on a known SQLite database.
Usage: java -jar SQLiteDiff <answer file> <query file>
where ...
answer file
is a CSV representing the desired output of the queryquery file
is a text file containing only SQL to run
The utility reads the query file, executes it on a bundled SQLite database, and then compares rows/columns to the contents of the answer file, providing a detailed account of differences.
Note: the included database is currently Chinook [https://github.com/lerocha/chinook-database] but could theoretically be any SQLite database.
Tested on latest versions of macOS, Ubuntu, and Windows using Oracle/Open JDK 8 - 14.