public void TestDiBatchSizeProvider()
{
String connStr = Helper.GetConnectionString("Host");
IBatchSizeProvider bsp = new DiTableBatchSizeProvider(connStr);
TableBatchSizePair pair = GetTableBatchSizePair(">");
int actualBatchSize = bsp.GetBatchSize(pair.Table);
Assert.AreEqual(pair.BatchSize, actualBatchSize);
pair = GetTableBatchSizePair("=");
actualBatchSize = bsp.GetBatchSize(pair.Table);
Assert.AreEqual(0, actualBatchSize);
}
TableBatchSizePair GetTableBatchSizePair(String oper)
{
String connStr = Helper.GetConnectionString("Host");
IBatchSizeProvider bsp = new DiTableBatchSizeProvider(connStr);
String cmdStr = "SELECT TOP 1 Table,BatchSize FROM DITABLE WHERE BatchSize {0} 0 ORDER BY Table";
DataTable dt = Helper.GetOleDbDataTable(connStr, String.Format(cmdStr, oper));
DataRow row = dt.Rows[0];
return(new TableBatchSizePair()
{
Table = (String)row[0], BatchSize = (int)row[1]
});
}
public void TestDiBatchOrDefaultSizeProvider()
{
String connStr = Helper.GetConnectionString("Host");
IBatchSizeProvider testBsp = new DiTableOrDefaultBatchSizeProvider(connStr);
IBatchSizeProvider di = new DiTableBatchSizeProvider(connStr);
IBatchSizeProvider def = new DefaultBatchSizeProvider();
TableBatchSizePair pair = GetTableBatchSizePair(">");
Assert.AreEqual(testBsp.GetBatchSize(pair.Table), di.GetBatchSize(pair.Table));
pair = GetTableBatchSizePair("=");
Assert.AreEqual(testBsp.GetBatchSize(pair.Table), def.GetBatchSize(pair.Table));
Debug.WriteLine("here boss");
}
