public void TestInsert_allValue_withNULL()
{
CreateTestDatabase();
query = new QueryWrapper(connectionString);
query.InsertQuery(testDBName, "Name, Gender, Salary", "'Bob', NULL, '80'");
DataTable table = query.SelectQuery("*", testDBName);
Assert.AreEqual(1, table.Rows.Count);
Assert.AreEqual("Bob", table.Rows[0]["Name"].ToString());
Assert.AreEqual("", table.Rows[0]["Gender"].ToString());
Assert.AreEqual("80", table.Rows[0]["Salary"].ToString());
}
public void TestDelete_rowID()
{
CreateTestDatabase();
query = new QueryWrapper(connectionString);
query.InsertQuery(testDBName, "Name, Gender, Salary", "'Bob', NULL, '80'");
query.InsertQuery(testDBName, "Name, Gender, Salary", "'Tom', NULL, '84'");
query.InsertQuery(testDBName, "Name, Gender, Salary", "'Teresa', NULL, '100'");
DataTable table = query.SelectQuery("*", testDBName);
Assert.AreEqual(3, table.Rows.Count);
query.DeleteQuery(testDBName, "rowID = 1");
table = query.SelectQuery("*", testDBName);
Assert.AreEqual(2, table.Rows.Count);
Assert.AreEqual("Tom", table.Rows[0]["Name"].ToString());
Assert.AreEqual("", table.Rows[0]["Gender"].ToString());
Assert.AreEqual("84", table.Rows[0]["Salary"].ToString());
Assert.AreEqual("Teresa", table.Rows[1]["Name"].ToString());
Assert.AreEqual("", table.Rows[1]["Gender"].ToString());
Assert.AreEqual("100", table.Rows[1]["Salary"].ToString());
}
private void InitializeDataTable()
{
_queryWrapper = new QueryWrapper();
FormatAttributeString();
// to get rid of the last comma and space
Console.WriteLine("Attribute string is: " + _attributeString);
}
public void TestSearch_empty()
{
CreateTestDatabase();
query = new QueryWrapper(connectionString);
DataTable table = query.SelectQuery("*", testDBName);
Assert.AreEqual(0, table.Rows.Count);
}
public void TestInsert_singleValue()
{
CreateTestDatabase();
query = new QueryWrapper(connectionString);
query.InsertQuery(testDBName, "Name", "'Bob'");
DataTable table = query.SelectQuery("*", testDBName);
Assert.AreEqual(1, table.Rows.Count);
Assert.AreEqual("Bob", table.Rows[0]["Name"].ToString());
}
public void TestUpdate_singleValue_moreThanOneRow()
{
CreateTestDatabase();
query = new QueryWrapper(connectionString);
query.InsertQuery(testDBName, "Name, Gender, Salary", "'Bob', NULL, '80'");
query.InsertQuery(testDBName, "Name, Gender, Salary", "'Tom', NULL, '84'");
query.InsertQuery(testDBName, "Name, Gender, Salary", "'Teresa', NULL, '100'");
DataTable table = query.SelectQuery("*", testDBName);
query.UpdateQuery(testDBName, "Salary", "120", "2");
table = query.SelectQuery("*", testDBName);
Assert.AreEqual(3, table.Rows.Count);
Assert.AreEqual("Tom", table.Rows[1]["Name"].ToString());
Assert.AreEqual("", table.Rows[1]["Gender"].ToString());
Assert.AreEqual("120", table.Rows[1]["Salary"].ToString());
}