public void TearDown()
{
foreach (var mockedCommand in MockedCommands)
{
mockedCommand.VerifyNoOtherCalls();
}
MockedDbProviderFactory.VerifyNoOtherCalls();
}
public void TestOneCommandForMultipleLines()
{
var command = "SELECT 1\nSELECT 2";
using (var processor = CreateProcessor())
{
processor.Execute(command);
}
MockedDbProviderFactory.Verify(factory => factory.CreateConnection());
foreach (var mockedCommand in MockedCommands)
{
MockedDbProviderFactory.Verify(factory => factory.CreateCommand());
mockedCommand.VerifySet(cmd => cmd.Connection = MockedConnection.Object);
mockedCommand.VerifySet(cmd => cmd.CommandText = command);
mockedCommand.Verify(cmd => cmd.ExecuteNonQuery());
mockedCommand.Protected().Verify("Dispose", Times.Exactly(1), ItExpr.IsAny <bool>());
}
MockedConnection.Protected().Verify("Dispose", Times.Exactly(1), ItExpr.IsAny <bool>());
}
public void TestThatTwoCommandsAreNotSeparatedByGoInString()
{
var command = "SELECT '\nGO\n'\nSELECT 2";
using (var processor = CreateProcessor())
{
processor.Execute(command);
}
MockedDbProviderFactory.Verify(factory => factory.CreateConnection());
foreach (var mockedCommand in MockedCommands)
{
MockedDbProviderFactory.Verify(factory => factory.CreateCommand());
mockedCommand.VerifySet(cmd => cmd.Connection = MockedConnection.Object);
mockedCommand.VerifySet(cmd => cmd.CommandText = command);
mockedCommand.Verify(cmd => cmd.ExecuteNonQuery());
mockedCommand.Protected().Verify("Dispose", Times.Exactly(1), ItExpr.IsAny <bool>());
}
MockedConnection.Protected().Verify("Dispose", Times.Exactly(1), ItExpr.IsAny <bool>());
}
public void Issue842()
{
var command = @"insert into MyTable (Id, Data)\nvalues (42, 'This is a list of games played by people\n\nDooM\nPokemon GO\nPotato-o-matic');";
using (var processor = CreateProcessor())
{
processor.Execute(command);
}
MockedDbProviderFactory.Verify(factory => factory.CreateConnection());
foreach (var mockedCommand in MockedCommands)
{
MockedDbProviderFactory.Verify(factory => factory.CreateCommand());
mockedCommand.VerifySet(cmd => cmd.Connection = MockedConnection.Object);
mockedCommand.VerifySet(cmd => cmd.CommandText = command);
mockedCommand.Verify(cmd => cmd.ExecuteNonQuery());
mockedCommand.Protected().Verify("Dispose", Times.Exactly(1), ItExpr.IsAny <bool>());
}
MockedConnection.Protected().Verify("Dispose", Times.Exactly(1), ItExpr.IsAny <bool>());
}
public void TestThatTwoCommandsGetSeparatedByGo()
{
using (var processor = CreateProcessor())
{
processor.Execute("SELECT 1\nGO\nSELECT 2");
}
MockedDbProviderFactory.Verify(factory => factory.CreateConnection());
for (int index = 0; index < MockedCommands.Count; index++)
{
var command = $"SELECT {index + 1}";
var mockedCommand = MockedCommands[index];
MockedDbProviderFactory.Verify(factory => factory.CreateCommand());
mockedCommand.VerifySet(cmd => cmd.Connection = MockedConnection.Object);
mockedCommand.VerifySet(cmd => cmd.CommandText = command);
mockedCommand.Verify(cmd => cmd.ExecuteNonQuery());
mockedCommand.Protected().Verify("Dispose", Times.Exactly(1), ItExpr.IsAny <bool>());
}
MockedConnection.Protected().Verify("Dispose", Times.Exactly(1), ItExpr.IsAny <bool>());
}
