public void Execute_LoadTemporaryTableBasedOnCSV_TableHasMoreData()
{
//Create table
CreateTemporaryTable("Temporary", ConnectionStringReader.GetLocalSqlClient());
//Check how many elements are available in the table
var before = CountElementsInTable("Temporary", ConnectionStringReader.GetLocalSqlClient());
//Mock the commandXml
var info = Mock.Of <ILoadCommand>(
command => command.ConnectionString == ConnectionStringReader.GetLocalSqlClient() &&
command.TableName == "Temporary" &&
command.FileName == FileName
);
//Apply the test
var cmd = new BulkLoadCommand(info, new SqlConnection(ConnectionStringReader.GetLocalSqlClient()));
cmd.Execute();
//Execute Query on temporary table to knwo the new count of elements
var after = CountElementsInTable("Temporary", ConnectionStringReader.GetLocalSqlClient());
Assert.That(after, Is.GreaterThan(before));
}
public void Execute_LoadTemporaryTableBasedOnCSV_TableHasMoreData()
{
//Create table
CreateTemporaryTable("Temporary", ConnectionStringReader.GetLocalSqlClient());
//Check how many elements are available in the table
var before = CountElementsInTable("Temporary", ConnectionStringReader.GetLocalSqlClient());
//Mock the commandXml
var loadArgs = Mock.Of <ILoadCommandArgs>(
args => args.ConnectionString == ConnectionStringReader.GetLocalSqlClient() &&
args.TableName == new LiteralScalarResolver <string>("Temporary") &&
args.FileName == new LiteralScalarResolver <string>(FileName)
);
var command = new BulkLoadCommand(loadArgs);
command.Execute();
//Execute Query on temporary table to knwo the new count of elements
var after = CountElementsInTable("Temporary", ConnectionStringReader.GetLocalSqlClient());
Assert.That(after, Is.GreaterThan(before));
}
