public void CreateInsertTest_emptyCSV()
{
CSVWrapper csv = new CSVWrapper();
csv.openCSV(FormatPath.formatPath("empty.csv"));
SQLBuilder builder = new SQLBuilder(csv, "", "Employee", "");
Assert.AreEqual("", builder.Build());
builder.CreateInsert();
Assert.AreEqual("", builder.Build());
}
public void CleanStringTestSpecialCharacter()
{
CSVWrapper csv = new CSVWrapper();
csv.openCSV(FormatPath.formatPath("specialSymbol.csv"));
SQLBuilder builder = new SQLBuilder(csv, "", "Employee", "");
Assert.AreEqual("", builder.Build());
builder.CreateInsert();
string[] insertLines = builder.Build().Split('\n');
Assert.AreEqual("INSERT INTO Employee(amt_in, amt1, amt2, sum) VALUES ('10', '50', '50','100');", insertLines[0]);
Assert.AreEqual("INSERT INTO Employee(amt_in, amt1, amt2, sum) VALUES ('12', '20', '70', '90');", insertLines[1]);
}
public void CreateInsertTest_smallCSV()
{
CSVWrapper csv = new CSVWrapper();
csv.openCSV(FormatPath.formatPath("test1.csv"));
SQLBuilder builder = new SQLBuilder(csv, "", "Employee", "");
Assert.AreEqual("", builder.Build());
builder.CreateInsert();
string[] insertLines = builder.Build().Split('\n');
Assert.AreEqual("INSERT INTO Employee(Name, Gender, Salary) VALUES ('Tom', 'M', '20');", insertLines[0]);
Assert.AreEqual("INSERT INTO Employee(Name, Gender, Salary) VALUES ('Adam', 'M', '30');", insertLines[1]);
Assert.AreEqual("INSERT INTO Employee(Name, Gender, Salary) VALUES ('Sara', 'F', '40');", insertLines[2]);
Assert.AreEqual("INSERT INTO Employee(Name, Gender, Salary) VALUES ('Serena', 'F', '50');", insertLines[3]);
}
