blob: 768cf4c7e38edee8fa5f3333318fa1969e48760d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
# echo -n "Password:"
# read -s PWD
# echo
echo `date`
ENV=DOCKER
CQLSH="/usr/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")
$CQLSH -e "truncate $T"
UPLOAD="$UPLOAD dats/"$T
;;
*)
$CQLSH -e "truncate $T; COPY authz.${T} FROM 'dats/${T}.dat' WITH DELIMITER='|'"
;;
esac
fi
done
if [ ! "$UPLOAD" = "" ]; then
java -DCASS_ENV=$ENV -jar aaf-auth-batch-*-full.jar Upload $UPLOAD
fi
echo `date`
|
