rem
rem CSC 365. Lab 2. Test script for STUDENTS dataset
rem 
rem Alex Dekhtyar (dekhtyar@csc.calpoly.edu)
rem

spool lab2-STUDENTS-output.txt


rem Create tables

host echo '***********************************************'
host echo ' Creating tables  '
host echo '***********************************************'

set echo on

start STUDENTS-setup.sql

set echo off

rem Populate tables

host echo '***********************************************'
host echo ' Populating tables  '
host echo '***********************************************'

set termout off

start STUDENTS-build-teachers.sql
start STUDENTS-build-list.sql

set termout on

rem test tables

host echo '***********************************************'
host echo ' Testing tables  '
host echo '***********************************************'


set echo on
start STUDENTS-test.sql
set echo off
rem formatted output

host echo '***********************************************'
host echo ' Testing SQL*plus formatting  '
host echo '***********************************************'

clear columns
clear breaks
 
set echo on

start STUDENTS-formatted.sql

set echo off

clear columns
clear breaks


rem  modify tables

host echo '***********************************************'
host echo ' Modifying tables  '
host echo '***********************************************'

set echo on

start STUDENTS-modify.sql

set echo off

rem drop tables

host echo '***********************************************'
host echo ' Dropping tables  '
host echo '***********************************************'


set echo on
start STUDENTS-cleanup.sql

rem test that the tables no longer exist

start STUDENTS-test.sql

set echo off

host echo '***********************************************'
host echo ' That is All, folks!  '
host echo '***********************************************'

spool off