public void CsvReaderV2_CreateDataTable_DataWithDupeColumnName_ReturnsValidData()
{
//Prep
var text = GetCsvStringDuplicateColumunName();
//Action
var dt = new DataTable();
bool pass = false;
try
{
dt = new CsvReaderV2().CreateDataTable(text);
if (dt.Columns.Contains("Address_3"))
{
pass = true;
}
}
catch
{
//do nothing
}
//Assert
Assert.IsTrue(pass);
}
public void CsvReaderV2MbctOnly_GetSoapNotes_Input_Returns()
{
//Prep
var dt = new DataTable();
dt.Columns.Add("ProgressNoteId", typeof(string));
dt.Columns.Add("EncryptedNote", typeof(string));
var row = dt.NewRow();
row[0] = "1";
row[1] = "{\"SerializedContentId\": \"123\", \"Subjective\": \"peanut butter\", \"Objective\": \"jelly\", \"Assessment\": \"bread\", \"Plan\": \"eat\"}";
dt.Rows.Add(row);
//Action
var results = new CsvReaderV2().GetSoapNotes(dt);
var result = results.Rows[0];
//Assert
var SerializedContentId = result["SerializedContentId"].ToString() == "123";
var Subjective = result["Subjective"].ToString() == "peanut butter";
var Objective = result["Objective"].ToString() == "jelly";
var Assessment = result["Assessment"].ToString() == "bread";
var Plan = result["Plan"].ToString() == "eat";
var condition = SerializedContentId && Subjective && Objective && Assessment && Plan;
Assert.IsTrue(condition);
}
/// <summary>
///
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static string CreateString(DataTable dt)
{
using (CsvReaderV2 csv = new CsvReaderV2())
{
return(csv.CreateString(dt));
}
}
/// <summary>
/// Save
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button3_Click(object sender, EventArgs e)
{
var fbd = new FolderBrowserDialog();
if (fbd.ShowDialog() != DialogResult.OK)
{
return;
}
var savepath = Path.Combine(fbd.SelectedPath, _ofd.SafeFileName);
var dt = LoadFile(_ofd.FileName);
var text = String.Empty;
var test = checkBoxTestOldSanitizer.Checked;
string applyWrapper = comboBoxWrapWhen.Text;
var config = new CsvReaderV2Config()
{
QualifierWhen = new CsvReaderV2Config().ConvertQualifier(applyWrapper)
};
using (var csv = new CsvReaderV2(config))
{
text = csv.CreateString(dt);
}
File.WriteAllText(savepath, text);
MessageBox.Show("File saved!");
}
public void CsvReaderV2_CreateDataList_Data_Returns()
{
//Prep
var text = GetCsvStringAdvanced_LastRecordMultiline();
//Action
var condition = new CsvReaderV2().CreateDataTable(text);
//Assert
Assert.IsTrue(true);
}
public void CsvReaderV2_IsCorrupt_CsvString_ReturnsTrue()
{
//Prep
var csvText = GetCsvString_Wrapped_QuoteMissing();
//Action
var condition = new CsvReaderV2().IsCurrupt(csvText);
//Assert
Assert.IsTrue(condition);
}
public void CsvReaderV2_IsCorrupt_CsvString_ReturnsFalse()
{
//Prep
var csvText = GetCsvStringAdvanced();
//Action
var condition = new CsvReaderV2().IsCurrupt(csvText);
//Assert
Assert.IsFalse(condition);
}
public void CsvReaderV2_IsDataRowEmpty_DataRowNull_ReturnsTrue()
{
//Prep
DataRow dr = null;
//Action
var condition = new CsvReaderV2().IsDataRowEmpty(dr);
//Assert
Assert.IsTrue(condition);
}
private DataTable LoadFile(string path)
{
var text = File.ReadAllText(path);
var dt = new DataTable();
using (var csv = new CsvReaderV2())
{
dt = csv.CreateDataTable(text);
}
return(dt);
}
public void CsvReaderV2_ToDatatableRemoveWrapAndSanitize_CsvTextWrappedEscaped_ReturnsUnWrappedUnEscaped()
{
//Prep
var expected = "Dan \"The Man\" Jones";
var text = "\"Dan \"\"The Man\"\" Jones\"";
//Action
var actual = new CsvReaderV2().ToDatatableRemoveWrapAndSanitize(text);
//Assert
Assert.AreEqual(expected, actual);
}
public void CsvReaderV2_SanitizeTextForCsv_CsvTextUnEscapedChars_ReturnsEscaped()
{
//Prep
var text = "Dan \"The Man\" Jones";
var expected = "Dan \"\"The Man\"\" Jones";
//Action
var actual = new CsvReaderV2().SanitizeTextForCsv(text);
//Assert
Assert.AreEqual(expected, actual);
}
public void CsvReaderV2_ApplyWrapper_UnwrappedString_ReturnsWrapped()
{
//Prep
var expected = "\"Dan \"The Man\" Jones\"";
var text = "Dan \"The Man\" Jones";
//Action
var actual = new CsvReaderV2().ApplyWrapper(text);
//Assert
Assert.AreEqual(expected, actual);
}
public void CsvReaderV2_RemoveWrapper_NullString_ReturnsUnchanged()
{
//Prep
string text = null;
string expected = null;
//Action
var actual = new CsvReaderV2().RemoveWrapper(text);
//Assert
Assert.AreEqual(expected, actual);
}
public void CsvReaderV2_RemoveWrapper_BackWrappedString_ReturnsUnchanged()
{
//Prep
var text = "Dan \"The Man\" Jones\"";
var expected = "Dan \"The Man\" Jones\"";
//Action
var actual = new CsvReaderV2().RemoveWrapper(text);
//Assert
Assert.AreEqual(expected, actual);
}
public void CsvReaderV2_GetOccuranceCount_CsvString_ReturnsCount()
{
//Prep
var csvText = "Dan \"The Man\" Jones";
var expected = 2;
//Action
var count = new CsvReaderV2().GetOccuranceCount(csvText, "\"");
//Assert
Assert.AreEqual(expected, count);
}
/// <summary>
///
/// </summary>
/// <param name="strCSV"></param>
/// <param name="headerRow"></param>
/// <param name="scanRows"></param>
/// <param name="displayRows"></param>
/// <returns></returns>
public static DataTable CreateDataTable(string strCSV, bool headerRow = true, int scanRows = 0, int displayRows = 0)
{
var config = new CsvReaderV2Config()
{
IncludeHeaders = true, DisplayRows = displayRows
};
using (CsvReaderV2 csv = new CsvReaderV2(config))
{
return(csv.CreateDataTable(strCSV));
}
}
public void CsvReaderV2_ToCsvSanitizeAndWrap_CsvTextUnWrappedUnEscaped_ReturnsWrappedEscaped()
{
//Prep
var text = "Dan \"The Man\" Jones";
var expected = "\"Dan \"\"The Man\"\" Jones\"";
//Action
var actual = new CsvReaderV2().ToCsvSanitizeAndWrap(text);
//Assert
Assert.AreEqual(expected, actual);
}
public void CsvReaderV2_CreateDataTable_ConfigDisplkayRows0NoHeaders_CsvString_ReturnsDataTableWith1Row()
{
//Prep
var csvText = GetCsvStringAdvanced();
var config = new CsvReaderV2Config()
{
IncludeHeaders = false, DisplayRows = 0
};
var csv = new CsvReaderV2(config);
//Action
var dt = csv.CreateDataTable(csvText);
//Assert
Assert.IsTrue(dt.Rows.Count == 1);
}
public void CsvReaderV2_IsDataRowEmpty_DataRowFalsePositive_ReturnsTrue()
{
//Prep
var dt = new DataTable();
dt.Columns.Add("Test", typeof(string));
var dr = dt.NewRow();
dr[0] = "\" \"";
//Action
var condition = new CsvReaderV2().IsDataRowEmpty(dr);
//Assert
Assert.IsTrue(condition);
}
public void CsvReaderV2_CreateString_ConfigHeadersFalse_DataTable_ReturnsCsvString()
{
//Prep
var csvText = GetCsvStringAdvanced();
var config = new CsvReaderV2Config()
{
IncludeHeaders = false
};
var dt = new CsvReaderV2(config).CreateDataTable(csvText);
//Action
var text = new CsvReaderV2(config).CreateString(dt);
var expected = GetExpected_Advanced_ConfigHeadersFalse();
//Assert
Assert.AreEqual(expected, text);
}
public void CsvReaderV2_CreateString_DataTable_ReturnsCsvString()
{
//Prep
var csvText = GetCsvStringAdvanced();
var config = new CsvReaderV2Config()
{
IgnoreFalsePositiveEmptyRows = true
};
var dt = new CsvReaderV2(config).CreateDataTable(csvText);
//Action
var text = new CsvReaderV2(config).CreateString(dt);
var expected = GetCsvStringAdvanced_Wrapped();
//Assert
Assert.AreEqual(expected, text);
}
public void CsvReaderV2MbctOnly_CreateStringLegacy_Input_Returns()
{
//Prep
var csvText = File.ReadAllText(GetTestDataPath("CSV_Advanced04_LotsOfStuff.txt"));
var config = new CsvReaderV2Config()
{
};
var dt = new CsvReaderV2(config).CreateDataTable(csvText);
//Action
#pragma warning disable CS0618 // Obsolete Attribbute on method call
var text = new CsvReaderV2().CreateString(dt, wrapOnlyIfNeeded: false, includeHeaders: true);
#pragma warning restore CS0618 // Obsolete Attribbute on method call
var expected = File.ReadAllText(GetTestDataPath("Result_Advanced04_LotsOfStuff.txt"));
//Assert
Assert.AreEqual(expected, text);
}
public void CsvReaderV2_CreateString_ConfigNewFlagFalse_DataTable_ReturnsCsvString()
{
//Prep
var csvText = GetCsvStringAdvanced();
var config = new CsvReaderV2Config()
{
IgnoreFalsePositiveEmptyRows = false
};
var dt = new CsvReaderV2(config).CreateDataTable(csvText);
//Action
var text = new CsvReaderV2(config).CreateString(dt);
var expected = "";
//expected = File.ReadAllText(GetTestDataPath("Result_Advanced04_LotsOfStuff_ConfigNewFlagFalse.txt"));
expected = GetExpected_Advanced_ConfigNewFlagFalse();
//Assert
Assert.AreEqual(expected: expected, actual: text);
}
public void CsvReaderV2_CreateDataTable_ConfigDefault_CsvString_ReturnsDataTableWithAllRows()
{
//Prep
var csvText = GetCsvStringAdvanced();
var config = new CsvReaderV2Config()
{
};
var dt = new DataTable();
using (var csv = new CsvReaderV2(config))
{
//Action
dt = csv.CreateDataTable(csvText);
}
//Assert
Assert.IsTrue(dt.Rows.Count == 5, message: $"Rows({dt.Rows.Count}) Cols({dt.Columns.Count})");
}
public void CsvReaderV2MbctOnly_CreateDataTableLegacy_Input_Returns()
{
//Prep
var csvText = File.ReadAllText(GetTestDataPath("CSV_Advanced04_LotsOfStuff.txt"));
var config = new CsvReaderV2Config()
{
};
var dt = new DataTable();
using (var csv = new CsvReaderV2(config))
{
//Action
#pragma warning disable CS0618 // Obsolete Attribbute on method call
dt = csv.CreateDataTable(csvText, headerRow: true, displayRows: -1);
#pragma warning restore CS0618 // Obsolete Attribbute on method call
}
//Assert
Assert.IsTrue(dt.Rows.Count == 5, message: $"Rows({dt.Rows.Count}) Cols({dt.Columns.Count})");
}
public void CsvReaderV2MbctOnly_FixSoapNotes_Input_Returns()
{
//Prep
var csvText = String.Empty;
//csvText = File.ReadAllText(GetTestDataPath("CSV_SOAP_Basic01.txt"));
csvText = "\"{\"SerializedContentId\":\"bc49686c\",\"Subjective\":\"<div><br></div><div><br></div>\",\"Objective\":\"\",\"Assessment\":\"<div><br bogus=\"1\"></div>\",\"Plan\":\"<div><br bogus=\"1\"></div>\",\"Note\":\"\"}\"";
csvText = Environment.NewLine + csvText + Environment.NewLine;
var expected = String.Empty;
//expected = File.ReadAllText(GetTestDataPath("Result_SOAP_Basic01.txt"));
expected = "\"{\"\"SerializedContentId\"\":\"\"bc49686c\"\",\"\"Subjective\"\":\"\"<div><br></div><div><br></div>\"\",\"\"Objective\"\":\"\"\"\",\"\"Assessment\"\":\"\"<div><br bogus=\"\"1\"\"></div>\"\",\"\"Plan\"\":\"\"<div><br bogus=\"\"1\"\"></div>\"\",\"\"Note\"\":\"\"\"\"}\"";
expected = Environment.NewLine + expected + Environment.NewLine;
//Action
var actual = new CsvReaderV2().FixSoapNotes(csvText);
//Assert
Assert.AreEqual(expected, actual);
}
