public void Test_3_AddTableToDataset()
{
DataTable table3 = new DataTable("staff");
table3.Columns.Add("name");
table3.Columns.Add("id");
table3.Columns.Add("address");
table3.Rows.Add("Perter", 1, "pullman");
table3.Rows.Add("Christ", 2, "SEATTLE");
bool check = SqliteInputOutput.AddTableToDataset("D://Test/database.db3", table3);
Assert.AreEqual(true, check);
}
public void Test_6_CreateIndex()
{
DataTable table4 = new DataTable("student");
table4.Columns.Add("name");
table4.Columns.Add("id");
table4.Columns.Add("address");
table4.Columns.Add("phone");
table4.Rows.Add("Max", 1, "pullman", 206 - 123 - 4567);
table4.Rows.Add("Sarah", 2, "SEATTLE", 206 - 321 - 9999);
// add new table.
SqliteInputOutput.AddTableToDataset("D://Test/database.db3", table4);
bool check = SqliteInputOutput.CreateIndex("D://Test/database.db3", "student", "name");
Assert.AreEqual(true, check);
//DataTable getTable = SqliteInputOutput.GetTable("D://Test/database.db3", "staff");
// wrong input that doest not have table name "abc"
bool check1 = SqliteInputOutput.CreateIndex("D://Test/database.db3", "abc", "abc");
Assert.AreEqual(false, check1);
}