public void TestBoundedCapacityIsWorking()
{
var connection = SqlConnection;
connection.FireTriggers = true;
SqlTask.ExecuteNonQuery(connection, "Create test table",
"CREATE TABLE test ( id INT NOT NULL );");
SqlTask.ExecuteNonQuery(connection, "Add wait trigger",
$@"CREATE TRIGGER testtrigger ON test
AFTER INSERT
AS
WAITFOR DELAY '00:00:0.500';");
var source = new MemorySource <string[]>()
{
MaxBufferSize = 2
};
for (int i = 0; i < 8; i++)
{
source.DataAsList.Add(new string[] { i.ToString() });
}
var dest = new DbDestination <string[]>(connection, "test", batchSize: 1)
{
MaxBufferSize = 1
};
source.LinkTo(dest);
var s = source.ExecuteAsync();
var d = dest.Completion;
int count = 1;
while (!d.IsCompleted)
{
Task.Delay(500).Wait();
if (count > 1 && count < 7)
{
Assert.True(source.ProgressCount > dest.ProgressCount);
}
if (count == 1)
{
Assert.True(source.ProgressCount <= 6);
}
count++;
}
Assert.Equal(8, dest.ProgressCount);
}