56 lines
1.6 KiB
Batchfile
56 lines
1.6 KiB
Batchfile
|
@echo off
|
||
|
|
chcp 65001 >nul
|
||
|
|
title ETest Database Setup
|
||
|
|
color 0A
|
||
|
|
|
||
|
|
echo ========================================
|
||
|
|
echo ETest Database Setup
|
||
|
|
echo ========================================
|
||
|
|
echo.
|
||
|
|
|
||
|
|
cd /d C:\PPRO\ETest-Vue-FastAPI
|
||
|
|
|
||
|
|
echo [*] Step 1: Creating database...
|
||
|
|
docker exec etest-mysql mysql -uroot -pTgzz2025+ -e "CREATE DATABASE IF NOT EXISTS ruoyi_fastapi CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
|
||
|
|
if %errorlevel% neq 0 (
|
||
|
|
echo [!] Failed to create database
|
||
|
|
pause
|
||
|
|
exit /b 1
|
||
|
|
)
|
||
|
|
echo [OK] Database created
|
||
|
|
echo.
|
||
|
|
|
||
|
|
echo [*] Step 2: Importing base RuoYi schema...
|
||
|
|
docker exec -i etest-mysql mysql -uroot -pTgzz2025+ ruoyi_fastapi < ruoyi-fastapi-backend\sql\ruoyi-fastapi.sql
|
||
|
|
if %errorlevel% neq 0 (
|
||
|
|
echo [!] Base schema import failed
|
||
|
|
pause
|
||
|
|
exit /b 1
|
||
|
|
)
|
||
|
|
echo [OK] Base schema imported
|
||
|
|
echo.
|
||
|
|
|
||
|
|
echo [*] Step 3: Importing ETest Phase 1...
|
||
|
|
docker exec -i etest-mysql mysql -uroot -pTgzz2025+ ruoyi_fastapi < sql\migration\20260321_phase1_base_tables.sql
|
||
|
|
echo [OK] Phase 1 completed
|
||
|
|
echo.
|
||
|
|
|
||
|
|
echo [*] Step 4: Importing ETest Phase 2...
|
||
|
|
docker exec -i etest-mysql mysql -uroot -pTgzz2025+ ruoyi_fastapi < sql\migration\20260321_phase2_workorder_extend.sql
|
||
|
|
echo [OK] Phase 2 completed
|
||
|
|
echo.
|
||
|
|
|
||
|
|
echo [*] Step 5: Importing ETest Phase 3...
|
||
|
|
docker exec -i etest-mysql mysql -uroot -pTgzz2025+ ruoyi_fastapi < sql\migration\20260321_phase3_report_tables.sql
|
||
|
|
echo [OK] Phase 3 completed
|
||
|
|
echo.
|
||
|
|
|
||
|
|
echo ========================================
|
||
|
|
echo Database Setup Complete!
|
||
|
|
echo ========================================
|
||
|
|
echo.
|
||
|
|
echo [*] Verifying tables:
|
||
|
|
docker exec etest-mysql mysql -uroot -pTgzz2025+ ruoyi_fastapi -e "SHOW TABLES LIKE 'test_%';"
|
||
|
|
echo.
|
||
|
|
pause
|