//checks if the Update method fails with incorrect info public void TestUpdateFail() { DBTest db = new DBTest(); string query = "UPDATE 17agileteam6db.users SET first_name = 32 WHERE user_ID = 'ew'"; Assert.AreEqual(false, db.Update(query)); }
//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 the update method works correctly with correct info. public void TestUpdateSuccess() { DBTest db = new DBTest(); string query = "UPDATE 17agileteam6db.users SET first_name = 'Dan' WHERE user_ID = 3"; Assert.AreEqual(true, db.Update(query)); }
//checks if user uses wrong credentials public void FailedLogin() { string username = "******"; string password = "******"; string query = "SELECT * FROM 17agileteam6db.users WHERE staff_no ='" + username + "' AND pass = '******'"; DBTest db = new DBTest(); bool login = false; MySql.Data.MySqlClient.MySqlDataReader reader = db.Select(query); while (reader.HasRows && reader.Read()) { string info = reader.GetString(reader.GetOrdinal("role")); } if (reader.HasRows) { login = true; } else { login = false; } reader.Close(); Assert.AreEqual(false, login); }
//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 the History Works with signing public void SignHistoryTest() { string role = "RIS"; bool worked; int project_ID = 3; DBTest db = new DBTest(); worked = db.History(project_ID, role, "Signed", " "); Assert.AreEqual(worked, true); }
//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); }
public void SuccessHistory() { string user = "******"; string query = "SELECT * FROM 17agileteam6db.history WHERE user = '******'"; DBTest db = new DBTest(); string info = ""; MySql.Data.MySqlClient.MySqlDataReader reader = db.Select(query); while (reader.HasRows && reader.Read()) { info = reader.GetString(reader.GetOrdinal("projectAction")); } Assert.AreEqual("Upload", info); }
//tests if the connection is made public void TestOpenConnection() { DBTest db = new DBTest(); Assert.AreEqual(true, db.OpenConnection()); }