//Checks if insert fails when given bad values
public void TestInsertfail()
{
DBTest db = new DBTest();
string query = "INSERT INTO 17agileteam6db.users VALUES (1, 3, 4, 'Engineering', 0, 'guest')";
Assert.AreEqual(false, db.Insert(query));
}
//checks if insert is working Correctly if given correct values
public void TestInsertSuccess()
{
DBTest db = new DBTest();
string query = "INSERT INTO 17agileteam6db.users (user_ID, staff_no, first_name, last_name, email, department, role, pass) VALUES(9, '20XO10', 'LiAM', 'Collins', '*****@*****.**', 'Engineering', 0, 'guest')";
bool insert = db.Insert(query);
Assert.AreEqual(true, insert);
}
//Checks if it Signs Correctly
public void SignTest()
{
string role = "RIS";
int project_ID = 2;
DBTest db = new DBTest();
string query = "UPDATE 17agileteam6db.projects SET " + role + "_accepted = 1 WHERE project_ID = " + project_ID;
bool worked = db.Insert(query);
Assert.AreEqual(worked, true);
}
//Uploads to history Table
public void TestHistoryUpload()
{
DBTest db = new DBTest();
string user = "******";
string comment = "Uploaded the file";
int project_ID = 3;
string action = "Upload";
string query = "INSERT INTO 17agileteam6db.history (project_ID, user, Historycol, date_time, projectAction, Comments) VALUES (" + project_ID + ", '" + user + "', ' ', NOW(), '" + action + "', '" + comment + "')";
bool insert = db.Insert(query);
Assert.AreEqual(true, insert);
}
