[Specification]  [Database]  [Examples]  [Testing]  [Submitting]

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 (once they're set up).

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

give cs3311 ass2 helpers.sql helpers.py dirby releases genres roles movie

assuming that you are in the directory containing these files.

For testing we do the following:

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

We then run a check script like one you have been using. This will include the current tests, plus some extra unseen tests.

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 19 out of 20 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 1 mark if you ensure that your SQL and Python code is not hideous.