#!/bin/bash
# 2024-12

readonly INITDIR=$(cd $(dirname $0); dirname "$PWD")

# ldap test
ldap_test(){

netstat	-lnpt | grep ':389' &> /dev/null  \
&& return 0 \
|| return 4
}

# mysql test
mysql_test() {
/usr/bin/mysql -uroot -pZwkj@123Mysql -e 'show tables from clbs;' |  awk -F \| '{print $1}' |grep -v Tables | grep -oE "zw_.*"  &> /dev/null \
 && return 0  \
 || return 4 
}

# taos test
taos_test() {
/usr/bin/taos -h `hostname` -s "USE clbs; SHOW STABLES;" | grep -E "risk|gps"  &> /dev/null \
 &&  return 0 \
 || return 4 
}

# spark test
spark_test() {
/usr/bin/mysql -uroot -pZwkj@123Mysql -e 'show tables from clbs;'  | awk -F \| '{print $1}' |grep -v Tables | grep -oE "^[A-Z].*" | grep `date +%y%m`  &> /dev/null \
 && return 0 \
 || return 4
}

zwkj_single=0

ldap_test || $INITDIR/sh/ldap.sh
ldap_test && echo 'ldap and table is ok' \
 || { zwkj_single=4; echo "$(date +%Y-%m-%d-%T) ldap tables create is failed." | tee $INITDIR/logs/error.log;}

mysql_test ||  $INITDIR/sh/mysql.sh
mysql_test &&  echo 'mysql and table is ok'  \
|| { zwkj_single=4; echo "$(date +%Y-%m-%d-%T) mysql tables create is failed." | tee $INITDIR/logs/error.log;}

taos_test  ||  $INITDIR/sh/tdengine.sh
taos_test  &&  echo 'Tdengine and taos table is ok' \
 ||  { zwkj_single=4; echo "$(date +%Y-%m-%d-%T) tdengine taos tables create is failed." | tee $INITDIR/logs/error.log;}

spark_test || $INITDIR/sh/flink.sh
spark_test  && echo 'spark create tables OK' \
 || { zwkj_single=4;  echo "$(date +%Y-%m-%d-%T) spark init faild, spark create tables is failed." | tee $INITDIR/logs/error.log;}

[ "$zwkj_single" = "0" ] \
&& echo '300' > /opt/zwkj_single \
|| echo '400' > /opt/zwkj_single