#!/bin/ksh 
#
# Scriptname  : ~/scripts/add_user.ksh
#
# Description : Adds ingres user.
#
# Parameters  : $1=Username. $2=remove
#
# Author      : M S Ramsay 26 June 1997
#
# History       Date      Name      Reason
#               ----      ----      ------
#               
#
#Set-up variables.
#

SDS_scriptname="`basename $0`"

if [[ $1 = h ]] || [[ $1 = '' ]]
then echo ""                                                                    
     echo "Parameters:- "                                                       
     echo ""                                                                    
     echo "\$1 - User id.    e.g.  ./add_user.ksh fred"
     echo "\$2 - remove.     e.g.  ./add_user.ksh fred remove"
     echo "\$2 - check.      e.g.  ./add_user.ksh fred check"
     echo "h  - Help        e.g.  ./add_user.ksh h"
     echo ""                                                                    
     exit                                                                       
fi 

F11=[28~
F12=[29~
F3=[19~
PATH=/usr/bin:/bin:$II_SYSTEM/ingres/bin:$II_SYSTEM/ingres/utility
export PATH II_SYSTEM

#
#Check parameters are set.
#

ingres_user=${1:?"No user specified"}

remove=${2:-false}

if [[ $remove = remove || $remove = false || $remove = check ]]
then :
else echo "Error in script $SDS_scriptname - Parameter invalid"                 
     echo ""                                                                    
     echo "Try:-"                                                               
     echo ""                                                                    
     echo "h - Help    e.g. ./add_user.ksh h"
     echo ""                                                                    
     exit
fi

if [ ! -d "$II_SYSTEM/ingres" ]
then
        error "II_SYSTEM ($II_SYSTEM) not configured correctly"
        exit 
fi

#
#check ingres is running.
#

	sql iidbdb <<EOT > /dev/null 2>&1
select * from iidatabase;\g
EOT

#
#Check return code.
#

if [[ $? -ne  0 ]]
then  echo "Ingres not running.  Please try later."
      exit
fi

#
# Check to see if User is already an Ingres user.
#


cnt=`sql iidbdb <<EOT | awk '/col1/ { getline ; getline; print $2 }' \
| sed 's/\|//' 
select count (name) 
from iiuser where name='$ingres_user';\g
EOT`

if [ $cnt -eq 1 ]
then echo "$ingres_user is a valid Ingres user."
     if [[ $remove = "false" || $remove = "check" ]]
	  then exit
	  else echo "Remove user specified.  User $ingres_user being removed!"
	       ( echo $F11'\c' ; echo $ingres_user ; echo $F12'\c' ; echo delete \
	       ; echo y ; echo $F3'\c' ) \
               | accessdb > /tmp/msrfile 2>&1
	       exit
     fi
     
fi

#
# Create user through accessdb.
#

if [[ $remove = "false" ]]
then echo "User $ingres_user being added" 
     ( echo $F11'\c' ; echo $ingres_user \
     ; echo y ; echo '\t\c' \
     ; echo n'\c' ; echo '\t\c' ; echo y'\c' ; echo $F12'\c' \
     ; echo save ; echo $F3'\c' ) \
     | accessdb > /tmp/msrfile 2>&1
     exit
else if [[ $remove = remove ]] 
	then echo "Remove user specified but user does not exist.  Exiting...."
             exit
        else echo "$ingres_user is not known to Ingres"
	     exit
     fi
fi