# Restaura o backup mais recente do banco de dados

$BACKUP_DIR = "g:\Projetos\aggios-app\backups"

# Encontra o backup mais recente
$latestBackup = Get-ChildItem $BACKUP_DIR -Filter "aggios_backup_*.sql" | 
    Sort-Object LastWriteTime -Descending | 
    Select-Object -First 1

if (!$latestBackup) {
    Write-Host "Nenhum backup encontrado em $BACKUP_DIR" -ForegroundColor Red
    exit 1
}

Write-Host "Restaurando backup: $($latestBackup.Name)" -ForegroundColor Yellow
Write-Host "Data: $($latestBackup.LastWriteTime)" -ForegroundColor Cyan

# Confirma com o usuario
$confirm = Read-Host "Deseja restaurar este backup? (S/N)"
if ($confirm -ne "S" -and $confirm -ne "s") {
    Write-Host "Restauracao cancelada" -ForegroundColor Yellow
    exit 0
}

# Restaura o backup
Get-Content $latestBackup.FullName | docker exec -i aggios-postgres psql -U aggios aggios_db

if ($LASTEXITCODE -eq 0) {
    Write-Host "Backup restaurado com sucesso!" -ForegroundColor Green
} else {
    Write-Host "Erro ao restaurar backup!" -ForegroundColor Red
    exit 1
}