22 lines
1.2 KiB
PowerShell
22 lines
1.2 KiB
PowerShell
# Fusionne les 25 migrations Flyway (dans legacy/) en un seul fichier V1__UnionFlow_Complete_Schema.sql
|
|
$migrationDir = Join-Path $PSScriptRoot "..\src\main\resources\db\migration"
|
|
$legacyDir = Join-Path (Split-Path $migrationDir -Parent) "legacy-migrations"
|
|
$sourceDir = if (Test-Path $legacyDir) { $legacyDir } else { $migrationDir }
|
|
$order = @('V1.2','V1.3','V1.4','V1.5','V1.6','V1.7','V2.0','V2.1','V2.2','V2.3','V2.4','V2.5','V2.6','V2.7','V2.8','V2.9','V2.10','V3.0','V3.1','V3.2','V3.3','V3.4','V3.5','V3.6','V3.7')
|
|
$out = @()
|
|
$out += '-- UnionFlow : schema complet (consolidation des migrations V1.2 a V3.7)'
|
|
$out += '-- Nouvelle base : ce script suffit. Bases existantes : voir README_CONSOLIDATION.md'
|
|
$out += ''
|
|
foreach ($ver in $order) {
|
|
$f = Get-ChildItem -Path $sourceDir -Filter "${ver}__*.sql" -ErrorAction SilentlyContinue | Select-Object -First 1
|
|
if ($f) {
|
|
$out += "-- ========== $($f.Name) =========="
|
|
$out += [System.IO.File]::ReadAllText($f.FullName)
|
|
$out += ''
|
|
}
|
|
}
|
|
$outPath = Join-Path $migrationDir "V1__UnionFlow_Complete_Schema.sql"
|
|
[System.IO.File]::WriteAllText($outPath, ($out -join "`r`n"))
|
|
$lines = (Get-Content $outPath | Measure-Object -Line).Lines
|
|
Write-Host "Ecrit $outPath ($lines lignes)"
|