public void Setup()
{
using (var connection = OracleConnectionBuilder.Build())
{
connection.Open();
}
}
protected override Func <string, DbConnection> GetConnection()
{
return(x =>
{
var connection = OracleConnectionBuilder.Build();
return connection;
});
}
protected override Func <DbConnection> GetConnection()
{
return(() =>
{
var connection = OracleConnectionBuilder.Build();
connection.Open();
return connection;
});
}
public async Task Should_remove_old_property_after_phase_three()
{
var dialect = BuildSqlDialect.Oracle;
var sagaPhase1 = RuntimeSagaDefinitionReader.GetSagaDefinition(typeof(Phase1Saga), dialect);
var sagaPhase2 = RuntimeSagaDefinitionReader.GetSagaDefinition(typeof(Phase2Saga), dialect);
var sagaPhase3 = RuntimeSagaDefinitionReader.GetSagaDefinition(typeof(Phase3Saga), dialect);
string[] phase1Schema, phase2Schema, phase3Schema;
using (var connection = OracleConnectionBuilder.Build(disableMetadataPooling: true))
{
await connection.OpenAsync().ConfigureAwait(false);
connection.ExecuteCommand(SagaScriptBuilder.BuildDropScript(sagaPhase1, dialect), "");
connection.ExecuteCommand(SagaScriptBuilder.BuildCreateScript(sagaPhase1, dialect), "");
phase1Schema = GetSchema(connection);
connection.PurgeStatementCache();
}
using (var connection = OracleConnectionBuilder.Build(disableMetadataPooling: true))
{
await connection.OpenAsync().ConfigureAwait(false);
connection.ExecuteCommand(SagaScriptBuilder.BuildCreateScript(sagaPhase2, dialect), "");
phase2Schema = GetSchema(connection);
connection.PurgeStatementCache();
}
using (var connection = OracleConnectionBuilder.Build(disableMetadataPooling: true))
{
await connection.OpenAsync().ConfigureAwait(false);
connection.ExecuteCommand(SagaScriptBuilder.BuildCreateScript(sagaPhase3, dialect), "");
phase3Schema = GetSchema(connection);
connection.PurgeStatementCache();
}
CollectionAssert.Contains(phase1Schema, "CORR_ORDERNUMBER");
CollectionAssert.DoesNotContain(phase1Schema, "CORR_ORDERID");
CollectionAssert.Contains(phase2Schema, "CORR_ORDERNUMBER");
CollectionAssert.Contains(phase2Schema, "CORR_ORDERID");
CollectionAssert.DoesNotContain(phase3Schema, "CORR_ORDERNUMBER");
CollectionAssert.Contains(phase3Schema, "CORR_ORDERID");
}
/// <summary>
/// Gets the connection data.
/// </summary>
/// <returns>
/// The connection data
/// </returns>
public OracleConnectionData GetConnection()
{
int port;
OracleConnectionBuilder builder = new OracleConnectionBuilder()
{
ConnType = ConnectionType.Service_Name,
Password = this.passOracle.Password,
Username = this.tboUser.Text,
ServiceName = this.tboServiceName.Text,
Host = this.tboHost.Text,
PersistSecurity = false,
Port = int.TryParse(this.tboPort.Text, out port) ? port : 1521,
TimeOut = 10
};
return(builder.GetConnectionData());
}
public IEvolutionContext CreateContext(IDatabaseAuthenticationOptions dbAuthOptions)
{
if (dbAuthOptions.Type == DatabaseTypes.Oracle)
{
var connectionStringBuilder = new OracleConnectionBuilder()
{
UserName = dbAuthOptions.User,
Password = dbAuthOptions.Password,
Server = dbAuthOptions.Server,
Instance = dbAuthOptions.Instance,
Port = dbAuthOptions.Port
};
return(new OracleEvolutionContext(connectionStringBuilder.CreateConnectionString()));
}
else
{
throw new NotSupportedException("The type of database provided is not supported");
}
}
