private async Task <IDbConnection> EnsureDbHasBeenInitialized(IMigrationContext context)
{
var db = ((PostgreSqlMigrationContext)context).ConnectionProvider.Default();
await PostgreSqlSchemaCreator.CreateSchemaIfNotExists(context);
return(db);
}
public async Task MigrationRunner_PicksUpNonCompletedStepsFromPreviousMigrations()
{
await DropMigrationInfoTable();
await PrepareCounterTable(new List <Counter> {
new Counter {
Id = 999, CounterValue = 12
}
});
var db = GetDb();
var services = new ServiceCollection();
var provider = new PostgreSqlConnectionProvider();
provider.Add("yolo", db, true);
var contextFactory = new PostgreSqlMigrationContextFactory(provider);
await PostgreSqlSchemaCreator.CreateSchemaIfNotExists(contextFactory.GetContext());
var runner = new MigrationRunner(
new LoggerFactory().CreateLogger <MigrationRunner>(),
new ServiceProviderRapidContainerAdapter(services.BuildServiceProvider()),
new MigrationEnvironment("staging"),
A.Fake <IDistributedAppLockProvider>(),
contextFactory,
new ReflectionMigrationFinder(new List <Assembly> {
typeof(MigrationTests).GetAssembly()
}),
new PostgreSqlMigrationStorage()
);
await InsertMigrationInfo(new MigrationInfo
{
Id = "1",
Name = "Migration01",
StepsCompleted = new List <string> {
"Add at column"
}
});
await runner.UpgradeAsync();
// assert all migrations are marked as complete
var migrationInfos = await GetAllMigrationInfo();
Assert.Contains(migrationInfos, x => x.Name == nameof(Migration01) && x.MigrationCompleted);
Assert.Contains(migrationInfos, x => x.Name == nameof(Migration02) && x.MigrationCompleted);
// check the state of the db
var counter999 = await db.QuerySingleAsync <Counter>("select * from __Counter where Id = 999");
Assert.Equal("sample default value", counter999.Description);
await DropCounterTable();
}
