/*=====
  testing script for procedure which_titles

  by: Sharon Tuttle
  last modified: 2016-01-29
=====*/

prompt
prompt *********************************
prompt TESTING which_titles
prompt *********************************
prompt

spool which_titles_test_out.txt
set serveroutput on

prompt testing JUST for titles with >= 15 copies on hand AND
prompt whose price is >= $20 
prompt (   test passes if 5 titles, quantities, and prices are shown;)
prompt (   see Homework 2 handout for exact expected values):
prompt ==========================================================

exec which_titles(15, 20)

prompt testing JUST for titles with >= 10 copies on hand AND
prompt whose price is >= $40 
prompt (   test passes if 3 titles, quantities, and prices are shown):
prompt ==========================================================

exec which_titles(10, 40)

prompt
prompt testing JUST for titles with >= 15 copies on hand AND
prompt whose price is >= $100 
prompt (   as you can see in the previous results, there should)
prompt (   be NO such titles found):
prompt ==========================================================

exec which_titles(15, 100)

prompt
prompt testing JUST for titles with >= 100 copies on hand AND
prompt whose price is >= $20 
prompt (   again, as you can see in the first test results, there)
prompt (   should be NO such titles found):
prompt ==========================================================

exec which_titles(100, 20)

prompt
prompt testing JUST for titles with >= 100 copies on hand AND
prompt whose price is >= $100 
prompt (   again, as you can see in the first test results, there)
prompt (   should be NO such titles found):
prompt ==========================================================

exec which_titles(100, 100)

spool off
 
-- end of which_titles_test.sql