Schnittstelle CampusOnline (TU Graz) zu SuperX-Modul COSTAGE
http://www.superx-projekt.de/doku/costage_modul/
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
132 lines
2.8 KiB
132 lines
2.8 KiB
#!/bin/bash |
|
#Extraction Script for SuperX. |
|
#Bitte nicht ändern, diese Datei ist automatisch generiert. |
|
|
|
SRC_PFAD=$SOS_LOAD_PFAD |
|
if [ "$SRC_PFAD" = "" ] |
|
then |
|
SRC_PFAD=. |
|
fi |
|
|
|
. ./$SRC_PFAD/SOS_ENV |
|
|
|
|
|
if [ "$outFormat" = "" ] |
|
then |
|
outFormat=txt |
|
fi |
|
|
|
DATUM=`cat $SRC_PFAD/superx.datum` |
|
ERR=sos_v1_unload.err |
|
|
|
HEUTE=`date +'%d.%m.%Y'` |
|
|
|
echo "Letztes Update-Datum: " $DATUM >$ERR |
|
echo "DATABASE: $DATABASE" >>$ERR |
|
echo "VERSION: $VERSION" >>$ERR |
|
echo "SX_CLIENT: $SX_CLIENT" >>$ERR |
|
echo "1.2b^"$HEUTE"^" >$SRC_PFAD/unl/superx_unload_version.unl |
|
|
|
cd $SRC_PFAD >>$ERR 2>&1 |
|
|
|
CP=".:$JDBC_CLASSPATH:$XML_CLASSPATH" |
|
|
|
|
|
cat /dev/null >unload_params.txt |
|
|
|
|
|
if [ "$SOS_UNL_COMPLETE" = "" ] |
|
then |
|
SOS_UNL_COMPLETE="true" |
|
export SOS_UNL_COMPLETE |
|
fi |
|
echo "Parameter SOS_UNL_COMPLETE: $SOS_UNL_COMPLETE" >>$ERR |
|
echo "\$SOS_UNL_COMPLETE=$SOS_UNL_COMPLETE" >>unload_params.txt |
|
|
|
|
|
if [ "$VERSION" = "" ] |
|
then |
|
VERSION="13" |
|
export VERSION |
|
fi |
|
echo "Parameter VERSION: $VERSION" >>$ERR |
|
echo "\$VERSION=$VERSION" >>unload_params.txt |
|
|
|
|
|
if [ "$start_stud_sem" = "" ] |
|
then |
|
start_stud_sem="19911" |
|
export start_stud_sem |
|
fi |
|
echo "Parameter start_stud_sem: $start_stud_sem" >>$ERR |
|
echo "\$start_stud_sem=$start_stud_sem" >>unload_params.txt |
|
|
|
|
|
if [ "$start_pruef_sem" = "" ] |
|
then |
|
start_pruef_sem="19911" |
|
export start_pruef_sem |
|
fi |
|
echo "Parameter start_pruef_sem: $start_pruef_sem" >>$ERR |
|
echo "\$start_pruef_sem=$start_pruef_sem" >>unload_params.txt |
|
|
|
|
|
if [ "$SOS_UNL_ANON" = "" ] |
|
then |
|
SOS_UNL_ANON="false" |
|
export SOS_UNL_ANON |
|
fi |
|
echo "Parameter SOS_UNL_ANON: $SOS_UNL_ANON" >>$ERR |
|
echo "\$SOS_UNL_ANON=$SOS_UNL_ANON" >>unload_params.txt |
|
|
|
|
|
if [ "$POS_PNR" = "" ] |
|
then |
|
POS_PNR="0" |
|
export POS_PNR |
|
fi |
|
echo "Parameter POS_PNR: $POS_PNR" >>$ERR |
|
echo "\$POS_PNR=$POS_PNR" >>unload_params.txt |
|
|
|
|
|
if [ "$LAB_FILTER" = "" ] |
|
then |
|
LAB_FILTER=" AND (lab.panerk is null or lab.panerk != 'J') " |
|
export LAB_FILTER |
|
fi |
|
echo "Parameter LAB_FILTER: $LAB_FILTER" >>$ERR |
|
echo "\$LAB_FILTER=$LAB_FILTER" >>unload_params.txt |
|
|
|
|
|
if [ "$STUDENT_FILTER" = "" ] |
|
then |
|
STUDENT_FILTER=" AND 1=1 " |
|
export STUDENT_FILTER |
|
fi |
|
echo "Parameter STUDENT_FILTER: $STUDENT_FILTER" >>$ERR |
|
echo "\$STUDENT_FILTER=$STUDENT_FILTER" >>unload_params.txt |
|
|
|
|
|
if [ "$STUDENT_SOSPOS_FILTER" = "" ] |
|
then |
|
STUDENT_SOSPOS_FILTER=" AND 1=1 " |
|
export STUDENT_SOSPOS_FILTER |
|
fi |
|
echo "Parameter STUDENT_SOSPOS_FILTER: $STUDENT_SOSPOS_FILTER" >>$ERR |
|
echo "\$STUDENT_SOSPOS_FILTER=$STUDENT_SOSPOS_FILTER" >>unload_params.txt |
|
|
|
|
|
echo "Parameter SOURCESYSTEM: $SOURCESYSTEM" >>$ERR |
|
echo "\$SOURCESYSTEM=$SOURCESYSTEM" >>unload_params.txt |
|
|
|
#jdbc zum Entladen |
|
if [ "$SX_CLIENT" = "jdbc" ] |
|
then |
|
java $JAVA_OPTS -cp $CP de.superx.bin.SxExtractor -logger:$LOGGER_PROPERTIES -dbproperties:$DB_PROPERTIES -xml:sos_v1_unload.xml -outFormat:$outFormat -delim:$DBDELIMITER -header:$header -database:$DATABASE -version:$VERSION -unload_params:unload_params.txt >>$ERR 2>&1 |
|
|
|
echo "Unload v1 beendet" |
|
exit 0 |
|
|
|
fi |
|
|
|
|
|
|