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]); }