2026-05-15 15:26:46 +08:00
|
|
|
param(
|
|
|
|
|
[string]$Name,
|
2026-05-20 16:40:57 +08:00
|
|
|
[ValidateSet("SQLite", "SqlServer", "PostgreSQL", "MySQL", "All")]
|
|
|
|
|
[string]$Provider = "All",
|
2026-05-15 15:26:46 +08:00
|
|
|
[string]$Project = "Avalonia-EFCore/Avalonia-EFCore.csproj",
|
|
|
|
|
[string]$StartupProject = "Avalonia-API/Avalonia-API.csproj",
|
|
|
|
|
[string]$OutputDir = "Migrations"
|
|
|
|
|
)
|
|
|
|
|
|
|
|
|
|
$ErrorActionPreference = "Stop"
|
|
|
|
|
|
|
|
|
|
$repoRoot = Resolve-Path (Join-Path $PSScriptRoot "..")
|
|
|
|
|
Set-Location $repoRoot
|
|
|
|
|
|
|
|
|
|
if ([string]::IsNullOrWhiteSpace($Name)) {
|
|
|
|
|
$Name = "AutoMigration_{0}" -f (Get-Date -Format "yyyyMMddHHmmss")
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
Write-Host "Restoring local dotnet tools..."
|
|
|
|
|
dotnet tool restore
|
|
|
|
|
if ($LASTEXITCODE -ne 0) {
|
|
|
|
|
throw "dotnet tool restore failed."
|
|
|
|
|
}
|
|
|
|
|
|
2026-05-20 16:40:57 +08:00
|
|
|
function Get-ContextName([string]$providerName) {
|
|
|
|
|
switch ($providerName) {
|
|
|
|
|
"SQLite" { return "SqliteAppDataContext" }
|
|
|
|
|
"SqlServer" { return "SqlServerAppDataContext" }
|
|
|
|
|
"PostgreSQL" { return "PostgreSqlAppDataContext" }
|
|
|
|
|
"MySQL" { return "MySqlAppDataContext" }
|
|
|
|
|
default { throw "Unsupported provider '$providerName'." }
|
|
|
|
|
}
|
2026-05-15 15:26:46 +08:00
|
|
|
}
|
|
|
|
|
|
2026-05-20 16:40:57 +08:00
|
|
|
function Add-ProviderMigration([string]$providerName) {
|
|
|
|
|
$context = Get-ContextName $providerName
|
|
|
|
|
$providerOutputDir = Join-Path $OutputDir $providerName
|
2026-05-15 15:26:46 +08:00
|
|
|
|
2026-05-20 16:40:57 +08:00
|
|
|
Write-Host "Generating migration '$Name' for $providerName..."
|
|
|
|
|
dotnet tool run dotnet-ef migrations add $Name `
|
2026-05-15 15:26:46 +08:00
|
|
|
--project $Project `
|
|
|
|
|
--startup-project $StartupProject `
|
2026-05-20 16:40:57 +08:00
|
|
|
--context $context `
|
|
|
|
|
--output-dir $providerOutputDir
|
2026-05-15 15:26:46 +08:00
|
|
|
if ($LASTEXITCODE -ne 0) {
|
2026-05-20 16:40:57 +08:00
|
|
|
throw "dotnet ef migrations add failed for $providerName."
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
$migrationDir = Join-Path (Split-Path $Project -Parent) $providerOutputDir
|
|
|
|
|
$migrationFile = Get-ChildItem $migrationDir -Filter "*_$Name.cs" |
|
|
|
|
|
Where-Object { $_.Name -notlike "*.Designer.cs" } |
|
|
|
|
|
Sort-Object LastWriteTime -Descending |
|
|
|
|
|
Select-Object -First 1
|
|
|
|
|
|
|
|
|
|
if ($null -eq $migrationFile) {
|
|
|
|
|
throw "Migration file was not found for '$Name' ($providerName)."
|
2026-05-15 15:26:46 +08:00
|
|
|
}
|
2026-05-20 16:40:57 +08:00
|
|
|
|
|
|
|
|
$content = Get-Content $migrationFile.FullName -Raw
|
|
|
|
|
$upMatch = [regex]::Match($content, "protected override void Up\(MigrationBuilder migrationBuilder\)\s*\{(?<body>.*?)\n\s*\}", "Singleline")
|
|
|
|
|
$downMatch = [regex]::Match($content, "protected override void Down\(MigrationBuilder migrationBuilder\)\s*\{(?<body>.*?)\n\s*\}", "Singleline")
|
|
|
|
|
|
|
|
|
|
$upBody = if ($upMatch.Success) { $upMatch.Groups["body"].Value.Trim() } else { "" }
|
|
|
|
|
$downBody = if ($downMatch.Success) { $downMatch.Groups["body"].Value.Trim() } else { "" }
|
|
|
|
|
|
|
|
|
|
if ([string]::IsNullOrWhiteSpace($upBody) -and [string]::IsNullOrWhiteSpace($downBody)) {
|
|
|
|
|
Write-Host "No model changes were detected for $providerName. Removing empty migration '$Name'..."
|
|
|
|
|
dotnet tool run dotnet-ef migrations remove --force `
|
|
|
|
|
--project $Project `
|
|
|
|
|
--startup-project $StartupProject `
|
|
|
|
|
--context $context
|
|
|
|
|
if ($LASTEXITCODE -ne 0) {
|
|
|
|
|
throw "dotnet ef migrations remove failed for $providerName."
|
|
|
|
|
}
|
|
|
|
|
return
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
Write-Host "Migration generated for ${providerName}:"
|
|
|
|
|
Write-Host " $($migrationFile.FullName)"
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
$providers = if ($Provider -eq "All") {
|
|
|
|
|
@("SQLite", "SqlServer", "PostgreSQL", "MySQL")
|
|
|
|
|
} else {
|
|
|
|
|
@($Provider)
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
foreach ($providerName in $providers) {
|
|
|
|
|
Add-ProviderMigration $providerName
|
2026-05-15 15:26:46 +08:00
|
|
|
}
|
|
|
|
|
|
2026-05-20 16:40:57 +08:00
|
|
|
Write-Host "Review the migration files, then start the app. Startup will apply the migration set matching DatabaseConfiguration.Provider."
|
