60 lines
1.7 KiB
Batchfile
60 lines
1.7 KiB
Batchfile
|
@echo off
|
||
|
|
chcp 65001 >nul
|
||
|
|
title Execute ETest SQL Migration
|
||
|
|
color 0A
|
||
|
|
|
||
|
|
echo ========================================
|
||
|
|
echo ETest Database Migration
|
||
|
|
echo ========================================
|
||
|
|
echo.
|
||
|
|
|
||
|
|
cd /d C:\PPRO\ETest-Vue-FastAPI
|
||
|
|
|
||
|
|
echo [*] Checking MySQL connection...
|
||
|
|
docker exec etest-mysql mysql -uroot -pTgzz2025+ -e "SELECT 1;" >nul 2>&1
|
||
|
|
if %errorlevel% neq 0 (
|
||
|
|
echo [!] MySQL not ready, waiting...
|
||
|
|
timeout /t 5 /nobreak >nul
|
||
|
|
)
|
||
|
|
|
||
|
|
echo [*] Creating database if not exists...
|
||
|
|
docker exec etest-mysql mysql -uroot -pTgzz2025+ -e "CREATE DATABASE IF NOT EXISTS ruoyi_fastapi CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
|
||
|
|
|
||
|
|
echo.
|
||
|
|
echo [*] Executing Phase 1: Base Tables...
|
||
|
|
docker exec -i etest-mysql mysql -uroot -pTgzz2025+ ruoyi_fastapi < sql\migration\20260321_phase1_base_tables.sql
|
||
|
|
if %errorlevel% equ 0 (
|
||
|
|
echo [OK] Phase 1 completed
|
||
|
|
) else (
|
||
|
|
echo [!] Phase 1 failed or partially applied
|
||
|
|
)
|
||
|
|
|
||
|
|
echo.
|
||
|
|
echo [*] Executing Phase 2: Work Order Extension...
|
||
|
|
docker exec -i etest-mysql mysql -uroot -pTgzz2025+ ruoyi_fastapi < sql\migration\20260321_phase2_workorder_extend.sql
|
||
|
|
if %errorlevel% equ 0 (
|
||
|
|
echo [OK] Phase 2 completed
|
||
|
|
) else (
|
||
|
|
echo [!] Phase 2 failed or partially applied
|
||
|
|
)
|
||
|
|
|
||
|
|
echo.
|
||
|
|
echo [*] Executing Phase 3: Report Tables...
|
||
|
|
docker exec -i etest-mysql mysql -uroot -pTgzz2025+ ruoyi_fastapi < sql\migration\20260321_phase3_report_tables.sql
|
||
|
|
if %errorlevel% equ 0 (
|
||
|
|
echo [OK] Phase 3 completed
|
||
|
|
) else (
|
||
|
|
echo [!] Phase 3 failed or partially applied
|
||
|
|
)
|
||
|
|
|
||
|
|
echo.
|
||
|
|
echo ========================================
|
||
|
|
echo Migration Complete!
|
||
|
|
echo ========================================
|
||
|
|
echo.
|
||
|
|
echo [*] Verifying tables...
|
||
|
|
docker exec etest-mysql mysql -uroot -pTgzz2025+ ruoyi_fastapi -e "SHOW TABLES LIKE 'test%';"
|
||
|
|
|
||
|
|
echo.
|
||
|
|
pause
|