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

spool lab3-BAKERY-output.txt


rem Create tables

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

set echo on

start BAKERY-setup.sql

set echo off

rem Populate tables

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

set termout off

start BAKERY-build-customers.sql
start BAKERY-build-goods.sql
start BAKERY-build-receipts.sql
start BAKERY-build-items.sql

set termout on

rem test tables

host echo '***********************************************'
host echo ' RUNNING Lab 3 Assignment  '
host echo '***********************************************'


set echo on

start BAKERY-lab3.sql

set echo off


rem drop tables

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

set echo on

start BAKERY-cleanup.sql

set echo off
rem test that the tables no longer exist

start BAKERY-test.sql


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

spool off