Shell Programming and Scripting

DATABASES="DB1 DB2 DB3"            # Remember to quote these to allow for the spaces 
for DB in ${DATABASES}
do
  echo "Doing for database $DB"
  flag=invalid
  while [ "$flag" = "invalid" ]
  do
     read yn?"Do You Wish To Take Database Backup for $DB?? " 
     case "$yn" in
        [Yy]*) echo " YES take backup "
               flag=valid                              ;;
        [Nn]*) flag=valid                              ;;
            *) echo "Please Answer Yes OR NO "         ;;
     esac
  done
done

 

for DB in ${DATABASES}
do
i=0
while [ $i == 0 ]
do
 doing some thing ... 
        
read yn?"Do You Wish To Take Database Backup for $DB?? " 
 case "$yn" in
 [Yy]*) echo " YES"  
               i=1        ;;
        [Nn]*) echo "NO"
               i=1          ;;
esac
done
done

 
./Config.sh
Do You Wish To Take Database Backup for DB1?? y
YES 
 ****    Connected to DB1      ***
Do You Wish To Take Database Backup for DB2 ?? n
NO
 ****    Connected to DB2    ***

#!/bin/ksh
# My code does backups
#

Get_backup_type ()
{
 j=0
 while [ $j == 0 ]
 do
    read type?"What level of backup? (Offline/Full/Delta): "
    j=1
    case "$type" in   # Only first 3 characters are significant
       [Oo][Ff][Ff]*) echo "Performing Offline backup"      ;;
       [Oo][Nn][Ll]*) echo "Performing Full online backup"  ;;
       [Dd][Ee][Ll]*) echo "Performing Delta backup."       ;;
       *)             echo "Invalid backup type." ; j=0     ;;
    esac
 done
}

#########################
# Main code starts here #
#########################
export type                      # Make this a global variable

for DB in A B C
do
   i=0
   while [ $i == 0 ]
   do
      read yn?"Do You Wish To Take Database Backup for $DB? "
      i=1
      case "$yn" in
         [Yy]*) echo " YES"
         Get_backup_type
         echo "Running $type backup for $DB"   ;;
         [Nn]*) echo "NO"                      ;;
         *)     echo "Invalid choice" ; i=0    ;;
      esac
   done
done

Do You Wish To Take Database Backup for A? n
NO
Do You Wish To Take Database Backup for B? y
 YES
What level of backup? (Offline/Full/Delta): off
Performing Offline backup
Running off backup for B
Do You Wish To Take Database Backup for C? y
 YES
What level of backup? (Offline/Full/Delta): del
Performing Delta backup.
Running del backup for C