[Assignment Spec]  [Database Design]  [Examples]  [Testing]  [Submitting]

Definition: in the instructions below, the phrase "CSE server" refers to any of the Vlab servers (e.g. vx2, vx5 but NOT vxdb02) or any of the large CSE servers (e.g. williams or wagner). You can store your ass2.sql file on any of these servers, but you can only run PostgreSQL on vxdb or your home machine.

How you submit your assignment depends on where your Python scripts and ass2.sql file is located.

If your Python scripts and ass2.sql are on your home machine and if you are supremely confident that it will work ok on the CSE servers, then the easiest way to submit is via Webcms3.

If you are sensible, you will first copy your files to a CSE server, test it on vxdb02, and then submit via the give command:

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

Do NOT run give on vxdb02. It may work and submit your files, or it may not.

Note that you must submit ass2.sql even if you make no changes to it.

Testing your code involves interacting with two servers: vxdb02 and any CSE server. The code files, however should only be placed on a CSE server.

Here's a suggestion for managing your work:

# on a CSE server
vlab$ mkdir  -p  /home/$USER/cs3311/ass2
vlab$ cd /home/$USER/cs3311/ass2
# create your code files here
# using your favourite editor

# on the vxdb02 server
vxdb02$ p1   #  run your PostgreSQL server
vxdb02$ cd /home/$USER/cs3311/ass2

# if you don't already have an ass2 database
vxdb02$ createdb ass2
vxdb02$ psql ass2 -f /home/cs3311/web/26T2/assignments/ass2/ass2.dump

# load your SQL code, if any
vxdb02$ psql ass2 -f ass2.sql

# do some manual testing via e.g.
vxdb02$ python3 q2.py 'Waverley Council'
vxdb02$ python3 q4.py apartment near 'randwick' 3 beds 2 baths 1 cars
# etc. etc.

Then use autotest to test everything at once, or individually.

Finally, submit you work using give as above.

After submissions have closed, we will test your work using the suppplied ass2.dump database and the queries in the autotest suite. We will then test it on a different unseen database with the same schema as the original ass2.dump, but a different set of properties and a more extensive set of queries on the q4.py script. You should write your SQL code in such a way that it works on any database based on the supplied schema.