• Fixed placeholder typo in printf argument.

• Slightly tweaked output for numeric column length assertion.

• Implemented specialised “non-informative” subclasses of various constraints so that we can test assertions without giving away the answers to the students! (closes #13) ...

• Refactored a couple of variable names.
• Fixed punctuation in assertion output.

• Completely re-engineered the way that fixture setup and teardown is managed so that it can be enabled and disabled on demand (closes #3). ...

• Fixed a bug in SimpleTestListener that caused a crash when a table didn’t exist in the schema being tested.
• Added proper error reporting for missing tables.

• Added initial coding for testing UNIQUE constraints. ...

• Removed unused argument to sprintf in assertFKColumns().

• Added support for zero or negative scale values. ...

• Improved reporting of precision/scale vs. length for NUMBER vs. *CHAR.
• Added NVL() to Data_Scale to eliminate spurious errors.
• Added debug output.

• Added NVL() to query on Data_Precision to prevent spurious errors when precision isn’t specified for a NUMBER column (closes #2, I hope!).

Workaround for testing FKs when there is more than one FK in the referenced table.

Added the ability to specify that a number column should include no length or decimal places.

Fixed handling of literal text and date default values.

Added default value testing.

Fixed sense of underflow constraint violation test.

assertColumnLegalValue() now correctly fails if the legal value generates a constraint violation.

Added support for detecting column aliases (can’t do much about it other than warn the user, as the fixture won’t match if the name’s different anyway).

Added a comment explaining why a WITH won’t solve the LONG problem in User_Constraints.

- Changed run mode and verbosity variables to global constants. ...

- Added different output for some tests based on RUN_MODE.
- Cleaned up output for all tests.

Fixed output typos.

Removed some obsolete console output.

Fixed incorrect array nesting in assertFKColumns.

Moved scenario-specific code into scenario subtree and factored out globally defined values into various configuration files. Also replaced a bunch of things with global constants.

Temporarily stripped out text that would reveal information to students. Need a better solution long-term!

Implemented new error reporting scheme using subclasses of SimpleTestListener.

Implemented Reporter support for use within assert() methods.

Factored out connection login details.

Made the database connection reusable rather than recreating it every time.

Fixed typo in output.

Ensured that maximum and minimum column length assertions are only asserted where actually relevant.

Rewrote provideColumnLengths() to return fixed rather than variable-length result.

- Improved descriptive output. ...

- Added sqlifyValue function to improve flexibility of SQL string handling.
- Renamed 'type' property to 'sql_type'.
- Added 'generic_type' property.
- Improved testing of legal and illegal values.

Added preliminary output based on whether an illegal value is rejected by a constraint or an actual overflow.