#!/bin/bash
# CentOS 7.9 部署脚本
# 用于在CentOS服务器上安装Python依赖并运行数据库连接测试

echo "=========================================="
echo "CentOS 7.9 数据库连接测试部署脚本"
echo "=========================================="

# 检查Python版本
echo "检查Python版本..."
python3 --version
if [ $? -ne 0 ]; then
    echo "错误: 未找到python3，请先安装Python 3.8.3或更高版本"
    exit 1
fi

# 检查pip
echo "检查pip..."
python3 -m pip --version
if [ $? -ne 0 ]; then
    echo "pip未安装，正在安装pip..."
    python3 -m ensurepip --upgrade
fi

# 安装依赖
echo "安装Python依赖包..."
python3 -m pip install -r requirements.txt --user

if [ $? -eq 0 ]; then
    echo "依赖安装完成！"
    echo ""
    echo "运行数据库连接测试..."
    python3 test_db_connection.py
else
    echo "依赖安装失败！"
    exit 1
fi