# echo -n "Password:" # read -s PWD # echo echo `date` ENV=DOCKER CQLSH="${CQLSH:=/opt/cassandra/bin/cqlsh} -k authz" cd dats if [ "$*" = "" ]; then DATA="" for Tdat in `ls *.dat`; do if [ -s "${Tdat}" ]; then DATA="$DATA ${Tdat%.dat}" fi done else DATA="$*" fi cd - echo "You are about to REPLACE the data in the $ENV DB for the following tables:" echo "$DATA" echo -n 'If you are VERY sure, type "YES": ' read YES if [ ! "$YES" = "YES" ]; then echo 'Exiting ...' exit fi UPLOAD="" for T in $DATA; do if [ -s "dats/${T}.dat" ]; then echo $T case "$T" in # 2.1.14 still has NULL problems for COPY. Fixed in 2.1.15+ "approval"|"artifact"|"cred"|"ns"|"x509"|"role"|"notified") $CQLSH -e "truncate $T" UPLOAD="$UPLOAD "$T ;; "history") $CQLSH -e "truncate $T" DO_HISTORY=true ;; *) $CQLSH -e "truncate $T; COPY authz.${T} FROM 'dats/${T}.dat' WITH DELIMITER='|'" ;; esac fi done if [ ! "$UPLOAD" = "" ]; then cd dats java -Dcadi_prop_files=../authBatch.props -DCASS_ENV=$ENV -jar ../aaf-auth-batch-*-full.jar Upload $UPLOAD 2>&1 logs/stdout cd - fi if [ "$DO_HISTORY" = "true" ]; then $CQLSH -e "COPY authz.history FROM 'dats/history.dat' WITH DELIMITER='|'" fi echo `date`