public void SetUp()
{
#if NET452
ObjectApproval.ObjectApprover.JsonSerializer.DefaultValueHandling = Newtonsoft.Json.DefaultValueHandling.Include;
#endif
FixCurrentDirectory();
using (var connection = MsSqlConnectionBuilder.Build())
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = @"
if not exists (
select *
from sys.schemas
where name = 'schema_name')
exec('create schema schema_name');";
command.ExecuteNonQuery();
}
}
using (var connection = PostgreSqlConnectionBuilder.Build())
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = @"create schema if not exists ""SchemaName"";";
command.ExecuteNonQuery();
}
}
}
public void SetUp()
{
using (var connection = MsSqlConnectionBuilder.Build())
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = @"
if not exists (
select *
from sys.schemas
where name = 'schema_name')
exec('create schema schema_name');";
command.ExecuteNonQuery();
}
}
using (var connection = PostgreSqlConnectionBuilder.Build())
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = @"create schema if not exists ""SchemaName"";";
command.ExecuteNonQuery();
}
}
}
public async Task Should_remove_old_property_after_phase_three()
{
var dialect = BuildSqlDialect.PostgreSql;
var sagaPhase1 = RuntimeSagaDefinitionReader.GetSagaDefinition(typeof(Phase1Saga), dialect);
var sagaPhase2 = RuntimeSagaDefinitionReader.GetSagaDefinition(typeof(Phase2Saga), dialect);
var sagaPhase3 = RuntimeSagaDefinitionReader.GetSagaDefinition(typeof(Phase3Saga), dialect);
using (var connection = PostgreSqlConnectionBuilder.Build())
{
await connection.OpenAsync().ConfigureAwait(false);
connection.ExecuteCommand(SagaScriptBuilder.BuildDropScript(sagaPhase1, dialect), "");
connection.ExecuteCommand(SagaScriptBuilder.BuildCreateScript(sagaPhase1, dialect), "");
var phase1Schema = GetSchema(connection);
connection.ExecuteCommand(SagaScriptBuilder.BuildCreateScript(sagaPhase2, dialect), "");
var phase2Schema = GetSchema(connection);
connection.ExecuteCommand(SagaScriptBuilder.BuildCreateScript(sagaPhase3, dialect), "");
var phase3Schema = GetSchema(connection);
CollectionAssert.Contains(phase1Schema, "Correlation_OrderNumber");
CollectionAssert.DoesNotContain(phase1Schema, "Correlation_OrderId");
CollectionAssert.Contains(phase2Schema, "Correlation_OrderNumber");
CollectionAssert.Contains(phase2Schema, "Correlation_OrderId");
CollectionAssert.DoesNotContain(phase3Schema, "Correlation_OrderNumber");
CollectionAssert.Contains(phase3Schema, "Correlation_OrderId");
}
}
protected override Func <string, DbConnection> GetConnection()
{
return(x =>
{
var connection = PostgreSqlConnectionBuilder.Build();
return connection;
});
}
public void Setup()
{
using (var connection = PostgreSqlConnectionBuilder.Build())
{
connection.Open();
using (var command = connection.CreateCommand())
{
command.CommandText = @"create schema if not exists ""SchemaName"";";
command.ExecuteNonQuery();
}
}
}
protected override Func <string, DbConnection> GetConnection()
{
return(x => PostgreSqlConnectionBuilder.Build());
}
