public void Test_UpdateRow()
{
// Get initial row
CTest_SelectQry qrySel = new CTest_SelectQry();
qrySel.PlatformID = 1;
Assert.AreEqual(qrySel.Select(), SQLiteErrorCode.Ok);
Assert.AreEqual(qrySel.PlatformID, 1);
Assert.AreEqual(qrySel.Name, "test");
Assert.AreEqual(qrySel.Description, "PlatformID 1");
// Update database row
CTest_UpdateQry qryUpd = new CTest_UpdateQry();
qryUpd.PlatformID = 1;
qryUpd.Description = "Updated PlatformID 1";
Assert.AreEqual(qryUpd.Update(), SQLiteErrorCode.Ok);
// Read again
Assert.AreEqual(qrySel.Select(), SQLiteErrorCode.Ok);
Assert.AreEqual(qrySel.PlatformID, 1);
Assert.AreEqual(qrySel.Name, "test");
Assert.AreEqual(qrySel.Description, "Updated PlatformID 1");
Assert.IsFalse(qrySel.Fetch());
}
public void Test_InsertRow()
{
// Clear Platform table
string qry = "DELETE FROM Platform";
CSqlDB.Instance.Execute(qry);
// Read from database (should fail)
CTest_SelectQry qrySel = new CTest_SelectQry();
qrySel.PlatformID = 1;
Assert.AreEqual(qrySel.Select(), SQLiteErrorCode.NotFound);
// Insert into database
CTest_InsertQry qryIns = new CTest_InsertQry();
qryIns.PlatformID = 1;
qryIns.Name = "test";
qryIns.Description = "PlatformID 1";
Assert.AreEqual(qryIns.Insert(), SQLiteErrorCode.Ok);
// Try again
qrySel.PlatformID = 1;
Assert.AreEqual(qrySel.Select(), SQLiteErrorCode.Ok);
Assert.AreEqual(qrySel.PlatformID, 1);
Assert.AreEqual(qrySel.Name, "test");
Assert.AreEqual(qrySel.Description, "PlatformID 1");
Assert.IsFalse(qrySel.Fetch()); // Only one row found
}
public void Test_DeleteRow()
{
// Get initial row
CTest_SelectQry qrySel = new CTest_SelectQry();
qrySel.PlatformID = 1;
Assert.AreEqual(qrySel.Select(), SQLiteErrorCode.Ok);
Assert.AreEqual(qrySel.PlatformID, 1);
Assert.AreEqual(qrySel.Name, "test");
Assert.AreEqual(qrySel.Description, "PlatformID 1");
// Delete database row
CTest_DeleteQry qryDel = new CTest_DeleteQry();
qryDel.PlatformID = 1;
Assert.AreEqual(qryDel.Delete(), SQLiteErrorCode.Ok);
// Read again
Assert.AreEqual(qrySel.Select(), SQLiteErrorCode.NotFound);
}
public void Test_InsertDuplicateValue()
{
// Read from database
CTest_SelectQry qrySel = new CTest_SelectQry();
qrySel.PlatformID = 1;
Assert.AreEqual(qrySel.Select(), SQLiteErrorCode.Ok);
Assert.AreEqual(qrySel.PlatformID, 1);
Assert.AreEqual(qrySel.Name, "test");
Assert.AreEqual(qrySel.Description, "PlatformID 1");
// Insert into database
CTest_InsertQry qryIns = new CTest_InsertQry();
qryIns.PlatformID = 1;
qryIns.Name = "test";
qryIns.Description = "PlatformID 1";
Assert.AreNotEqual(qryIns.Insert(), SQLiteErrorCode.Ok);
}