public void CleanStringTestSpace() { CSVWrapper csv = new CSVWrapper(); csv.openCSV(FormatPath.formatPath("space.csv")); SQLBuilder builder = new SQLBuilder(csv, "space", "spaceTable", null); Assert.AreEqual("", builder.Build()); builder.CreateTable(); Assert.AreEqual("CREATE TABLE spaceTable (RowID int IDENTITY (1,1) PRIMARY KEY, Name text, Gender text, Salary text, Marriage_Status text);\n", builder.Build()); }
public void CreateTableTest_empty() { SQLBuilder builder = new SQLBuilder(null, "", "", ""); Assert.AreEqual("", builder.Build()); builder.CreateTable(); Assert.AreEqual("", builder.Build()); }
public void CreateTableTest_name_noAttributes() { CSVWrapper csv = new CSVWrapper(); csv.openCSV(FormatPath.formatPath("empty.csv")); SQLBuilder builder = new SQLBuilder(csv, "", "Account", ""); Assert.AreEqual("", builder.Build()); builder.CreateTable(); Assert.AreEqual("CREATE TABLE Account (RowID int IDENTITY (1,1) PRIMARY KEY);\n", builder.Build()); }
public void CreateTableTest_name_smallCSV() { CSVWrapper csv = new CSVWrapper(); csv.openCSV(FormatPath.formatPath("test1.csv")); SQLBuilder builder = new SQLBuilder(csv, "", "Employee", ""); Assert.AreEqual("", builder.Build()); builder.CreateTable(); Assert.AreEqual("CREATE TABLE Employee (RowID int IDENTITY (1,1) PRIMARY KEY, Name text, Gender text, Salary text);\n", builder.Build()); }
public void CreateTableTest_emptyCSV() { SQLBuilder builder = new SQLBuilder(new CSVWrapper(), "", "", ""); Assert.AreEqual("", builder.Build()); builder.CreateTable(); Assert.AreEqual("", builder.Build()); }