private static Schema GetSchema(Lib.Domain.SqlServer.SqlServer serverConfig, string schemaName)
{
var schema = new Schema {
Name = schemaName
};
serverConfig.SetSchemaConnections(schema);
return(schema);
}
private static Lib.Domain.SqlServer.SqlServer GetServerConfig()
{
var config = TestUtil.GetConfig();
var sqlServerConfig = config.GetSection("Host").GetSection("SqlServer");
var sqlServer = new Lib.Domain.SqlServer.SqlServer(
server: sqlServerConfig.GetValue <string>("Server"),
dbName: sqlServerConfig.GetValue <string>("DbName"),
userId: sqlServerConfig.GetValue <string>("userId"),
password: sqlServerConfig.GetValue <string>("password"));
return(sqlServer);
}
private static void UpdateMigrations <TFromMigrationAssembly>(Lib.Domain.SqlServer.SqlServer serverConfig, Schema schema)
{
serverConfig.CreateSchemas(true, schema);
DropAll(schema);
var serviceCollection = new ServiceCollection();
var serviceProvider = serviceCollection
.AddMigration(schema, typeof(TFromMigrationAssembly).Assembly)
.AddLogging(lb =>
{
lb.SetMinimumLevel(LogLevel.Trace);
lb.Services.AddSingleton <ILoggerProvider, MigrationUtil.NUnitLoggerProvider>();
})
.BuildServiceProvider(false);
RunMigrations(serviceProvider);
RunMigrations(serviceProvider);
}
