#!./pgbash
source ./Test.conf
#---------------------------------------------------------------
#   cgi.bsh
#---------------------------------------------------------------
exec  2>&1
echo "Content-type: text/html"
echo ""
set EXEC_SQL_OPTION CGI ;
#
connect to template1 user $USER $PASSWD;

set option_quiet=ON;
drop database $DB1;
drop database $DB2;
set option_quiet=OFF;

create database $DB1;
create database $DB2;
disconnect template1;
#
echo "****************** SQL test ******************" 
echo "" 
#
connect to $DB1 as db1 user $USER $PASSWD;
connect to $DB2 as db2 user $USER $PASSWD;
exec_sql -m
echo  ""
#
#   db1 Database
#
set connection db1;
exec_sql -q "drop table $TABLE1"
create table $TABLE1( 
   code		int, 		# User Code
   name		varchar(32), 	# User Name
   address	varchar(64) 	# User's Address
);
#
insert into $TABLE1 values(1, 'sakaida',  'osaka'); 
insert into $TABLE1 values(2, 'postgres', 'america'); 
insert into $TABLE1 values(11,'mywife', 'kobe'); 
echo " "
select * from $TABLE1;
#
declares -i i; let i=0
while(( i< SQLNFIELD ))
do
        echo "FILENAME=${SQLFIELDNAME[i]}<BR>"
	let i=i+1
done
#
set OPTION_EXPANDED=ON;
select * from $TABLE1;
set OPTION_EXPANDED=OFF;

set OPTION_TABLETAG='<TABLE CELLPADDING=8 BGCOLOR=00ff00 BORDER=1>';
set OPTION_HEADERTR='<TR BGCOLOR=#DDDDDD>';
set OPTION_HEADERTH='<TH nowrap>,<TH nowrap>,<TH nowrap>';
set OPTION_BODYTAG='<TD nowrap>,<TD width=200>,<TD width=400>';
set OPTION_BOTTOM=OFF;
select * from $TABLE1;
set OPTION_BOTTOM=ON;
set OPTION_BODYTAG='';
set OPTION_HEADERTH='';
set OPTION_HEADERTR='';
set OPTION_TABLETAG='';

set OPTION_CAPTION='test case';
set OPTION_TABLETAG='BORDER=0';
set OPTION_HEADERTH='<TH nowrap>';
set OPTION_BODYTAG='<TD nowrap>,<TD width=200>';
select * from $TABLE1;
set OPTION_CAPTION='';
set OPTION_HEADERTH='';
set OPTION_BODYTAG='';
set OPTION_TABLETAG='';

set OPTION_BODYTAG='<TD nowrap>,<TD width=200>';
set OPTION_INPUTTAG;
select * from $TABLE1;
set OPTION_BODYTAG='';
set OPTION_INPUTTAG=OFF;

set OPTION_BODYTAG='<TD nowrap>,<TD width=200>';
set OPTION_INPUTTAG=ON;
set OPTION_INPUTSIZE='-1,0,13';
select * from $TABLE1;
set OPTION_BODYTAG='';
set OPTION_INPUTTAG=OFF;
set OPTION_INPUTSIZE='';

set OPTION_INPUTTAG;
set OPTION_INPUTSIZE='-1,0,13';
select * from $TABLE1;
set OPTION_INPUTTAG=OFF;
set OPTION_INPUTSIZE='';

set OPTION_EXPANDED;
set OPTION_INPUTTAG;
set OPTION_INPUTSIZE='-1,0,13';
select * from $TABLE1;
set OPTION_INPUTTAG=OFF;
set OPTION_INPUTSIZE='';
set OPTION_EXPANDED=OFF;


echo ""
#
echo "<table><tr><td><pre>"
set OPTION_HTML=OFF;

set OPTION_HEADER=OFF;
set OPTION_BOTTOM=OFF;
set OPTION_SEPARATOR=',';
select * from $TABLE1;
set OPTION_HEADER=ON;
set OPTION_BOTTOM=ON;
set OPTION_SEPARATOR='';

echo ""
select * from $TABLE1;

echo ""
set OPTION_FRAME=ON;
set OPTION_CAPTION='TITLE';
select * from $TABLE1;
set OPTION_FRAME=OFF;
set OPTION_CAPTION='';
echo ""

set OPTION_HTML=ON;
echo "</pre></td></tr></table>"
#
#   db2 Database
#
set connection db2; 
exec_sql -q "drop table $TABLE2"
create table $TABLE2( 
   code		int, 
   name		varchar(32), 
   address	varchar(64) 
);
#
insert into $TABLE2 values(1001, 'sakaida',  'osaka'); 
insert into $TABLE2 values(1002, 'postgres', 'america'); 
insert into $TABLE2 values(1111, 'mywife', 'kobe'); 
echo " "
#
select * from $TABLE2;
exec_sql -d db1  "select * from $TABLE1"
#
disconnect all;
#
#*****************************************
connect to template1 user $USER $PASSWD;
drop database $DB1;
drop database $DB2;
disconnect all;
#