#! /bin/sh
##
## Usage:
##     run-oracle $1 $2 $3 $4
##
## $1 = Oracle connect string USERID/PASSWORD or USERID/PASSWORD@TNSNAME
## $2 = path to directory containing input files
## $3 = version of source database 
## $4 = release date of the source database
## $5 = commandline option (eg. -d)

ENZYME=$2/ligand/enzyme
COMPOUND=$2/ligand/compound
REACTION=$2/ligand/reaction
GENES=$2/genes
GENOME=$2/genome
export ENZYME COMPOUND GENES GENOME

./oracle-kegg-loader -u $1 -v $3 -r $4 -o $GENOME -g $GENES -c $COMPOUND -x $REACTION -e $ENZYME $5