//[InlineData(SupportedDatabaseTypes.Oracle)]
public async Task DbProvider_ExampleRepository_Success(SupportedDatabaseTypes databaseType)
{
var overrideConfig = OverrideConfig.GetInMemoryOverrideConfig(databaseType);
overrideConfig.TryGetValue("database:schema", out var schema);
//overrideConfig.Add("database:schemaprefix:id", "EX");
//overrideConfig.Add("database:migration:schemaprefix:id", "EX");
var logFile = $"DbProvider_ExampleRepository_Success_{schema}_{databaseType}.sql";
var loglogFile = $"DbProvider_ExampleRepository_Success_{schema}_{databaseType}.log";
overrideConfig.Add("Logging:Migration:File:ShowSql", "false");
overrideConfig.Add("Logging:Migration:ShowElapsedTime", "True");
overrideConfig.Add("Logging:Migration:File", logFile);
overrideConfig.Add("Logging:Migration:Console:ShowSql", "false");
//overrideConfig.Add("Logging:Migration:Console", "True");
overrideConfig.Add("Logging:File", loglogFile);
var provider = MigrationBuilder.BuildMigration(databaseType, overrideConfig, assemblies: new [] { typeof(AddPersonTable).Assembly });
using var scope = provider.CreateScope();
try
{
var migrationRunner = scope.ServiceProvider.GetService <IMigrationRunner>();
var configuration = scope.ServiceProvider.GetService <IConfiguration>();
logFile = configuration.GetMigrationLogFile();
migrationRunner.DropSchema(scope.ServiceProvider.GetVersionTableMetaData());
migrationRunner.MigrateUp();
await DbExampleExecutor.ExecuteDbExample(databaseType, overrideConfig);
migrationRunner.DropSchema(scope.ServiceProvider.GetVersionTableMetaData());
}
catch (InvalidOperationException)
{
//
}
ShowLogFileContent(logFile);
}
public async Task DbProvider_ExampleRepository_WithDbProviderFactory_Success(SupportedDatabaseTypes databaseType)
{
var overrideConfig = OverrideConfig.GetInMemoryOverrideConfig(databaseType);
await DbExampleExecutor.ExecuteDbExample(databaseType, true, overrideConfig);
}