create_tables.sh 928 B

12345678910111213141516171819202122232425262728293031
  1. #!/bin/bash
  2. # ===========================================
  3. # 创建统一身份认证中间库表(MySQL 测试环境)
  4. # ===========================================
  5. set -euo pipefail
  6. export LANG=C
  7. export LC_ALL=C
  8. SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
  9. CONFIG_FILE="${SCRIPT_DIR}/data.conf"
  10. if [[ ! -f "$CONFIG_FILE" ]]; then
  11. echo "错误:配置文件 $CONFIG_FILE 未找到"
  12. exit 1
  13. fi
  14. source "$CONFIG_FILE"
  15. SQL_FILE="${SCRIPT_DIR}/建表脚本_mysql.sql"
  16. if [[ ! -f "$SQL_FILE" ]]; then
  17. echo "错误:建表脚本 $SQL_FILE 未找到"
  18. exit 1
  19. fi
  20. echo "正在目标库创建中间表: ${TARGET_DB_USER}@${TARGET_DB_HOST}:${TARGET_DB_PORT}/${TARGET_DB_NAME}"
  21. python3 "${SCRIPT_DIR}/db_helper.py" \
  22. --host "$TARGET_DB_HOST" --port "$TARGET_DB_PORT" \
  23. --user "$TARGET_DB_USER" --password "$TARGET_DB_PASS" --database "$TARGET_DB_NAME" \
  24. file "$SQL_FILE"
  25. echo "建表完成"