51 lines
1.9 KiB
Bash
Executable File
51 lines
1.9 KiB
Bash
Executable File
#!/usr/bin/env bash
|
||
set -euo pipefail
|
||
|
||
# Docker creates a missing bind-mounted file source as a directory. MySQL's
|
||
# entrypoint then treats that directory as a SQL input and exits before the
|
||
# local database is usable. Keep optional platform SQL behind generated files:
|
||
# present sources are copied and executed, absent sources become harmless no-op
|
||
# SQL files so lightweight backend checkouts can still start.
|
||
SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
|
||
PROJECT_ROOT="$(cd "${SCRIPT_DIR}/.." && pwd)"
|
||
DEPLOY_PLATFORM_ROOT="${DEPLOY_PLATFORM_ROOT:-${PROJECT_ROOT}/../deploy-platform}"
|
||
LOCAL_INITDB_DIR="${PROJECT_ROOT}/tmp/mysql/initdb"
|
||
|
||
OPTIONAL_SQL_FILES=(
|
||
"005_utf8mb4_chinese_support.sql"
|
||
"006_admin_database.sql"
|
||
"007_resource_group_wallet_asset_items.sql"
|
||
"999_local_grants.sql"
|
||
)
|
||
|
||
mkdir -p "${LOCAL_INITDB_DIR}"
|
||
|
||
for sql_name in "${OPTIONAL_SQL_FILES[@]}"; do
|
||
source_file="${DEPLOY_PLATFORM_ROOT}/deploy/mysql/initdb/${sql_name}"
|
||
target_file="${LOCAL_INITDB_DIR}/${sql_name}"
|
||
|
||
if [[ -f "${source_file}" ]]; then
|
||
cp "${source_file}" "${target_file}"
|
||
if [[ "${sql_name}" == "999_local_grants.sql" ]]; then
|
||
# hyapp-server 新增 owner 库时，deploy-platform 的本地授权文件可能还没同步。
|
||
# 本地启动必须以当前仓库服务清单为准，否则新服务库已经创建但 hyapp 用户无法连接。
|
||
cat >> "${target_file}" <<'EOF'
|
||
GRANT ALL PRIVILEGES ON hyapp_lucky_gift.* TO 'hyapp'@'%';
|
||
FLUSH PRIVILEGES;
|
||
EOF
|
||
fi
|
||
printf 'prepared optional mysql init file: %s\n' "${source_file}"
|
||
continue
|
||
fi
|
||
|
||
printf -- '-- optional mysql init file is absent locally: %s\n' "${source_file}" > "${target_file}"
|
||
if [[ "${sql_name}" == "999_local_grants.sql" ]]; then
|
||
cat >> "${target_file}" <<'EOF'
|
||
CREATE USER IF NOT EXISTS 'hyapp'@'%' IDENTIFIED BY 'hyapp';
|
||
GRANT ALL PRIVILEGES ON hyapp_lucky_gift.* TO 'hyapp'@'%';
|
||
FLUSH PRIVILEGES;
|
||
EOF
|
||
fi
|
||
printf 'prepared empty optional mysql init file: %s\n' "${source_file}"
|
||
done
|