summaryrefslogtreecommitdiffstats
path: root/test/csit/plans/appc/healthcheck/db_query.sh
blob: 87e0ac397906d47bbeee9bcf00aab96584172597 (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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
#!/usr/bin/env bash
###############################################################################
# Copyright 2017 Huawei Technologies Co., Ltd.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
###############################################################################
SCRIPTS="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
echo $SCRIPTS

sdnctl_num_tables=$(docker exec -i sdnc_db_container mysql -s -D sdnctl -u sdnctl -pgamma <<<'show tables;' 2>/dev/null | grep -v ERROR | wc -l)

appcctl_num_tables=$(docker exec -i sdnc_db_container mysql -s -D appcctl -u appcctl -pappcctl <<<'show tables;' 2>/dev/null | grep -v ERROR | wc -l)



docker exec -i sdnc_db_container mysql -s -D sdnctl -u sdnctl -pgamma <<<"show tables" 2>/dev/null | ( while read table_name; do 
export $table_name="$(docker exec -i sdnc_db_container mysql -s -D sdnctl -u sdnctl -pgamma <<<"select count(*) from $table_name" 2>/dev/null)"
done 

if [ "$sdnctl_num_tables" -ge "1" ]; then
  echo "There are $sdnctl_num_tables tables in the sdnctl database. "
else
  echo "Database sdnctl is not available."
  exit 1;
fi

if [ "$appcctl_num_tables" -ge "1" ]; then
  echo "There is $appcctl_num_tables table in the appcctl database. "
else
  echo "Database appcctl is not available."
  exit 1;
fi

if [ "$NODE_TYPES" -eq "0" ]; then
  echo "There is no data in table NODE_TYPES. "
  exit 1;
fi

if [ "$SVC_LOGIC" -eq "0" ] ; then
  echo "There is no data in table SVC_LOGIC. "
  exit 1;
fi

if [ "$VNF_DG_MAPPING" -eq "0" ]; then
  echo "There is no data in table VNF_DG_MAPPING. "
  exit 1;
fi 

echo "Expected table data is present."
exit 0 )

if [ "$?" -eq "1" ]; then
  exit 1;
fi

exit 0