SchemaSpy sample1

dbdoc_foo.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=ora
DBNAME=foo # tnsname

DBUSER=foo
DBPASS=foofoo
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 \
     -charset $DBCHARSET \
     -t $DBTYPE \
     -db $DBNAME \
     -s $DBSCHEMA \
     -u $DBUSER \
     -p $DBPASS \
     -I $DBEXCLUDE_TABLE \
     -noimplied \
     -norows \
     -o $OUTPUT_DIR