[Specification]  [Database]  [SQL Schema]  [Grades+Rules]  [Examples]  [Testing]  [Submitting]  [Fixes+Updates]

Introduction

This document describes what you need to submit and how it will be tested.

You can submit either via give on the command-line or via the Webcms3 submission page.

Submission via give on a CSE server (e.g. VLab) uses the following command:

give cs3311 ass2 helpers.sql helpers.py q1.py q2.py q3.py q4.py q5.py

assuming that you are in the directory containing these files.

For testing we do the following: (using a fully-patched ass2.dump):

$ dropdb ass2                  ... remove any existing DB
$ createdb ass2                ... create an empty database
$ psql ass2 -f ..../ass2.dump    ... load the MyMyUNSW schema and data
$ psql ass2 -f helpers.sql        ... load your SQL code

We then run our automark script. This will include the autotest tests, plus some extra tests on an unseen database..

Note: if there are views or functions that only exist in your copy of the database, and are not in helpers.sql, you will most likely fail many tests.

You must ensure that your helpers.sql file will load correctly (i.e., it has no syntax errors and it contains all of your view definitions in the correct order). If we need to manually fix problems with your helpers.sql file in order to test it (e.g., change the order of some definitions), you will be fined via a 1 mark penalty on your ceiling mark (i.e., the maximum you can score is 15 out of 16 marks).

If your Python scripts contain load-time errors, you will fail all tests for that script. If your Python scripts have run-time errors, you will fail all tests in which a run-time error occurs.

Most of the marks are based on auto-testing. There is 2 marks for style, if you ensure that your SQL and Python code is not hideous.