private void PrepareDatabase()
{
var ct = CancellationToken.None;
using (var connection = new OracleConnection(ConnectionString))
using (var context = new MigratorTestContext(connection))
{
var manager = new OracleMigrationManager <MigratorTestContext>(
context, new DefaultNamingNormalizer <MigratorTestContext>(), LoggingManager.LoggerFactory);
manager.PrepareDatabaseAsync(ct)
.ConfigureAwait(false)
.GetAwaiter()
.GetResult();
string migrationId;
string className;
MigrationsTestHelper.GenerateMigrationInfo(
DateTimeOffset.UtcNow, out migrationId, out className);
// Existing static migration
manager.AddMigrationAsync(migrationId, className, null, ct)
.ConfigureAwait(false)
.GetAwaiter()
.GetResult();
}
}
public ExistingDatabaseFixture() : base(
"DATA SOURCE=LocalOracle/xe;USER ID=MIGRATORMASTER;PASSWORD=MIGRATORMASTER;VALIDATE CONNECTION=TRUE;",
"DATA SOURCE=LocalOracle/xe;USER ID=MIGRATORTEST;PASSWORD=MIGRATORTEST;VALIDATE CONNECTION=TRUE;",
"MIGRATORTEST", "MIGRATORTEST")
{
PrepareDatabase();
Context = new MigratorTestContext(Connection);
Manager = new OracleMigrationManager <MigratorTestContext>(
Context, new DefaultNamingNormalizer <MigratorTestContext>(), LoggingManager.LoggerFactory);
}
/// <inheritdoc />
protected override void Dispose(bool disposing)
{
base.Dispose(disposing);
if (disposing)
{
Context?.Dispose();
}
Manager = null;
Context = null;
}
public void GivenANewManagerWhenPassingNullParametersThenArgumentNullExceptionMustBeThrown()
{
OracleMigrationManager <OracleMigratorTestContext> manager;
Assert.Throws <ArgumentNullException>(() =>
{
manager = new OracleMigrationManager <OracleMigratorTestContext>(null, LoggingManager.LoggerFactory);
Assert.NotNull(manager);
});
manager = new OracleMigrationManager <OracleMigratorTestContext>(_fixture.Context);
Assert.NotNull(manager);
}
public async Task GivenAnEmptyDatabaseWhenPreparingForMigrationsThenATableMustBeCreated()
{
var ct = CancellationToken.None;
var manager = new OracleMigrationManager<OracleMigratorTestContext>(
_fixture.Context, LoggingManager.LoggerFactory);
await manager.PrepareDatabaseAsync(ct);
var tableId = await _fixture.Context.RunAsync(async () =>
await _fixture.Context.QuerySingleAsync<long>(@"
SELECT COUNT(*) TOTAL
FROM(
SELECT
-- making sure all columns exist
CONTEXT_NAME, MIGRATION_ID, CLASS_NAME, DESCRIPTION, APPLIED_ON
FROM MIGRATORTESTEMPTY.DB_MIGRATOR_HISTORY
)", ct: ct), true, ct);
Assert.Equal(0L, tableId);
}
public void GivenANewManagerWhenPassingNullParametersThenArgumentNullExceptionMustBeThrown()
{
Assert.Throws <ArgumentNullException>(() =>
{
var manager = new OracleMigrationManager <MigratorTestContext>(
null, new DefaultNamingNormalizer <MigratorTestContext>(), LoggingManager.LoggerFactory);
Assert.NotNull(manager);
});
Assert.Throws <ArgumentNullException>(() =>
{
var manager = new OracleMigrationManager <MigratorTestContext>(
_fixture.Context, null, LoggingManager.LoggerFactory);
Assert.NotNull(manager);
});
Assert.Throws <ArgumentNullException>(() =>
{
var manager = new OracleMigrationManager <MigratorTestContext>(
_fixture.Context, new DefaultNamingNormalizer <MigratorTestContext>(), null);
Assert.NotNull(manager);
});
}
private void PrepareDatabase()
{
var ct = CancellationToken.None;
using (var context = new OracleMigratorTestContext(Options))
{
var manager = new OracleMigrationManager <OracleMigratorTestContext>(context, LoggingManager.LoggerFactory);
manager.PrepareDatabaseAsync(ct)
.ConfigureAwait(false)
.GetAwaiter()
.GetResult();
MigrationsTestHelper.GenerateMigrationInfo(
DateTimeOffset.UtcNow, out var migrationId, out var className);
// Existing static migration
manager.AddMigrationAsync(migrationId, className, null, ct)
.ConfigureAwait(false)
.GetAwaiter()
.GetResult();
}
}
