public void TestNullScrubOnTableWithNoCharacterFields()
{
const String tableName = "IN_UNILK";
const String sqlConnStr = "Data Source=(local);Initial Catalog=NoRows_22_000211;Integrated Security=True";
ITableProcessor tp = new NullCharacterScrubber();
tp.Process(LaptopHostConnectionString, tableName, sqlConnStr, tableName);
}
public void TestNullCharacterScrubber()
{
// Make sure there are rows
String baseCmdStr = "SELECT COUNT(*) FROM " + GetQualifiedTableName() + " WHERE CHARINDEX(CHAR(0),CharFld) {0} 0";
String hasNullsCmdStr = String.Format(baseCmdStr, ">");
String noNullsCmdStr = String.Format(baseCmdStr, "=");
Assert.IsTrue(GetRowCount(hasNullsCmdStr) > 0);
Assert.IsTrue(GetRowCount(noNullsCmdStr) > 0);
ITableProcessor tp = new NullCharacterScrubber();
tp.Process(null, null, GetConnectionString(), TableName);
Assert.IsTrue(GetRowCount(hasNullsCmdStr) == 0);
}
