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

spool lab2-CSU-output.txt


rem Create tables

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

host cat CSU-setup.sql

start CSU-setup.sql

rem Populate tables

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

start CSU-build-Campuses.sql
start CSU-build-csu-fees.sql
start CSU-build-degrees.sql
start CSU-build-disciplines.sql
start CSU-build-discipline-enrollments.sql
start CSU-build-enrollments.sql
start CSU-build-faculty.sql

rem test tables

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


host cat CSU-test.sql
start CSU-test.sql


rem  modify tables

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

host cat CSU-modify.sql
start CSU-modify.sql


rem drop tables

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

host cat CSU-cleanup.sql
start CSU-cleanup.sql

rem test that the tables no longer exist

start CSU-test.sql


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

spool off
