setup_db.ps1

Write-Host "=====================================" -ForegroundColor Cyan
Write-Host "  Database Initialization" -ForegroundColor Cyan
Write-Host "=====================================" -ForegroundColor Cyan
Write-Host ""

$mysqlPath = "C:\Program Files\MariaDB 12.0\bin\mysql.exe"
$sqlFile = "C:\smallurl\backend\init_db.sql"

if (-not (Test-Path $mysqlPath)) {
    Write-Host "Error: MySQL client not found at $mysqlPath" -ForegroundColor Red
    exit 1
}

if (-not (Test-Path $sqlFile)) {
    Write-Host "Error: SQL file not found at $sqlFile" -ForegroundColor Red
    exit 1
}

Write-Host "Initializing database..." -ForegroundColor Yellow
Write-Host "Please enter your MySQL root password when prompted." -ForegroundColor Green
Write-Host ""

& $mysqlPath -u root -p -e "source $sqlFile"

if ($LASTEXITCODE -eq 0) {
    Write-Host ""
    Write-Host "Database initialized successfully!" -ForegroundColor Green
} else {
    Write-Host ""
    Write-Host "Database initialization failed. Please check your password and try again." -ForegroundColor Red
}