SchemaSpy sample2

dbdoc_bar.sh

#!/bin/sh
set -eu

SCRIPT_DIR=$(cd $(dirname $0);pwd);

SCHEMASPY_JAR=$SCRIPT_DIR/schemaSpy_5.0.0.jar
JDBC_DRIVER_PATH=$ORACLE_HOME/jdbc/lib/ojdbc5.jar

DBTYPE=orathin
HOST="192.168.0.100"
PORT="1521"
DBNAME=bar # SID

DBUSER=bar
DBPASS=barbar
DBSCHEMA=`echo $DBUSER | tr '[:lower:]' '[:upper:]'`

DBCHARSET='euc-jp'
DBEXCLUDE_TABLE='.+_(\d|_)+'

OUTPUT_DIR=`basename $0 '.sh'`

java -jar $SCHEMASPY_JAR \
     -dp $JDBC_DRIVER_PATH \
     -t $DBTYPE \
     -host $HOST \
     -port $PORT \
     -db $DBNAME \
     -s $DBSCHEMA \
     -u $DBUSER \
     -p $DBPASS \
     -I $DBEXCLUDE_TABLE \
     -noimplied \
     -norows \
     -charset $DBCHARSET \
     -o $OUTPUT_DIR