#!./pgbash
source ./Test.conf
#
#---------------------------------------------------------------
#   connect.bsh
#---------------------------------------------------------------
#
#--------------- CREATE DATABASE for test --------------
#
connect to template1 user $USER $PASSWD;

set OPTION_QUIET=ON;
drop database $DB1;
drop database $DB2;
drop database $DB3;
drop database $DB4;
drop database $DB5;
set OPTION_QUIET=OFF;

create database $DB1;
create database $DB2;
create database $DB3;
create database $DB4;
create database $DB5;
disconnect template1;
#
echo "****************** CONNECT test ******************" 
echo " " 
#
# connect to (db1,db2,db3) & disconnect (db1,db2,db3)
#
echo "## connect to bash_(db1,db2,db3) ##"
connect to $DB1 as db1 user $USER NULL; 
connect to $DB2 as db2 user $USER NULL; 
connect to $DB3 as db3 user $USER NULL; 
#
exec_sql -Lm
#
disconnect db3;
exec_sql -m
disconnect db2;
exec_sql -m
disconnect db1;
exec_sql -m
#
# connect to (db1,b2,db3,db4,db5) & set connection (db2)
#
echo "## connect to (db1,db2,db3,db4,db5) ##" 
connect to $DB1 as db1 user $USER NULL; 
connect to $DB2 as db2 user $USER NULL; 
connect to $DB3 as db3 user $USER NULL; 
connect to $DB4 as db4 user $USER NULL; 
connect to $DB5 as db5 user $USER NULL; 
exec_sql -m
set connection db2;
exec_sql -m
#
# disconnect (current,all)
#
disconnect current;
exec_sql -m
disconnect all;
exec_sql -m
#
echo "****************** CONNECT error test ******************" 
echo " " 
#
set OPTION_QUIET=ON;
connect to dummy_tMUfJ9fGWb as db1 user $USER NULL;
set OPTION_QUIET=OFF;
if(( SQLCODE < 0 )); then
   echo "($SQLCODE)FATAL 1: Database \"dummy_tMUfJ9fGWb\" does not exist in the system catalog."
fi
disconnect dummy_tMUfJ9fGWb;
set connection dummy_tMUfJ9fGWb;
#
#  disconnect all
#
disconnect all;
#
#**********************************
connect to template1 user $USER NULL;
drop database $DB1;
drop database $DB2;
drop database $DB3;
drop database $DB4;
drop database $DB5;
disconnect all;
#