#
### ora_ref.sh
###
### Usage: ora_ref.sh host port SID
###
### For www.setgetweb.com databases:
###
### ora_ref.sh lvdb001 80 stage
### ora_ref.sh lvdb001 80 trade
### ora_ref.sh lvdb001 80 demo
###
###
### For QA databases:
###
### ora_ref.sh bea 7778 test
### ora_ref.sh bea 7778 test2
###
###
###
### Generate hyperlinked reference to a
### Oracle data for a SID using Oracle-Apache
### and the tprint stored procedure
###
### This script should be run on the Huxley box
###
if [ $# -lt 3 ]; then
echo " "
echo "Usage: ora_ref.sh host port SID "
echo " "
echo " For www.setgetweb.com databases: "
echo " "
echo " ora_ref.sh lvdb001 80 trade "
echo " ora_ref.sh lvdb001 80 demo "
echo " ora_ref.sh lvdb001 80 stage "
echo " "
echo " "
echo " For QA databases: "
echo " "
echo " ora_ref.sh jupiter 7778 test "
echo " ora_ref.sh jupiter 7778 test2 "
echo " "
exit 1
else
HOST=$1
PORT=$2
SID=$3
fi
###
### Lights for navigating the labyrinth.
###
date
olddir=`pwd`
P4CLIENT=www.setgetweb.com.depot
export P4CLIENT
home=/usr/tomcat/webapps/ROOT/depot/oracle
sql="/usr/tomcat/webapps/ROOT/depot/dev/cbo-aim/primary/install/oracle/sql"
tbl="/usr/tomcat/webapps/ROOT/depot/dev/cbo-aim/primary/install/oracle/tbl"
xsql="dev/cbo-aim/primary/install/oracle/sql"
xtbl="dev/cbo-aim/primary/install/oracle/tbl"
echo "Removing old files..."
rm -f $sql/*.sql
rm -f $tbl/*.tbl
rm -f $sql/*.sql.html
rm -f $tbl/*.tbl.html
echo "Syncing Perforce using P4CLIENT=$P4CLIENT..."
rm -f $sql/*.sql
p4 sync -f
echo "Making files world writable..."
find /usr/tomcat/webapps/ROOT/depot/oracle -type f -exec chmod 666 {} \;
echo "Convert sql files to html..."
cd $sql
for i in `ls *.sql`
do
convertb.sh $i
done
echo "Convert tbl files to html..."
cd $tbl
for i in `ls *.tbl`
do
convertb.sh $i
done
echo "Generating index..."
echo "<html> " > $home/$SID.html
echo "<head> " >> $home/$SID.html
echo " <META content=text/css http-equiv=Content-Style-Type> " >> $home/$SID.html
echo " <LINK href=\"http://www.setgetweb.com/white.css\" rel=\"stylesheet\" type=\"text/css\"> " >> $home/$SID.html
echo " <title> $SID database on $HOST</title> " >> $home/$SID.html
echo "</head> " >> $home/$SID.html
echo "<body> " >> $home/$SID.html
echo " " >> $home/$SID.html
echo "<font class=grey2> " >> $home/$SID.html
echo " " >> $home/$SID.html
echo "<blockquote> " >> $home/$SID.html
echo "<blockquote> " >> $home/$SID.html
echo " " >> $home/$SID.html
echo "<p> </p> " >> $home/$SID.html
echo "<h1> $SID database on $HOST </h1> " >> $home/$SID.html
echo " " >> $home/$SID.html
echo " " >> $home/$SID.html
echo "<p> </p><blockquote><table cellpadding=5 border=1> " >> $home/$SID.html
echo "<tr>" >> $home/$SID.html
echo "<th align=left valign=bottom>Query <sup><font size=-2><a href=\"#1\">1</a></font></sup>" >> $home/$SID.html
echo "<th align=left valign=bottom>Table" >> $home/$SID.html
echo "<th align=left valign=bottom>Doc</th> " >> $home/$SID.html
echo "<th align=left valign=bottom>Insert" >> $home/$SID.html
echo "</tr>" >> $home/$SID.html
a="xyz"
for i in `ls *.tbl.html`
do
x=`basename $i .html`
y=`basename $x .tbl`
z=`echo $y | tr [a-z] [A-Z]`
echo $z
echo "<tr>" >> $home/$SID.html
###
### VPN | SSH
###
echo "<a name="$z"></a><td valign=top nowrap><a href=\"http://$HOST:$PORT/pls/$SID/tprint?xtable=skyway.$z&i_page_num=1\">VPN</a> | <a href=\"http://localhost:$PORT/pls/$SID/tprint?xtable=skyway.$z&i_page_num=1\">SSH</a> </td> " | sed "s/=RPT_/=RPT.RPT_/g" >> $home/$SID.html
###
### Table Name/DDL
###
echo "<td valign=top><a href=\"http://www.setgetweb.com/depot/$xtbl/$i\">$z</a></td> " >> $home/$SID.html
###
### Oracledoc
###
echo "<td valign=top align=center><a href=\"http://oracledoc/ViewTable.jsp?owner=NOTIVA&table=$z\">XXX</a></td> " >> $home/$SID.html
###
### Sample insert
###
if [ -f $sql/${y}.sql.html ]
then
echo "<td valign=top><a href=\"http://www.setgetweb.com/depot/$xsql/${y}.sql.html\">XXX</a></td> " >> $home/$SID.html
else
echo "<td valign=top><br></td> " >> $home/$SID.html
fi
echo "</tr>" >> $home/$SID.html
done
echo "<p></blockquote></table> " >> $home/$SID.html
echo "</center> " >> $home/$SID.html
echo "<a name=\"1\"></a><p> </p>VPN refers to a <a href=\"../../prod/index.html#vpn\">VPN client </a> connection to www.setgetweb.com. SSH refers to an <a href=\"../../prod/setgetweb_tunnel.html\">SSH Tunnel</a>. Both attach to an <a href="http://www.setgetweb.com/oracle/index.html#apache">Oracle-Apache</a> web server running on the <a href=\"../../prod/index.html#ip\">database box</a> at www.setgetweb.com. " >> $home/$SID.html
echo "<p>To refresh this repository, run <a href=\"ora_ref.sh.html\">ora_ref.sh</a>. " >> $home/$SID.html
echo " <p><hr> " >> $home/$SID.html
echo " " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo "<a href=\"../../index.html\"><img border=0 src=\"../../home.gif\" align=left alt=\"Home\"></a>" >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " " >> $home/$SID.html
echo " </blockquote> " >> $home/$SID.html
echo " </blockquote> " >> $home/$SID.html
echo " " >> $home/$SID.html
echo " <center> " >> $home/$SID.html
echo " <br> Copyright 2002. All Rights Reserved. " >> $home/$SID.html
echo " <script javascript=\"JavaScript\"> " >> $home/$SID.html
echo " document.write(\"<br>Last updated: \"+document.lastModified); " >> $home/$SID.html
echo " </script> " >> $home/$SID.html
echo " " >> $home/$SID.html
echo " " >> $home/$SID.html
echo " </center> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " <p> </p> " >> $home/$SID.html
echo " " >> $home/$SID.html
echo " </body> " >> $home/$SID.html
echo " </html> " >> $home/$SID.html
###
### Generate links to tables
###
echo "Generating links..."
#cd /usr/tomcat/webapps/ROOT/depot/oracle
#sh ./linklist.sh
date