Upgradier.DatabaseEngines.MySql
0.0.0-alpha.0.7
dotnet add package Upgradier.DatabaseEngines.MySql --version 0.0.0-alpha.0.7
NuGet\Install-Package Upgradier.DatabaseEngines.MySql -Version 0.0.0-alpha.0.7
<PackageReference Include="Upgradier.DatabaseEngines.MySql" Version="0.0.0-alpha.0.7" />
<PackageVersion Include="Upgradier.DatabaseEngines.MySql" Version="0.0.0-alpha.0.7" />
<PackageReference Include="Upgradier.DatabaseEngines.MySql" />
paket add Upgradier.DatabaseEngines.MySql --version 0.0.0-alpha.0.7
#r "nuget: Upgradier.DatabaseEngines.MySql, 0.0.0-alpha.0.7"
#:package Upgradier.DatabaseEngines.MySql@0.0.0-alpha.0.7
#addin nuget:?package=Upgradier.DatabaseEngines.MySql&version=0.0.0-alpha.0.7&prerelease
#tool nuget:?package=Upgradier.DatabaseEngines.MySql&version=0.0.0-alpha.0.7&prerelease
Upgradier

A minimalist approach for updating multiple databases concurrently to a version based in conventions.
Declare a place to store de Source databases in json format. You can mix databases of different providers (actually SqlServer, MySql and PostgreSql).
Store batches in .sql files on Disk, Web Server, Aws S3, Azure Blob, or custom IBatchStrategy.
Optionally use a cache implementing IBatchCacheManager to not hit the server when each batch is requested.
Prerequisites
Quick start
- Install Upgradier.Core
- Install the required database engines:
- Install aditional batch strategies:
Create UpdateBuilder with options:
//Microsoft.Extensions.Logging.ILogger logger ...
BlobContainerClient blobContainerClient = ... // Optional use Azure
UpdateBuilder updateBuilder = new UpdateBuilder()
.WithSourceProvider(options => new FileSourceProvider("c:\\my_files\\sources.json", options.Logger, options.Environment))
.WithFileBatchStrategy("c:\\my_files\\batches")
.WithCacheManager(options => new FileBatchCacheManager("c:\\my_files\\cache", options.Logger, options.Environment))
.WithAzureBlobBatchStrategy(blobContainerClient)
.AddSqlServerEngine()
.AddMySqlServerEngine()
.AddPostgreSqlServerEngine()
.WithLogger(logger)
.WithEnvironment("Dev");
Build to create the UpdateManager:
UpdateManager updateManager = updateBuilder.Build();
Update the databases:
IEnumerable<UpdateResult> updateResults = await updateManager.UpdateAsync();
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net8.0
- Microsoft.EntityFrameworkCore (>= 8.0.0)
- Microsoft.EntityFrameworkCore.Relational (>= 8.0.0)
- Pomelo.EntityFrameworkCore.MySql (>= 8.0.0-beta.2)
- Upgradier.Core (>= 0.0.0-alpha.0.7)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 0.0.0-alpha.0.7 | 164 | 12/10/2023 |
| 0.0.0-alpha.0.5 | 128 | 12/10/2023 |
| 0.0.0-alpha.0.4 | 116 | 12/10/2023 |
| 0.0.0-alpha.0.3 | 120 | 12/10/2023 |
| 0.0.0-alpha.0.2 | 127 | 12/9/2023 |
| 0.0.0-alpha.0.1 | 141 | 12/11/2023 |
