MustMail/CreateMigrations.ps1 at main · bechoforest/MustMail · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
# Ask user for starting migration
$fromMigration = Read-Host "Enter the FROM migration (leave blank for initial)"
$newMigration = Read-Host "Enter the NEW migration name (leave blank for initial)"

# PostgreSQL
Write-Host "Generating Postgres migration script..."

$env:Db_Provider = "Postgres"


if ([string]::IsNullOrWhiteSpace($fromMigration)) {
    dotnet ef migrations add Initial --project MustMail.Migrations.Postgres --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet ef migrations script `
        -o "MustMail.Migrations.Postgres\Scripts\Initial.sql" --project MustMail.Migrations.Postgres --startup-project MustMail.App
} else {
    dotnet ef migrations add $newMigration --project MustMail.Migrations.Postgres --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet build
    Start-Sleep -Seconds 5
    dotnet ef migrations script $fromMigration $newMigration `
        -o "MustMail.Migrations.Postgres\Scripts\$newMigration.sql" --project MustMail.Migrations.Postgres --startup-project MustMail.App
}
# Sqlite
Write-Host "Generating Sqlite migration script..."

$env:Db_Provider = "Sqlite"

if ([string]::IsNullOrWhiteSpace($fromMigration)) {
    dotnet ef migrations add Initial --project MustMail.Migrations.Sqlite --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet ef migrations script `
        -o "MustMail.Migrations.Sqlite\Scripts\Initial.sql" --project MustMail.Migrations.Sqlite --startup-project MustMail.App
} else {
    dotnet ef migrations add $newMigration --project MustMail.Migrations.Sqlite --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet build
    Start-Sleep -Seconds 5
    dotnet ef migrations script $fromMigration $newMigration `
        -o "MustMail.Migrations.Sqlite\Scripts\$newMigration.sql" --project MustMail.Migrations.Sqlite --startup-project MustMail.App
}

# MySQL
Write-Host "Generating MySQL migration script..."

$env:Db_Provider = "MySQL"

if ([string]::IsNullOrWhiteSpace($fromMigration)) {
    dotnet ef migrations add Initial --project MustMail.Migrations.MySQL --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet ef migrations script `
        -o "MustMail.Migrations.MySQL\Scripts\Initial.sql" --project MustMail.Migrations.MySQL --startup-project MustMail.App
} else {
    dotnet ef migrations add $newMigration --project MustMail.Migrations.MySQL --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet build
    Start-Sleep -Seconds 5
    dotnet ef migrations script $fromMigration $newMigration `
        -o "MustMail.Migrations.MySQL\Scripts\$newMigration.sql" --project MustMail.Migrations.MySQL --startup-project MustMail.App
}

# SQL Server
Write-Host "Generating SQL Server migration script..."

$env:Db_Provider = "SqlServer"

if ([string]::IsNullOrWhiteSpace($fromMigration)) {
    dotnet ef migrations add Initial --project MustMail.Migrations.SqlServer --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet ef migrations script `
        -o "MustMail.Migrations.SqlServer\Scripts\Initial.sql" --project MustMail.Migrations.SqlServer --startup-project MustMail.App
} else {
    dotnet ef migrations add $newMigration --project MustMail.Migrations.SqlServer --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet build
    Start-Sleep -Seconds 5
    dotnet ef migrations script $fromMigration $newMigration `
        -o "MustMail.Migrations.SqlServer\Scripts\$newMigration.sql" --project MustMail.Migrations.SqlServer --startup-project MustMail.App
}
# Azure SQL
Write-Host "Generating Azure SQL migration script..."

$env:Db_Provider = "AzureSql"

if ([string]::IsNullOrWhiteSpace($fromMigration)) {
    dotnet ef migrations add Initial --project MustMail.Migrations.AzureSql --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet ef migrations script `
        -o "MustMail.Migrations.AzureSql\Scripts\Initial.sql" --project MustMail.Migrations.AzureSql --startup-project MustMail.App
} else {
    dotnet ef migrations add $newMigration --project MustMail.Migrations.AzureSql --startup-project MustMail.App
    Start-Sleep -Seconds 5
    dotnet build
    Start-Sleep -Seconds 5
    dotnet ef migrations script $fromMigration $newMigration `
        -o "MustMail.Migrations.AzureSql\Scripts\$newMigration.sql" --project MustMail.Migrations.AzureSql --startup-project MustMail.App
}

Write-Host "Done!"