public async Task Executes_migration_commands_with_transaction_suppressed_outside_of_transaction(bool async)
{
var fakeConnection = CreateConnection();
var commandList = new List<MigrationCommand>
{
new MigrationCommand(CreateRelationalCommand(), transactionSuppressed: true),
new MigrationCommand(CreateRelationalCommand(), transactionSuppressed: true)
};
var migrationCommandExecutor = new MigrationCommandExecutor();
if (async)
{
await migrationCommandExecutor.ExecuteNonQueryAsync(commandList, fakeConnection);
}
else
{
migrationCommandExecutor.ExecuteNonQuery(commandList, fakeConnection);
}
Assert.Equal(1, fakeConnection.DbConnections.Count);
Assert.Equal(1, fakeConnection.DbConnections[0].OpenCount);
Assert.Equal(1, fakeConnection.DbConnections[0].CloseCount);
Assert.Equal(0, fakeConnection.DbConnections[0].DbTransactions.Count);
Assert.Equal(2, fakeConnection.DbConnections[0].DbCommands.Count);
Assert.Null(fakeConnection.DbConnections[0].DbCommands[0].Transaction);
Assert.Null(fakeConnection.DbConnections[0].DbCommands[1].Transaction);
}
public async Task Executes_migtration_commands_in_same_transaction(bool async)
{
var fakeConnection = CreateConnection();
var commandList = new List<MigrationCommand>
{
new MigrationCommand(CreateRelationalCommand()),
new MigrationCommand(CreateRelationalCommand())
};
var migrationCommandExecutor = new MigrationCommandExecutor();
if (async)
{
await migrationCommandExecutor.ExecuteNonQueryAsync(commandList, fakeConnection);
}
else
{
migrationCommandExecutor.ExecuteNonQuery(commandList, fakeConnection);
}
Assert.Equal(1, fakeConnection.DbConnections.Count);
Assert.Equal(1, fakeConnection.DbConnections[0].OpenCount);
Assert.Equal(1, fakeConnection.DbConnections[0].CloseCount);
Assert.Equal(1, fakeConnection.DbConnections[0].DbTransactions.Count);
Assert.Equal(1, fakeConnection.DbConnections[0].DbTransactions[0].CommitCount);
Assert.Equal(0, fakeConnection.DbConnections[0].DbTransactions[0].RollbackCount);
Assert.Equal(2, fakeConnection.DbConnections[0].DbCommands.Count);
Assert.Same(
fakeConnection.DbConnections[0].DbTransactions[0],
fakeConnection.DbConnections[0].DbCommands[0].Transaction);
Assert.Same(
fakeConnection.DbConnections[0].DbTransactions[0],
fakeConnection.DbConnections[0].DbCommands[1].Transaction);
}
public async Task Disposes_transaction_on_exception(bool async)
{
var fakeDbConnection =
new FakeDbConnection(
ConnectionString,
new FakeCommandExecutor(
executeNonQuery: c => { throw new InvalidOperationException(); },
executeNonQueryAsync: (c, ct) => { throw new InvalidOperationException(); }));
var fakeConnection =
CreateConnection(
CreateOptions(
new FakeRelationalOptionsExtension
{
Connection = fakeDbConnection
}));
var commandList = new List<MigrationCommand>
{
new MigrationCommand(CreateRelationalCommand())
};
var migrationCommandExecutor = new MigrationCommandExecutor();
if (async)
{
await Assert.ThrowsAsync<InvalidOperationException>(async ()
=> await migrationCommandExecutor.ExecuteNonQueryAsync(commandList, fakeConnection));
}
else
{
Assert.Throws<InvalidOperationException>(()
=> migrationCommandExecutor.ExecuteNonQuery(commandList, fakeConnection));
}
Assert.Equal(1, fakeDbConnection.OpenCount);
Assert.Equal(1, fakeDbConnection.CloseCount);
Assert.Equal(1, fakeDbConnection.DbTransactions.Count);
Assert.Equal(1, fakeDbConnection.DbTransactions[0].DisposeCount);
Assert.Equal(0, fakeDbConnection.DbTransactions[0].CommitCount);
Assert.Equal(0, fakeDbConnection.DbTransactions[0].RollbackCount);
}
public async Task Executes_commands_in_order_regardless_of_transaction_suppression(bool async)
{
var fakeConnection = CreateConnection();
var commandList = new List<MigrationCommand>
{
new MigrationCommand(CreateRelationalCommand(commandText: "First")),
new MigrationCommand(CreateRelationalCommand(commandText: "Second"), transactionSuppressed: true),
new MigrationCommand(CreateRelationalCommand(commandText: "Third"))
};
var migrationCommandExecutor = new MigrationCommandExecutor();
if (async)
{
await migrationCommandExecutor.ExecuteNonQueryAsync(commandList, fakeConnection);
}
else
{
migrationCommandExecutor.ExecuteNonQuery(commandList, fakeConnection);
}
Assert.Equal(1, fakeConnection.DbConnections.Count);
Assert.Equal(1, fakeConnection.DbConnections[0].OpenCount);
Assert.Equal(1, fakeConnection.DbConnections[0].CloseCount);
Assert.Equal(2, fakeConnection.DbConnections[0].DbTransactions.Count);
Assert.Equal(1, fakeConnection.DbConnections[0].DbTransactions[0].CommitCount);
Assert.Equal(0, fakeConnection.DbConnections[0].DbTransactions[0].RollbackCount);
Assert.Equal(1, fakeConnection.DbConnections[0].DbTransactions[1].CommitCount);
Assert.Equal(0, fakeConnection.DbConnections[0].DbTransactions[1].RollbackCount);
Assert.Equal(3, fakeConnection.DbConnections[0].DbCommands.Count);
var command = fakeConnection.DbConnections[0].DbCommands[0];
Assert.Same(
fakeConnection.DbConnections[0].DbTransactions[0],
command.Transaction);
Assert.Equal(
"First",
command.CommandText);
command = fakeConnection.DbConnections[0].DbCommands[1];
Assert.Null(command.Transaction);
Assert.Equal(
"Second",
command.CommandText);
command = fakeConnection.DbConnections[0].DbCommands[2];
Assert.Same(
fakeConnection.DbConnections[0].DbTransactions[1],
command.Transaction);
Assert.Equal(
"Third",
command.CommandText);
}
public async Task Begins_new_transaction_when_transaction_nolonger_suppressed(bool async)
{
var fakeConnection = CreateConnection();
var commandList = new List<MigrationCommand>
{
new MigrationCommand(CreateRelationalCommand(), transactionSuppressed: true),
new MigrationCommand(CreateRelationalCommand())
};
var migrationCommandExecutor = new MigrationCommandExecutor();
if (async)
{
await migrationCommandExecutor.ExecuteNonQueryAsync(commandList, fakeConnection);
}
else
{
migrationCommandExecutor.ExecuteNonQuery(commandList, fakeConnection);
}
Assert.Equal(1, fakeConnection.DbConnections.Count);
Assert.Equal(1, fakeConnection.DbConnections[0].OpenCount);
Assert.Equal(1, fakeConnection.DbConnections[0].CloseCount);
Assert.Equal(1, fakeConnection.DbConnections[0].DbTransactions.Count);
Assert.Equal(1, fakeConnection.DbConnections[0].DbTransactions[0].CommitCount);
Assert.Equal(0, fakeConnection.DbConnections[0].DbTransactions[0].RollbackCount);
Assert.Equal(2, fakeConnection.DbConnections[0].DbCommands.Count);
Assert.Null(
fakeConnection.DbConnections[0].DbCommands[0].Transaction);
Assert.Same(
fakeConnection.DbConnections[0].DbTransactions[0],
fakeConnection.DbConnections[0].DbCommands[1].Transaction);
}