From 9616e3e84946c23f64448978d9459d2a25202833 Mon Sep 17 00:00:00 2001 From: Constantin Michael Date: Thu, 17 Nov 2011 11:44:45 +0200 Subject: Add examples for Oracle --- build/oracle/configure | 99 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 99 insertions(+) create mode 100755 build/oracle/configure (limited to 'build/oracle/configure') diff --git a/build/oracle/configure b/build/oracle/configure new file mode 100755 index 0000000..9746133 --- /dev/null +++ b/build/oracle/configure @@ -0,0 +1,99 @@ +#! /usr/bin/env bash + +# file : build/oracle/configure +# author : Constantin Michael +# copyright : Copyright (c) 2009-2011 Code Synthesis Tools CC +# license : ODB NCUEL; see accompanying LICENSE file + +# +# dcf_root - dynamic configuration root +# + +$echo +$echo "Please enter the Oracle client program path." +$echo + +driver=`read_path --command sqlplus` + +$echo +$echo "Please enter the Oracle database user." +$echo + +user=`read_value "odb_test"` + +$echo +$echo "Please enter the Oracle database password." +$echo + +# If the user is odb_test then default to odb_test as a password since +# it is unlikely there is the odb_test user with external authentication. +# +if [ "$user" = "odb_test" ]; then + def_passwd=odb_test +else + def_passwd= +fi + +passwd=`read_value "$def_passwd"` + +$echo +$echo "Please enter the Oracle listener host (localhost if left empty)." +$echo + +host=`read_value ""` + +$echo +$echo "Please enter the Oracle listener port (default port if left empty)." +$echo + +port=`read_value ""` + +$echo +$echo "Please enter the Oracle service to use (default service if left" +$echo "empty). Note that the database associated with user $user on this" +$echo "service WILL BE MODIFIED." +$echo + +service=`read_value ""` + +opt=$dcf_root/db.options +drv=$dcf_root/db-driver + +if [ -n "$user" ]; then +echo "--user '$user'" >$opt +fi + +if [ -n "$passwd" ]; then +echo "--password '$passwd'" >>$opt +fi + +if [ -n "$service" ]; then +echo "--service '$service'" >>$opt +fi + +if [ -n "$host" ]; then +echo "--host '$host'" >>$opt +fi + +if [ -n "$port" ]; then +echo "--port '$port'" >>$opt +fi + +echo "#!/bin/sh" >$drv + +dir=`dirname $driver` +if [ "$dir" != "." ]; then + echo >>$drv + echo 'LD_LIBRARY_PATH="'$dir':$LD_LIBRARY_PATH"' >>$drv + echo "export LD_LIBRARY_PATH" >>$drv + echo >>$drv + echo 'if [ -z "$SQLPATH" ]; then' >>$drv + echo ' SQLPATH="'$dir'"' >>$drv + echo " export SQLPATH" >>$drv + echo "fi" >>$drv + echo >>$drv +fi + +echo "opt=\`cat $opt\`" >>$drv +echo "eval $scf_root/oracle/oracle --driver $driver \$opt \$*" >>$drv +chmod 755 $drv -- cgit v1.1