[Assignment Spec]  [SQL Schema]  [SQL Data]  [Examples]  [Testing]  [Fixes+Updates]

Introduction

This document contains details of how you can/we will test your scripts.

A Note on Disk Quota

autotest will create new database for testing.

In order to do this you must have enough disk quota to create a new database.

You will likely need to delete some of your old databases to free up space.

Eg, your ass1 database, and any databases from Prac activities.

You should have enough space to create have a separate ass2 database for manual testing.

Testing Your Work

A set of automated tests (based off of the examples provided) are available for you to run.

To run the automated tests

... login to vxdb2, source env, run your server as usual ...
vxdb2$ source /localstorage/$USER/env
vxdb2$ p1
... cd into the directory containing your ass2 python scripts ...
vxdb2$ cd /my/dir/for/ass2
... Run the autotests ...
vxdb2$ 3311 autotest ass2

Your helpers.sql file must load into a clean database without errors for autotest to run

Once you have completed all the questions, you should seem something like the following output

vxdb2$ 3311 autotest ass2
... LOTS OF SETUP OUTPUT ...

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 'Pikachu'") - passed
Test Q2_B ("python3 q2.py 'Oricorio - Baile Style'") - passed
Test Q2_C ("python3 q2.py 'Ralts'") - passed
Test Q2_D ("python3 q2.py 'Flamigo'") - passed
Test Q2_E ("python3 q2.py 'Magikarp'") - passed
Test Q2_F ("python3 q2.py 'Phantump'") - passed
Test Q2_G ("python3 q2.py 'Minior - Meteor Form'") - passed
Test Q2_H ("python3 q2.py 'Nickit'") - passed
Test Q2_I ("python3 q2.py 'Mantine'") - passed
Test Q2_J ("python3 q2.py 'Wurmple'") - passed
Test Q2_K ("python3 q2.py 'Plusle'") - passed
Test Q2_L ("python3 q2.py 'Minun'") - passed
Test Q2_M ("python3 q2.py 'Chimecho'") - passed
Test Q2_N ("python3 q2.py 'Lopunny'") - passed
Test Q2_O ("python3 q2.py 'Zorua'") - passed
Test Q4_A ('python3 q4.py Blue Pikachu Pikachu') - passed
Test Q4_B ('python3 q4.py Violet Pikachu Flabébé') - passed
Test Q4_C ('python3 q4.py X Simisage Swalot') - passed
Test Q4_D ('python3 q4.py White Cinccino Woobat') - passed
Test Q4_E ('python3 q4.py Sword Copperajah Trevenant') - passed
Test Q4_F ("python3 q4.py 'Alpha Sapphire' Salamence Wailord") - passed
Test Q5_A ("python3 q5.py 'Dreepy'") - passed
Test Q5_B ("python3 q5.py 'Pichu'") - passed
Test Q5_C ("python3 q5.py 'Chimchar'") - passed
Test Q5_D ("python3 q5.py 'Monferno'") - passed
Test Q5_E ("python3 q5.py 'Infernape'") - passed
Test Q5_F ("python3 q5.py 'Quilava'") - passed
Test Q5_G ("python3 q5.py 'Tyrogue'") - passed
Test Q5_H ("python3 q5.py 'Eevee'") - passed
Test Q5_I ("python3 q5.py 'Nincada'") - passed
Test Q5_J ("python3 q5.py 'Ursaluna'") - passed
Test Q5_K ("python3 q5.py 'Porygon2'") - passed
Test Q5_L ("python3 q5.py 'Basculin - White-Striped Form'") - passed
Test Q5_M ("python3 q5.py 'Vulpix'") - passed
Test Q5_N ("python3 q5.py 'Alolan Vulpix'") - passed
Test Q5_O ("python3 q5.py 'Vileplume'") - passed
Test Q5_P ("python3 q5.py 'Gloom'") - passed
Test Q5_Q ("python3 q5.py 'Galarian Mr. Mime'") - passed
Test Q5_R ("python3 q5.py 'Salamence'") - passed
Test Q5_S ("python3 q5.py 'Emolga'") - passed
Test Q5_T ("python3 q5.py 'Rockruff'") - passed
Test Q5_U ("python3 q5.py 'Goomy'") - passed
Test Q5_V ("python3 q5.py 'Meowstic - Female'") - passed
Test Q0_Remove_Database (Remove the database (should always succeed)) - passed
46 tests passed 0 tests failed

If there is an error in your helpers.sql file it will be shown at the top of the autotest output, and none of the tests will be able to run.

You can run tests for a specific question by adding the question number to the end of the autotest command

vxdb2$ 3311 autotest ass2 Q0 Q5
... LOTS OF SETUP OUTPUT ...

Test Q0_Create_Database (Load the database with the dump file (should always succeed)) - passed
Test Q5_A ("python3 q5.py 'Dreepy'") - passed
Test Q5_B ("python3 q5.py 'Pichu'") - passed
Test Q5_C ("python3 q5.py 'Chimchar'") - passed
Test Q5_D ("python3 q5.py 'Monferno'") - passed
Test Q5_E ("python3 q5.py 'Infernape'") - passed
Test Q5_F ("python3 q5.py 'Quilava'") - passed
Test Q5_G ("python3 q5.py 'Tyrogue'") - passed
Test Q5_H ("python3 q5.py 'Eevee'") - passed
Test Q5_I ("python3 q5.py 'Nincada'") - passed
Test Q5_J ("python3 q5.py 'Ursaluna'") - passed
Test Q5_K ("python3 q5.py 'Porygon2'") - passed
Test Q5_L ("python3 q5.py 'Basculin - White-Striped Form'") - passed
Test Q5_M ("python3 q5.py 'Vulpix'") - passed
Test Q5_N ("python3 q5.py 'Alolan Vulpix'") - passed
Test Q5_O ("python3 q5.py 'Vileplume'") - passed
Test Q5_P ("python3 q5.py 'Gloom'") - passed
Test Q5_Q ("python3 q5.py 'Galarian Mr. Mime'") - passed
Test Q5_R ("python3 q5.py 'Salamence'") - passed
Test Q5_S ("python3 q5.py 'Emolga'") - passed
Test Q5_T ("python3 q5.py 'Rockruff'") - passed
Test Q5_U ("python3 q5.py 'Goomy'") - passed
Test Q5_V ("python3 q5.py 'Meowstic - Female'") - passed
Test Q0_Remove_Database (Remove the database (should always succeed)) - passed
24 tests passed 0 tests failed

Q0 must always be given to allow the autotest to create a new database for testing.