53 lines
1.6 KiB
Bash
53 lines
1.6 KiB
Bash
#!/bin/bash
|
||
|
||
# ============================================================
|
||
# Flyway 数据库迁移状态检查脚本
|
||
# 用于验证数据库结构与迁移脚本的一致性
|
||
# ============================================================
|
||
|
||
echo "🔍 正在检查 Flyway 数据库迁移状态..."
|
||
echo "📊 数据库连接信息:"
|
||
echo " 主机: 10.0.0.58"
|
||
echo " 端口: 5432"
|
||
echo " 数据库: qaup"
|
||
echo " 用户: qaup"
|
||
echo ""
|
||
|
||
# 切换到项目根目录
|
||
cd "$(dirname "$0")/.."
|
||
cd qaup-admin
|
||
|
||
# 执行Flyway验证命令
|
||
echo "🚀 正在执行 Flyway 验证..."
|
||
mvn flyway:validate \
|
||
-Dspring.profiles.active=dev \
|
||
-Dflyway.url=jdbc:postgresql://10.0.0.58:5432/qaup \
|
||
-Dflyway.user=qaup \
|
||
-Dflyway.password=qaup123 \
|
||
-q
|
||
|
||
# 检查执行结果
|
||
if [ $? -eq 0 ]; then
|
||
echo ""
|
||
echo "✅ Flyway 验证成功！"
|
||
echo "📝 建议："
|
||
echo " - 数据库结构与迁移脚本一致"
|
||
echo " - 没有发现 schema drift"
|
||
echo " - 可以安全进行部署"
|
||
echo ""
|
||
echo "🔍 详细信息请查看上方输出"
|
||
else
|
||
echo ""
|
||
echo "❌ Flyway 验证失败！"
|
||
echo "🔧 建议："
|
||
echo " - 检查数据库连接"
|
||
echo " - 验证迁移脚本是否被修改"
|
||
echo " - 查看详细错误信息"
|
||
echo " - 联系开发团队进行修复"
|
||
echo ""
|
||
fi
|
||
|
||
echo ""
|
||
echo "📋 其他有用的Flyway命令："
|
||
echo " 查看迁移状态: ./check-flyway-info.sh"
|
||
echo " 执行迁移: mvn flyway:migrate -Dspring.profiles.active=dev -Dflyway.url=jdbc:postgresql://10.0.0.58:5432/qaup -Dflyway.user=qaup -Dflyway.password=qaup123" |