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



rem Create tables

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

set echo on

start CSU-setup.sql

set echo off

rem Populate tables

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

set termout off

start CSU-insert.sql

set termout on

spool lab5-CSU-output.txt


rem RUN LAB 5 assignment

host echo '***********************************************'
host echo ' Running Queries  '
host echo '***********************************************'


set echo on

start CSU-queries.sql

set echo off

rem drop tables

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


set echo on
start CSU-cleanup.sql


set echo off

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

spool off
