History for sqlmarker / STINK_student_records
2014-03-14
• 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
• 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
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-04
Added legal boundary values for Salary.
Nigel Stanger committed on 4 Sep 2013
2013-09-03
Added the ability to specify that a number column should include no length or decimal places.
Nigel Stanger committed on 3 Sep 2013
Added support for alternative true/false values in PHP, placeholders for them in XML, and a quick and dirty shell script to set them.
Nigel Stanger committed on 3 Sep 2013
Changed sample username to be the same as one in the fixture in order to show up any UNIQUE constraint.
Nigel Stanger committed on 3 Sep 2013
Added legal boundary values.
Nigel Stanger committed on 3 Sep 2013
Added legal boundary values.
Nigel Stanger committed on 3 Sep 2013
2013-09-02
Added default value testing.
Nigel Stanger committed on 2 Sep 2013
2013-08-30
Added legal values test.
Nigel Stanger committed on 30 Aug 2013
Inserted missing </table>.
Nigel Stanger committed on 30 Aug 2013
Added legal min/max values for relevant columns.
Nigel Stanger committed on 30 Aug 2013
Replaced overflow tests with underflow test.
Nigel Stanger committed on 30 Aug 2013
Fixed too-long legal values and added more illegal values.
Nigel Stanger committed on 30 Aug 2013
2013-08-01
Fixed inconsistencies with specification (especially Person.Username).
Nigel Stanger committed on 1 Aug 2013
2013-07-27
Enabled all tables.
Nigel Stanger committed on 27 Jul 2013
Rewrote all classes to match scenario. Also fixed some broken file names.
Nigel Stanger committed on 27 Jul 2013
2013-07-26
Tidied up the FKs in Staff and Student.
Nigel Stanger committed on 26 Jul 2013
Added initial test class files.
Nigel Stanger committed on 26 Jul 2013
Fixed a typo in one of the Staff constraint names.
Nigel Stanger committed on 26 Jul 2013
Added sample SQL schema.
Nigel Stanger committed on 26 Jul 2013
Updated sample answer schema.
Nigel Stanger committed on 26 Jul 2013
2013-07-24
Moved current assignment scenario file into its proper subdirectory.
Nigel Stanger committed on 24 Jul 2013