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