Files
dbx-corm/deploy-corm-postgres.sh

99 lines
5.0 KiB
Bash

#!/usr/bin/env bash
# Run by the server operator. No source-sheet writes or database overwrites.
set -Eeuo pipefail
umask 077
cd -- "$(dirname -- "${BASH_SOURCE[0]}")"
project_dir="$(pwd -P)"
test -f .env || { printf '%s\n' '.env 파일이 없습니다.' >&2; exit 1; }
git diff --quiet && git diff --cached --quiet || { printf '%s\n' '서버에 커밋되지 않은 코드 변경이 있어 중단합니다.' >&2; exit 1; }
docker compose version >/dev/null
docker compose ps
container="$(docker compose ps -q corm-app)"
test -n "$container" || { printf '%s\n' '기존 corm-app 컨테이너가 실행 중이어야 합니다.' >&2; exit 1; }
# Capture the current runtime, including configurable legacy file locations.
runtime="$(docker exec "$container" python -c 'import os; from pathlib import Path; print(os.getenv("SETTINGS_BACKEND", "google")); print(os.getenv("HISTORY_BACKEND", "google")); print(os.getenv("SETTINGS_DB", "corm_db")); print(int(bool(os.getenv("INTERNAL_SERVICE_TOKEN")))); print(os.getenv("SMS_HISTORY_FILE", "/app/sms_history.dat")); print(os.getenv("MANUAL_HISTORY_FILE", "/app/manual_history.dat"))')"
mapfile -t runtime_values <<< "$runtime"
settings_source="${runtime_values[0]}"
history_source="${runtime_values[1]}"
[[ "$settings_source" =~ ^(google|postgres)$ && "$history_source" =~ ^(google|postgres)$ ]] || exit 1
if [[ "$settings_source" == postgres || "$history_source" == postgres ]]; then
[[ "${runtime_values[2]}" == corm_db ]] || { printf '%s\n' '현재 DB 저장소가 corm_db가 아니므로 자동 이전을 중단합니다.' >&2; exit 1; }
fi
[[ "${runtime_values[3]}" == 1 ]] || { printf '%s\n' '기존 INTERNAL_SERVICE_TOKEN이 없어 전환 후 API를 검증할 수 없습니다.' >&2; exit 1; }
stamp="$(date -u +%Y%m%dT%H%M%SZ)-$$"
backup_dir="$project_dir/.settings-backups/deploy-$stamp"
mkdir -p -- "$backup_dir"
chmod 700 -- "$backup_dir"
cp -p -- .env "$backup_dir/env.before"
cp -p -- docker-compose.yml "$backup_dir/compose.before.yml"
old_image="$(docker inspect --format '{{.Image}}' "$container")"
rollback_image="dbx-corm:before-postgres-$stamp"
docker image tag "$old_image" "$rollback_image"
printf 'services:\n corm-app:\n image: %s\n' "$rollback_image" > "$backup_dir/rollback.yml"
printf '백업 위치: %s\n' "$backup_dir"
printf '%s\n' '이미지를 빌드합니다. 이후 이전이 끝날 때까지 다른 앱과 시트에서 설정·내역 편집을 중단해주세요.'
docker compose build corm-app
stopped=0
env_changed=0
rollback() {
result=$?
trap - ERR INT TERM
printf '전환 실패. 백업 보존 위치: %s\n' "$backup_dir" >&2
if [[ "$stopped" == 1 ]]; then
if [[ "$env_changed" == 1 ]]; then
cp -p -- "$backup_dir/env.before" "$project_dir/.env" || true
fi
# Reuse the exact former image; never restore/drop the database automatically.
if docker compose -f "$project_dir/docker-compose.yml" -f "$backup_dir/rollback.yml" up -d --no-deps --no-build corm-app; then
printf '%s\n' '이전 이미지와 환경으로 앱을 다시 시작했습니다. DB와 원본 백업은 보존했습니다.' >&2
else
printf '%s\n' '앱 자동 재시작을 확인하지 못했습니다. 위 백업의 env.before·rollback.yml을 확인해주세요.' >&2
fi
fi
[[ "$result" != 0 ]] || result=1
exit "$result"
}
trap rollback ERR INT TERM
# Capture existence before stopping; docker cp also works on stopped containers.
sms_exists="$(docker exec "$container" python -c 'import os; from pathlib import Path; print(int(Path(os.getenv("SMS_HISTORY_FILE", "/app/sms_history.dat")).is_file()))')"
manual_exists="$(docker exec "$container" python -c 'import os; from pathlib import Path; print(int(Path(os.getenv("MANUAL_HISTORY_FILE", "/app/manual_history.dat")).is_file()))')"
stopped=1
docker compose stop corm-app
if [[ "$sms_exists" == 1 ]]; then
docker cp "$container:${runtime_values[4]}" "$backup_dir/legacy-sms.dat"
fi
if [[ "$manual_exists" == 1 ]]; then
docker cp "$container:${runtime_values[5]}" "$backup_dir/legacy-manual.dat"
fi
printf '로컬 원본 파일: 문자=%s 수동발주=%s\n' "$sms_exists" "$manual_exists"
run_corm() {
docker compose run --rm --no-deps -T \
-e SETTINGS_DB=corm_db -e SETTINGS_BACKEND=google -e HISTORY_BACKEND=google \
-v "$backup_dir:/backups" -v "$project_dir:/deploy" corm-app python deploy_corm.py "$@"
}
run_corm snapshot --settings-source "$settings_source" --history-source "$history_source"
run_corm database
run_corm migrate
env_changed=1
run_corm environment
docker compose up -d --no-deps --no-build corm-app
ready=0
for attempt in {1..12}; do
if docker compose exec -T corm-app python deploy_corm.py probe; then
ready=1
break
fi
sleep 2
done
[[ "$ready" == 1 ]]
trap - ERR INT TERM
docker compose ps
printf 'CORM 설정·문자내역·수동발주내역 corm_db 전환 완료. 백업: %s\n' "$backup_dir"
printf '%s\n' '직원 계정으로 로그인해 화면에서 내역 불러오기와 설정을 확인해주세요.'