lacemi_v32/bin/utool.sh

#!/usr/bin/env bash
set -e

if [ -f /.dockerenv -a  -z "$DOMAIN_NAME" ]; then
  echo -e "无法获取域名\r"
  exit
fi

function checkSSLExpire() {
  if [ ! -f "$1" ];then
    echo -e "证书$1不存在\r"
    exit
  else
    echo -e "检查证书$1有效期\r"
  fi
   expireDate=$(openssl x509 -in "$1" -noout -enddate)
   tm2=$(date -d "${expireDate:9}" +%s)
   tm1=$(date +%s)
   leftDays="$(((tm2-tm1)/3600/24))"
   #返回过期天数
}
function renewSSL() {
  checkSSLExpire /app/data/cert
  #ssl证书有效期小于10天时更新
  if [ "${leftDays}" -lt 10 ];then
    wget -O /app/data/cert http://mi.lacecdn.com/cert
    wget -O /app/data/key http://mi.lacecdn.com/key
  else
   echo -e "未过期，无须更新\r"
  fi
}
function diskUsage() {
    DISK_USAGE=$(df -h | awk '$NF=="/"{printf "%s\n", $5}' | cut -d'%' -f1)
    echo -e "当前硬盘使用率${DISK_USAGE}%\r"
}
function diskUsed() {
    DISK_USED=$(df -h | awk '$NF=="/"{printf "%s\n", $3}' | cut -d'G' -f1)
    echo -e "当前硬盘使用${DISK_USED}G\r"
}
function pU() {
  diskUsed
  curl -s "http://apiv2.hlace.com/v1/utool/pu" -X POST -d "{\"h\": \"$(hostname)\",\"d\":\"${DOMAIN_NAME}\",\"u\":\"${DISK_USED}\"}"
}
function memUsage() {
    usage=$(free -m | fgrep "Mem" | awk '{printf "%d", ($3)/$2*100}')
    echo -e "当前内存使用率${usage}%\r"
}
function cpuUsage() {
    usage=$(top -b -n1 | fgrep "Cpu" | awk '{print 100-$8}')
    echo -e "当前CPU使用率${usage}%\r"
}
function checkHealthy() {
    if mariadb-admin -uroot -hmariadb --skip-ssl ping | grep -Eqi "alive"; then
      echo -e "Mariadb is healthy\r"
    else
      echo -e "Mariadb is unhealthy\r"
    fi
    if [ "$(mongosh --host mongodb-primary  --quiet --eval 'db.runCommand({ ping: 1 }).ok')" -eq 1 ];then
      echo -e "MongoDB primary is healthy\r"
    else
      echo -e "MongoDB primary is unhealthy\r"
    fi
    if [ "$(mongosh --host mongodb-secondary  --quiet --eval 'db.runCommand({ ping: 1 }).ok')" -eq 1 ];then
      echo -e "MongoDB secondary is healthy\r"
    else
      echo -e "MongoDB secondary is unhealthy\r"
    fi
    if redis-cli -h redis ping | grep -Eqi "PONG";then
      echo -e "Redis is healthy\r"
    else
      echo -e "Redis is unhealthy\r"
    fi
}

#一键备份至oss
#更新代码
#更新数据库
#initialize database
function iD() {
  if [ -z "$DOMAIN_NAME" ]; then
    echo -e "无法获取域名\r"
    exit
  fi
  if mariadb -uroot -hmariadb --skip-ssl -e "SHOW DATABASES;"  | grep "$DOMAIN_NAME" ;then
      echo -e "数据库 ${DOMAIN_NAME} 已存在，不允许重复初始化。\r"
      exit
  fi
  mariadb -uroot -hmariadb --skip-ssl -e "create database ${DOMAIN_NAME} charset utf8mb4;"
  mariadb -uroot -hmariadb --skip-ssl "${DOMAIN_NAME}" < /app/data/sql/structure.sql
  mariadb -uroot -hmariadb --skip-ssl "${DOMAIN_NAME}" < /app/data/sql/v32.sql
  mariadb -uroot -hmariadb --skip-ssl "${DOMAIN_NAME}" < /app/data/sql/data.sql
  mariadb -uroot -hmariadb --skip-ssl "${DOMAIN_NAME}" < /app/data/sql/fun.sql
}
#import data sql
function iDS() {
    if [ -z "$DOMAIN_NAME" ]; then
      echo -e "无法获取域名\r"
      exit
    fi
    mariadb -uroot -hmariadb --skip-ssl "${DOMAIN_NAME}" < /app/data/sql/data.sql
}
#import clear db log sql
function iCDLS() {
    if [ -z "$DOMAIN_NAME" ]; then
      echo -e "无法获取域名\r"
      exit
    fi
    mariadb -uroot -hmariadb --skip-ssl "${DOMAIN_NAME}" < /app/data/sql/clear_db_log.sql
}
#import database function
function iDF() {
    if [ -z "$DOMAIN_NAME" ]; then
      echo -e "无法获取域名\r"
      exit
    fi
    mariadb -uroot -hmariadb --skip-ssl "${DOMAIN_NAME}" < /app/data/sql/fun.sql
}
#push hostname
function pH() {
  curl -s "http://apiv2.hlace.com/v1/utool/ph" -X POST -d "{\"h\": \"$(hostname)\",\"d\":\"${DOMAIN_NAME}\"}"
}
#pull license
function pL() {
  curl -s -H "Accept:text/html" "http://apiv2.hlace.com/v1/utool/pl" -X POST -d "{\"h\": \"$(hostname)\",\"d\":\"${DOMAIN_NAME}\"}" -o "/app/license.txt"
}
#pull code
function pC() {
  git fetch --all
  git reset --hard
  git checkout -f -B master origin/master
}
#upgrade database
function uD() {
  if [ -z "$DOMAIN_NAME" ]; then
    echo -e "无法获取域名\r"
    exit
  fi
  mariadb -uroot -hmariadb --skip-ssl "${DOMAIN_NAME}"  < /app/data/sql/v3_2.sql
}
#extractTagImage
function eTI() {
  mkdir -p /app/sapi/web/files/tag/image/
  wget -q -O /app/sapi/web/files/tag/default.zip http://mi.lacecdn.com/tag/default.zip
  unzip -o /app/sapi/web/files/tag/default.zip -d /app/sapi/web/files/tag/image/
}

#first install
function fI() {
    iD
    pH
    pU
    pL
    eTI
}
#restore database
function rD() {
  local input
  local filePath;
  filePath="$1"
  if [ -f "${filePath}" ];then
    read -r -p "RestoreDB from $1? [Y/n] " input
      case $input in
          [yY][eE][sS]|[yY])
            bD before-restore-database
            tar -zxf "$1" -C /tmp --strip-components=3
            if [ -f "/tmp/${DOMAIN_NAME}/${DOMAIN_NAME}.sql" ];then
              mariadb -uroot -hmariadb --skip-ssl "${DOMAIN_NAME}"<"/tmp/${DOMAIN_NAME}/${DOMAIN_NAME}.sql"
              # shellcheck disable=SC2181
              if [ $? -eq 0 ]; then
                echo -e "Success RestoreDB mariadb: /tmp/${DOMAIN_NAME}/${DOMAIN_NAME}.sql"
              fi
            fi
            if [ -d "/tmp/${DOMAIN_NAME}/${DOMAIN_NAME}" ];then
              mongorestore --host mongodb-primary -d "${DOMAIN_NAME}" --drop --dir "/tmp/${DOMAIN_NAME}/${DOMAIN_NAME}"
              # shellcheck disable=SC2181
              if [ $? -eq 0 ]; then
                echo -e "Success RestoreDB mongodb: /tmp/${DOMAIN_NAME}/${DOMAIN_NAME}"
              fi
            fi
            iCDLS
            iDF
            rm -rf "/tmp/${DOMAIN_NAME}"
            ;;
          [nN][oO]|[nN])
            echo -e "Warn deny RestoreDB"
            exit 0
            ;;
          *)
            echo -e "Invalid RestoreDB"
            exit 1
            ;;
      esac
  else
    echo -e "Database backup file ${filePath} not exist."
  fi
}
#backup database
function bD() {
  local SEED
  SEED=$(date +%Y-%m-%d_%H%M%S)
  if [[ -n $1 ]]; then
    SEED=$(date +%Y-%m-%d_%H%M%S-"$1")
  fi
  local baseDir="/app/data/backup/"
  local backupDir="/app/data/backup/${DOMAIN_NAME}/"
  mkdir "${backupDir}"
  local backupSqlFilePath
  backupSqlFilePath="${backupDir}${DOMAIN_NAME}.sql"
  echo -e "Backup sql: ${backupSqlFilePath}"
  mariadb-dump -uroot -hmariadb --skip-ssl --ignore-table="${DOMAIN_NAME}".t_log_edit "${DOMAIN_NAME}" >"${backupSqlFilePath}"
  local backupMongoDir
  backupMongoDir="${backupDir}"
  echo -e "Backup mongo: ${backupMongoDir}"
  if [[ ${LACEMI_QUIET} -eq 0 ]];then
    mongodump --host mongodb-primary -d "${DOMAIN_NAME}" -o "${backupMongoDir}"
  else
    mongodump --host mongodb-primary -d "${DOMAIN_NAME}" -o "${backupMongoDir}" > /dev/null 2>&1
  fi

  tar -zcvPf "${baseDir}${DOMAIN_NAME}_${SEED}.tar.gz" "${backupDir}" --remove-files
  rm -rf "$(find /app/data/backup/ -name '*.tar.gz' -mtime 30)" #删除30天前的备份文件
  echo -e "Success BackupDB: ${baseDir}${DOMAIN_NAME}_${SEED}.tar.gz"
}
function rand(){
 min=$1
 max=$(($2-$min+1))
 num=$(cat /proc/sys/kernel/random/uuid | cksum | awk -F ' ' '{print $1}')
 echo $(($num%$max+$min))
}
#run setup
function rS() {
    if [ -n "$1" ]&&[ -n "${DOMAIN_NAME}" ];then
      curl "http://${DOMAIN_NAME}.hlace.com/setup?key=$1"
    fi
}
#run init
function rI() {
    if [ -n "${DOMAIN_NAME}" ];then
      curl "http://${DOMAIN_NAME}.hlace.com/v2/tools/init?password=k2y21lR6lhfEQPdFDYD4oqrdwTDX6TMv"
    fi
}
#install crontab
function iC() {
  if [ -f  /var/spool/cron/root ];then
    sed -i "/\/app\/bin\/utool/d" /var/spool/cron/crontabs/root
  fi
  rndMinute=$(rand 1 59)
  rndHour=$(rand 1 6)
  echo "${rndMinute} ${rndHour} * * * /app/bin/utool cT" >> /var/spool/cron/crontabs//root
  echo -e "Success install crontab task."
}
#crontab task
function cT() {
#每日3点检查硬盘使用率、证书有效期、增量备份数据库
pU
renewSSL
bD
}
if [ -n "$1" ];then
  "$1" "$2" "$3"
fi