Shell Programming and Scripting

## SQL1
select * from dual;

## SQL2
select user from dual10;

SQL1:PASS
SQL2:FAIL

for Code in $(cat SQL.dat | egrep "^##")
do
    SQLID=`echo "$Code" | tr -d "##"`
    SQL=`cat SQL.dat | sed -n "/$Code/,/;/p"`
    RunSQL $SQL
done

#!/bin/bash

while read -r sql; do
  if [[ $sql = \#* ]]; then
    stmt=${sql#* }
  elif [[ $sql = *[![:space:]]* ]]; then  # has something besides blank
    if RunSQL "$sql"; then
      echo "$stmt:PASS"
    else
      echo "$stmt:FAIL"
    fi
  fi
done < "SQL.dat"

while read -r TMP
  do if [[ $TMP = \#* ]]
       then     stmt=${TMP#* }
       elif [[ $TMP = *[![:space:]]* ]]
         then sql="$sql $TMP"
         else
           if RunSQL "$sql"
             then       echo "$stmt:PASS"
             else       echo "$stmt:FAIL"
           fi
         sql="";
       fi
  done < file