public void TestNumericScrubProcessorOnLargeTable()
{
const String tableName = "DP_CHRVL";
const String connStr = @"Provider=VFPOLEDB.1;Data Source=I:\Kohler\HOSTDEMO";
NumericScrubProcessor tp = new NumericScrubProcessor();
tp.Process(connStr, tableName, null, null);
foreach (String cmdStr in tp.CommandStrings)
{
TestContext.WriteLine(cmdStr);
}
TestContext.WriteLine("Here boss");
}
public void TestNumericScrubProcessor()
{
/*
*
* Here is the VFP code to generate test data
*
* CLOSE DATABASES
* USE RS_POLCY Exclusive
* ZAP
* FOR lni = 1 TO 3
* LOCAL lcI
* lcI = ALLTRIM(STR(lni))
* SCATTER NAME loRec BLANK
* lc = 'loRec.Advance{1} = 1000'
* lc = STRTRAN(lc,'{1}',lci)
* &lc
* lc = 'loRec.TimeUnit{1} = 1000'
* lc = STRTRAN(lc,'{1}',lcI)
* &lc
* lc = 'loRec.Percent{1} = 100.0'
* lc = STRTRAN(lc,'{1}',lcI)
* &lc
* INSERT INTO RS_POLCY FROM NAME loRec
* NEXT
*
* LIST
* USE
* RETURN
*/
NumericScrubProcessor nsp = new NumericScrubProcessor(new ConstantBatchSizeProvider(1));
nsp.Process(LaptopHostConnectionString, "RS_POLCY", null, null);
foreach (String cmdStr in nsp.CommandStrings)
{
TestContext.WriteLine(cmdStr);
}
TestContext.WriteLine("Here boss");
}