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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
|
#!/bin/bash
#/**
#@file checktest
#@brief Run tests to check the OpenGnsys Server REST functions.
#@usage checktest [help]
#@warning This script inserts test data into the database and deletes it before finishing.
#@version 1.1.1 - Initial version.
#@author Ramón M. Gómez - ETSII Univ. Sevilla
#@date 2019-10-07
#*/ ##
PROG=$(basename "$0")
OPENGNSYS=/opt/opengnsys
CONFIGFILE=$OPENGNSYS/etc/ogAdmServer.cfg
RESTURL="https://localhost/opengnsys/rest"
source $OPENGNSYS/lib/ogfunctions.sh || exit 1
# Test a REST ROUTE. Parameters: Route Headers Data Agent
function route () {
local ROUTE PARAM METHOD HEADER DATA AGENT RET STATUS
ROUTE="$1"
PARAM="$2"
HEADER="$3"
DATA="$4"
AGENT="$5"
METHOD="${DATA:+POST}"
METHOD="${METHOD:-GET}"
RESP=$(curl -4ks -w "%{http_code}" ${HEADER:+-H "$HEADER"} ${DATA:+-d "$DATA"} ${AGENT:+-A "$AGENT"} "$RESTURL$ROUTE")
RET=$?
CODE="${RESP: -3}"
RESP="${RESP::-3}"
[ "$PARAM" ] && PARAM="($PARAM: $(jq -r ".$PARAM // \"not found\"" <<<"$RESP"))"
case "$CODE" in
200) let OK=OK+1
STATUS="OK $PARAM" ;;
404) let FAIL=FAIL+1
STATUS="FAIL ($CODE: $(echo $RESP))" ;;
000) let FAIL=FAIL+1
STATUS="FAIL (Connection error: $RET)" ;;
*) let FAIL=FAIL+1
STATUS="FAIL ($CODE: $(jq -r '.message|gsub(":.*";"")' <<<"$RESP"))" ;;
esac
printf "%-40s: %s\n" "- $METHOD $ROUTE" "$STATUS"
}
# Execute database operation.
function dbexec () {
MYCNF=$(mktemp)
trap "rm -f $MYCNF" 0 1 2 3 6 9 15
touch $MYCNF
chmod 600 $MYCNF
cat << EOT > $MYCNF
[client]
user=$USUARIO
password=$PASSWORD
EOT
mysql --defaults-extra-file="$MYCNF" -D "$CATALOG" -s -N -e "$1" || \
raiseError access "Cannot access the databse"
}
# Delete test data from the database.
function deletedata () {
# Delete test data, if exists.
DATA="
DELETE FROM centros, administradores_centros USING centros INNER JOIN administradores_centros
WHERE centros.idcentro=administradores_centros.idcentro AND centros.nombrecentro='TestOU';
DELETE FROM repositorios WHERE nombrerepositorio='TestRepo';
DELETE FROM aulas WHERE nombreaula='TestLab';
DELETE FROM ordenadores WHERE nombreordenador='TestClnt';
"
dbexec "$DATA"
}
# Load test data into the database.
function loaddata () {
# Insert test data.
DATA="
INSERT INTO centros (nombrecentro, identidad, comentarios)
VALUES ('TestOU', 1, 'Tests');
SET @ou_id := LAST_INSERT_ID();
INSERT INTO administradores_centros (idusuario, idcentro)
VALUES (1, @ou_id);
INSERT INTO repositorios (nombrerepositorio, idcentro, ip)
VALUES ('TestRepo', @ou_id, '127.0.0.1');
SET @repo_id := LAST_INSERT_ID();
INSERT INTO aulas (nombreaula, idcentro, inremotepc)
VALUES ('TestLab', @ou_id, 0);
SET @lab_id := LAST_INSERT_ID();
INSERT INTO ordenadores (nombreordenador, idrepositorio, idaula, ip, mac)
VALUES ('TestClnt', @id_repo, @lab_id, '127.0.0.1', '001122334455');
SET @clnt_id := LAST_INSERT_ID();
"
dbexec "$DATA"
}
function runtests () {
local OK FAIL
let OK=FAIL=0
echo "Running tests..."
route "/info" "release"
route "/status" "cpu.usage"
DATA='{"username":"'$USUARIO'","password":"'$PASSWORD'"}'
route /login "" "" "$DATA"
HEADERS="Authorization: $(jq -r '.apikey' <<<"$RESP")"
route /ous
OU=$(jq -r '.[] | select(.name=="TestOU").id' <<<"$RESP")
route "/ous/$OU" "name" "$HEADERS"
route "/ous/$OU/repos" "" "$HEADERS"
REPO=$(jq -r '.[] | select(.name=="TestRepo").id' <<<"$RESP")
route "/ous/$OU/repos/$REPO" "name" "$HEADERS"
route "/ous/$OU/labs" "" "$HEADERS"
LAB=$(jq -r '.[] | select(.name=="TestLab").id' <<<"$RESP")
route "/ous/$OU/labs/$LAB" "name" "$HEADERS"
route "/ous/$OU/labs/$LAB/clients" "" "$HEADERS"
CLNT=$(jq -r '.[] | select(.name=="TestClnt").id' <<<"$RESP")
route "/ous/$OU/labs/$LAB/clients/$CLNT" "name" "$HEADERS"
read -r IP MAC <<<$(jq -r '.ip+" "+([.mac[0:2],.mac[2:4],.mac[4:6],.mac[6:8],.mac[8:10],.mac[10:12]] | join(":"))' <<<"$RESP")
route "/ous/$OU/labs/$LAB/clients/$CLNT/status" "status" "$HEADERS"
route "/ous/$OU/images" "" "$HEADERS"
AGENT="python-requests/test"
DATA='{"ip":"'$IP'","mac":"'$MAC'","ostype":"Windows","osversion":"Windows Test","secret":"'$(printf "%.sX" {1..32})'"}'
route "/ogagent/started" "" "" "$DATA" "$AGENT"
DATA='{"ip":"'$IP'","user":"test","language":"en","ostype":"Windows","osversion":"Windows 10 Test"}'
route "/ogagent/loggedin" "" "" "$DATA" "$AGENT"
route "/ogagent/loggedout" "" "" "$DATA" "$AGENT"
DATA='{"ip":"'$IP'","mac":"'$MAC'","ostype":"Windows","osversion":"Windows Test"}'
route "/ogagent/stopped" "" "" "$DATA" "$AGENT"
echo "Tests OK: $OK"
echo "Tests failed: $FAIL"
}
# Main program.
# Show help.
[ "$*" == "help" ] && help
[ "$*" ] && raiseError usage
# Access control.
[ "$USER" == "root" ] || raiseError access "Need to be root."
[ -r $CONFIGFILE ] || raiseError access "Configuration file."
# Check dependencies.
which jq &>/dev/null || raiseError notfound "Need to install \"jq\"."
source $CONFIGFILE
deletedata
loaddata
runtests
deletedata
|
