2014-03-18
• Made running of data tests dependent on correct data types, columns lengths and nullability.
Nigel Stanger committed on 18 Mar 2014
• Removed the modified PHPUnit Autoload.php and switched to explicit loading of custom constraint classes. ...
Nigel Stanger committed on 18 Mar 2014
• Overrode evaluate() to stop it throwing out a too-informative exception.
Nigel Stanger committed on 18 Mar 2014
• Fixed placeholder typo in printf argument.
Nigel Stanger committed on 18 Mar 2014
2014-03-17
• Slightly tweaked output for numeric column length assertion.
Nigel Stanger committed on 17 Mar 2014
• Implemented specialised “non-informative” subclasses of various constraints so that we can test assertions without giving away the answers to the students! (closes #13) ...
Nigel Stanger committed on 17 Mar 2014
• Added customised version of TestCase.php in order to disable output buffering (closes #31 for now).
Nigel Stanger committed on 17 Mar 2014
• Refactored output_stream to outputStream. ...
Nigel Stanger committed on 17 Mar 2014
2014-03-14
• Made data tests dependent on the result of testColumnNullability. Closes #11 for all practical purposes (you still get errors when later dependent table load there fixtures, but there isn’t much that can be done about that).
Nigel Stanger committed on 14 Mar 2014
• Fixed incorrectly nested check for whether testPKColumns had succeeded (closes #7).
Nigel Stanger committed on 14 Mar 2014
• Completely re-engineered the way that fixture setup and teardown is managed so that it can be enabled and disabled on demand (closes #3). ...
Nigel Stanger committed on 14 Mar 2014
• Added initial coding for testing UNIQUE constraints. ...
Nigel Stanger committed on 14 Mar 2014
• Fixed inadvertently duplicated Username test value (also inconsistent with the other test values).
Nigel Stanger committed on 14 Mar 2014
2014-03-12
• Added support for zero or negative scale values. ...
Nigel Stanger committed on 12 Mar 2014
• Removed null min_length and decimals values from WEIGHTED_MARK as they were confusing the schema checker. It makes more sense for them to not just be specified anyway.
Nigel Stanger committed on 12 Mar 2014
• Added constants for verbosity levels. ...
Nigel Stanger committed on 12 Mar 2014
• Made verbosity comparisons more explicit. ...
Nigel Stanger committed on 12 Mar 2014
• Corrected argument name in comment.
Nigel Stanger committed on 12 Mar 2014
2014-03-11
• Added NVL() to query on Data_Precision to prevent spurious errors when precision isn’t specified for a NUMBER column (closes #2, I hope!).
Nigel Stanger committed on 11 Mar 2014
• Updated solution code to reflect changes to specification. ...
Nigel Stanger committed on 11 Mar 2014
2014-03-10
• Changed minimum age of employees to 18. ...
Nigel Stanger committed on 10 Mar 2014
• Added note about subtypes. ...
Nigel Stanger committed on 10 Mar 2014
2014-03-06
• Removed references to “design-level” ERDs and modeified statement about analysis phase.
Nigel Stanger committed on 6 Mar 2014
• Switched to Information Engineering notation to be consistent with INFO 211.
Nigel Stanger committed on 6 Mar 2014
• Initial switch of scenario for 2014.
Nigel Stanger committed on 6 Mar 2014
2013-12-12
• Clarified salaries for senior staff (closes #14).
Nigel Stanger committed on 12 Dec 2013
2013-09-19
Updated solution and comments for 2013 results.
Nigel Stanger committed on 19 Sep 2013
Added some optional constraints.
Nigel Stanger committed on 19 Sep 2013
2013-09-12
Changed the test values for rank and salary to avoid problems with clevel folks who restrict senior salaries to >$100000.
Nigel Stanger committed on 12 Sep 2013
2013-09-05
Workaround for testing FKs when there is more than one FK in the referenced table.
Nigel Stanger committed on 5 Sep 2013