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

In order to test your assignment, you need to set up the following pre-conditions:

• you are logged in to vxdb02
• your postgreSQL server is running
• you are in the directory containing ass2.sql and the Python scripts

You then run the command:

$ 3311 autotest ass2

And if you're lucky, you see output something like this:

$ 3311 autotest ass2
... setting up stuff ...
--- Loading Database Dump ---
... messages about loading database ...
... should be no errors here ...
--- Loading Student Submission ---
... messages about loading ass2.sql ...
... there may be errors ...

./sql_clean # q1.py
dos2unix: converting file q1.py to Unix format...
dos2unix: converting file q2.py to Unix format...
dos2unix: converting file q3.py to Unix format...
dos2unix: converting file q4.py to Unix format...
Test Q0_Create_Database (Load the database with the dump file (should always succeed)) - passed
Test Q1_A ('python3 q1.py') - passed
Test Q2_A ('python3 q2.py') - passed
Test Q2_B ("python3 q2.py 'City of Randwick'") - passed
Test Q2_C ('python3 q2.py waverley') - passed
Test Q2_D ("python3 q2.py 'Waverley Council'") - passed
Test Q2_E ("python3 q2.py 'Bayside Council'") - passed
Test Q2_F ("python3 q2.py 'Rockdale Municipality'") - passed
Test Q2_G ("python3 q2.py 'Municipality of Woollahra'") - passed
Test Q2_H ("python3 q2.py 'Borough of Botany Bay'") - passed
Test Q3_A ('python3 q3.py') - passed
Test Q3_B ('python3 q3.py outer') - passed
Test Q3_C ('python3 q3.py inner') - passed
Test Q3_D ('python3 q3.py greater') - passed
Test Q3_E ('python3 q3.py whatever') - passed
Test Q4_A ('python3 q4.py') - passed
Test Q4_B ('python3 q4.py hotel in randwick') - passed
Test Q4_C ('python3 q4.py house between 'the rocks'') - passed
Test Q4_D ("python3 q4.py apartment in 'castle crag'") - passed
Test Q4_E ('python3 q4.py house in Castle') - passed
Test Q4_F ('python3 q4.py apartment in randwick 0 beds 1 bath') - passed
Test Q4_G ('python3 q4.py apartment in randwick 1 bed 0 bath') - passed
Test Q4_H ('python3 q4.py house in Randwick') - passed
Test Q4_I ('python3 q4.py a in rosemeadow') - passed
Test Q4_J ('python3 q4.py A in Rosemeadow') - passed
Test Q4_K ('python3 q4.py apartment in berowra') - passed
Test Q4_L ("python3 q4.py apartment near 'randwick' 3 beds 2 baths 0 cars") - passed
Test Q4_M ("python3 q4.py apartment near 'randwick' 3 beds 2 baths 1 cars") - passed
Test Q4_N ("python3 q4.py apartment near 'randwick' 3 beds 2 baths 2 cars") - passed
Test Q4_O ("python3 q4.py house near 'randwick' 3 beds 2 baths 2 cars") - passed
Test Q4_P ('python3 q4.py apartment near burwood 2 baths 1 car') - passed
Test Q4_Q ("python3 q4.py house near 'parramatta' 5 beds 4 baths 2 cars") - passed
Test Q0_Remove_Database (Remove the database (should always succeed)) - passed
33 tests passed 0 tests failed 

$ 3311 autotest ass2 ass2.sql Q0 Q3

• you must give Q0 as well as the test you want
• Q0 is not a real test, but causes the database to be loaded
• the only interesting tests are Ensure_Exists and A..E
• the important thing is 0 tests failed
• NOTICE messages are fine; WARNING or ERROR are not