#!/bin/bash
# ===========================================
# 创建统一身份认证中间库表（MySQL 测试环境）
# ===========================================

set -euo pipefail
export LANG=C
export LC_ALL=C

SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
CONFIG_FILE="${SCRIPT_DIR}/data.conf"

if [[ ! -f "$CONFIG_FILE" ]]; then
    echo "错误：配置文件 $CONFIG_FILE 未找到"
    exit 1
fi

source "$CONFIG_FILE"

SQL_FILE="${SCRIPT_DIR}/建表脚本_mysql.sql"
if [[ ! -f "$SQL_FILE" ]]; then
    echo "错误：建表脚本 $SQL_FILE 未找到"
    exit 1
fi

echo "正在目标库创建中间表: ${TARGET_DB_USER}@${TARGET_DB_HOST}:${TARGET_DB_PORT}/${TARGET_DB_NAME}"
python3 "${SCRIPT_DIR}/db_helper.py" \
    --host "$TARGET_DB_HOST" --port "$TARGET_DB_PORT" \
    --user "$TARGET_DB_USER" --password "$TARGET_DB_PASS" --database "$TARGET_DB_NAME" \
    file "$SQL_FILE"
echo "建表完成"