public static Message Parse(string xmlMsg) { XElement xdoc = XElement.Parse(xmlMsg); Message ret = new Message(); ret.Msg = xdoc.Element("Msg").Value; if (xdoc.Element("Passed").Value.ToString() == "True") ret.Passed = true; else ret.Passed = false; ret.TestID = Convert.ToInt32(xdoc.Element("TestID").Value.ToString()); return ret; }
private bool test1() { Message test1 = new Message(); test1.TestID = 1; test1.Passed = false; Console.WriteLine("Demo WCF Using Authenticate!"); try { authR = channel1.Authenticate("team1", "clientapi", out token); } catch (Exception ex) { Console.WriteLine(ex); } if (authR.valid) test1.Msg = "The Authenticate is passed!"; else test1.Msg = "The Authenticate is failed!"; Console.WriteLine(test1.Msg); test1.Passed = authR.valid; m_MsgList.Add(test1); return test1.Passed; }
public void testFunction(bool ispass) { if (ispass) { Message m1 = new Message(); m1.Msg = "AuthManager Testcase successfully run"; m1.TestID = testCounter; m1.Passed = true; string m_string = m1.ToString(); m_Msg.Add(m_string); testCounter++; } else { Message m1 = new Message(); m1.Msg = "AuthManager Testcase is failed to pass"; m1.TestID = testCounter; m1.Passed = false; string m_string = m1.ToString(); m_Msg.Add(m_string); testCounter++; } }
private bool Case1() { QParser qParser = new QParser(); Statement statementObject = qParser.ValidateQuery("create db dbname;"); if (statementObject.GetStatementType() != StatementType.CREATE_DB) return false; if (((CreateDB)statementObject).GetDatabaseName() != "dbname") return false; Message message = new Message(); message.Msg = "CREATE DB query was executed sucesfully "; message.TestID = 1; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; }
private bool test9() { Message test9 = new Message(); test9.TestID = 9; test9.Passed = false; Console.WriteLine("Demo WCF using Create user"); try { authR = channel1.CreateUser("User6", "abcdefghijklmnopqrstuvwxyx", invalidToken); } catch (Exception ex) { Console.WriteLine(ex); } if (!authR.valid) test9.Msg = "Create User6 Case has been passed!"; else test9.Msg = "Create User6 Case has been failed!"; Console.WriteLine(test9.Msg); if (authR.valid == false) test9.Passed = true; m_MsgList.Add(test9); return test9.Passed; }
private bool Case60() { QParser qParser = new QParser(); try { Statement statementObject = qParser.ValidateQuery("RENAME COLUMN col1 TO col2 IN TABLE tab1;"); RenameColumn obj = (RenameColumn)statementObject; if (obj.GetStatementType() != StatementType.RENAME_COLUMN) return false; if (obj.GetTableName() != "tab1") return false; if (obj.GetOldColumnName() != "col1") return false; if(obj.GetNewColumnName() != "col2") return false; Message message = new Message(); message.Msg = "RENAME COLUMN Query was executed succesfully"; message.TestID = 60; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } catch (Exception ex) { ex.ToString(); return false; } }
public bool Test() { bool ret = false; try { TableResponse m_TResponse; TableManager m_TManager = new TableManager(); //CreateDatabaseTest Message m_createDatabase = new Message(); m_TResponse = m_TManager.CreateDatabase("TestDatabase"); m_createDatabase.Passed = m_TResponse.GetResponse; m_createDatabase.Msg = m_TResponse.GetMessage + " for " + m_TResponse.GetId; m_createDatabase.TestID = 1; m_msg.Add(m_createDatabase.ToString()); //Generate columns to be added to table Dictionary<string, bool> m_Dict = new Dictionary<string, bool>(); m_Dict.Add("ID", true); m_Dict.Add("Name", false); m_Dict.Add("Dept", true); //Adding the typenames for the columns List<string> m_colTypelist = new List<string>(); m_colTypelist.Add("int"); m_colTypelist.Add("float"); m_colTypelist.Add("varchar(10)"); //CreateTable Test Message m_createTable = new Message(); m_TResponse = m_TManager.CreateTable("TestDatabase", "TestTable", m_Dict, m_colTypelist); m_createTable.Passed = m_TResponse.GetResponse; m_createTable.Msg = m_TResponse.GetMessage + " for " + m_TResponse.GetId; m_createTable.TestID = 2; m_msg.Add(m_createTable.ToString()); //create List for the columnnames to add row List<string> ListColumnName = new List<string>(); ListColumnName.Add("ID"); ListColumnName.Add("Name"); ListColumnName.Add("Dept"); //generate arraylist for data to be add row ArrayList AlColVal = new ArrayList(); AlColVal.Add(11); AlColVal.Add(11.1f); AlColVal.Add("test"); //Add Row Test m_TResponse = m_TManager.InsertRow("TestDatabase", "TestTable", ListColumnName, AlColVal); Message m_InsertRow = new Message(); m_InsertRow.Passed = m_TResponse.GetResponse; m_InsertRow.Msg = m_TResponse.GetMessage + " for " + m_TResponse.GetId; m_InsertRow.TestID = 3; m_msg.Add(m_InsertRow.ToString()); //AddColumn Test m_TResponse = m_TManager.AddColumn("TestDatabase", "TestTable", false, "str", "varchar(8)"); Message m_AddColumn = new Message(); m_AddColumn.Passed = m_TResponse.GetResponse; m_AddColumn.Msg = m_TResponse.GetMessage + " for " + m_TResponse.GetId; m_AddColumn.TestID = 4; m_msg.Add(m_AddColumn.ToString()); //rename column Test m_TResponse = m_TManager.RenameColumn("TestDatabase", "TestTable", "str", "newStr"); Message m_RenameColumn = new Message(); m_RenameColumn.Passed = m_TResponse.GetResponse; m_RenameColumn.Msg = m_TResponse.GetMessage + " for " + m_TResponse.GetId; m_RenameColumn.TestID = 5; m_msg.Add(m_RenameColumn.ToString()); //renameTable Test m_TResponse = m_TManager.RenameTable("TestDatabase", "TestTable", "NewTestTable"); Message m_RenameTable = new Message(); m_RenameTable.Passed = m_TResponse.GetResponse; m_RenameTable.Msg = m_TResponse.GetMessage + " for " + m_TResponse.GetId; m_RenameTable.TestID = 6; m_msg.Add(m_RenameTable.ToString()); //Emptytable Test m_TResponse = m_TManager.EmptyTable("TestDatabase", "NewTestTable"); Message m_EmptyTable = new Message(); m_EmptyTable.Passed = m_TResponse.GetResponse; m_EmptyTable.Msg = m_TResponse.GetMessage + " for " + m_TResponse.GetId; m_EmptyTable.TestID = 7; m_msg.Add(m_EmptyTable.ToString()); //deletetable Test m_TResponse = m_TManager.DeleteTable("TestDatabase", "NewTestTable"); Message m_DeleteTable = new Message(); m_DeleteTable.Passed = m_TResponse.GetResponse; m_DeleteTable.Msg = m_TResponse.GetMessage + " for " + m_TResponse.GetId; m_DeleteTable.TestID = 8; m_msg.Add(m_DeleteTable.ToString()); //deletedatabase Test m_TResponse = m_TManager.DeleteDatabase("TestDatabase"); Message m_DeleteDatabase = new Message(); m_DeleteDatabase.Passed = m_TResponse.GetResponse; m_DeleteDatabase.Msg = m_TResponse.GetMessage + " for " + m_TResponse.GetId; m_DeleteDatabase.TestID = 9; m_msg.Add(m_DeleteDatabase.ToString()); ret = true; } catch(Exception ex) { throw ex; } return ret; }
private bool test14() { Console.WriteLine("Demo the Validate Module"); Message test14 = new Message(); test14.TestID = 14; test14.Passed = false; List<string> users = new List<string>(); try { users = channel1.GetAllUserNames(token); test14.Passed = true; test14.Msg = "Get all the user name and Case is Passed!"; Console.WriteLine(test14.Msg); } catch (Exception ex) { Console.WriteLine(ex); test14.Passed = false; } foreach (string user in users) { Console.WriteLine(user); } m_MsgList.Add(test14); return test14.Passed; }
private bool test16() { Console.WriteLine("Demo Change password"); Message test16 = new Message(); test16.TestID = 16; test16.Passed = false; try { channel1.Authenticate("User1", "123412341234", out User1Token); authR = channel1.ChangePassword("User1", "123", User1Token); } catch (Exception ex) { Console.WriteLine(ex); } if (!authR.valid) test16.Msg = "The change password Case is passed!"; else test16.Msg = "The change password Case is failed!"; Console.WriteLine(test16.Msg); if (authR.valid == false) test16.Passed = true; m_MsgList.Add(test16); return test16.Passed; }
//checking if there are extra spaces between the strings in the query private bool Case13() { QParser qParser = new QParser(); try { string m_SelectDb = "SELECT DB databasename1;"; Statement statementObject = qParser.ValidateQuery(m_SelectDb); return false; } catch (Exception ex) { ex.ToString(); Message message = new Message(); message.Msg = "Exception was thrown for additional spaces between the keywords SELECT and DB in SELECT DB query"; ; message.TestID = 13; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } }
private bool test12() { Console.WriteLine("Demo the privilege changing function"); Message test12 = new Message(); test12.TestID = 12; test12.Passed = false; try { authR = channel1.ChangeUserPrivilege("User7", true, token); } catch (Exception ex) { Console.WriteLine(ex); } if (authR.valid) test12.Msg = "Changing Privilege of User7 Case is passed!"; else test12.Msg = "Changing Privilege of User7 Case is failed!"; Console.WriteLine(test12.Msg); test12.Passed = authR.valid; m_MsgList.Add(test12); return test12.Passed; }
// checking if there is a space between tablename and open parenthesis // according to the sql given there shouldn be any.. so throwing error. private bool Case8() { QParser qParser = new QParser(); try { Statement statementObject = qParser.ValidateQuery("CREATE TABLE table1 (PRIMARY KEY key1 VARCHAR(255));"); return false; } catch (Exception ex) { ex.ToString(); Message message = new Message(); message.Msg = "Exception was thrown for extra space betwwen the kewords CREATE and TABLE in CREATE TABLE query"; message.TestID = 8; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } }
// Checking lowercase and uppercase in the query inputted(create TABLE) private bool Case9() { QParser qParser = new QParser(); try { Statement statementObject = qParser.ValidateQuery("create TABLE table1 (PRIMARY KEY key1 VARCHAR(255))"); return false; } catch (Exception ex) { ex.ToString(); Message message = new Message(); message.Msg = "Exception was thrown for inputting lowercase and uppercase keywords in tha same CREATE TABLE query"; message.TestID = 9; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } }
// test case for no table name in the query.. handling the exception private bool Case7() { QParser qParser = new QParser(); try { Statement statementObject = qParser.ValidateQuery("CREATE TABLE (PRIMARY KEY key1 VARCHAR(255))"); return false; } catch (Exception ex) { ex.ToString(); Message message = new Message(); message.Msg = "Exception was thrown for missing table name in CREATE TABLE query"; message.TestID = 7; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } }
private bool Case5() { QParser qParser = new QParser(); try { Statement statementObject = qParser.ValidateQuery("CREATE TABLE table1(PRIMARY KEY key1 VARCHAR(255));"); if (statementObject.GetStatementType() != StatementType.CREATE_TABLE) return false; CreateTable tabObj = (CreateTable)statementObject; List<TableColumn> columnList = new List<TableColumn>(); if (tabObj.GetTableName() != "table1") return false; columnList = tabObj.GetList(); foreach (TableColumn column in columnList) { if (column.GetUniqueKey() != "PRIMARY KEY") return false; if (column.GetColumnName() != "key1") return false; if (column.GetVarType() != "VARCHAR") return false; if (column.GetVarRange() != "255") return false; } Message message = new Message(); message.Msg = "CREATE TABLE query was executed successfully"; message.TestID = 5; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } catch (Exception ex) { ex.ToString(); return false; } }
private bool Case4() { QParser qParser = new QParser(); try { Statement statementObject = qParser.ValidateQuery("create db;"); return false; } catch (Exception ex) { ex.ToString(); Message message = new Message(); message.Msg = "Exceptiion was thrown for missing database name in CREATE DB query"; message.TestID = 4; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } }
private bool test10() { Message test10 = new Message(); test10.TestID = 10; test10.Passed = false; Console.WriteLine("Demo WCF using Create user"); try { authR = channel1.CreateUser("User7", "_12456774", token); } catch (Exception ex) { Console.WriteLine(ex); } if (authR.valid) test10.Msg = "Create User7 Case has been passed!"; else test10.Msg = "Create User7 Case has been failed!"; Console.WriteLine(test10.Msg); test10.Passed = authR.valid; m_MsgList.Add(test10); return test10.Passed; }
// there is a possibility that the user can input DATABASE instead // of DB as .. So checking for error handling private bool Case14() { QParser qParser = new QParser(); try { string m_SelectDb = "SELECT database databasename1;"; Statement statementObject = qParser.ValidateQuery(m_SelectDb); return false; } catch (Exception ex) { ex.ToString(); Message message = new Message(); message.Msg = "Exception was thrown for improper syntax in the SELECT DB query"; message.TestID = 14; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } }
private bool test11() { Message test11 = new Message(); test11.TestID = 11; test11.Passed = false; Console.WriteLine("Demo WCF using Create user"); try { authR = channel1.CreateUser("User8", "_12456774", invalidToken); } catch (Exception ex) { Console.WriteLine(ex); } if (!authR.valid) test11.Msg = "Create User8 Case has been passed!"; else test11.Msg = "Create User8 Case has been failed!"; Console.WriteLine(test11.Msg); if (authR.valid == false) test11.Passed = true; m_MsgList.Add(test11); return test11.Passed; }
private bool Case15() { QParser qParser = new QParser(); try { string m_DeleteDb = "DELETE DB databasename1;"; if (!m_DeleteDb.Contains(";")) return false; Statement statementObject = qParser.ValidateQuery(m_DeleteDb); if (statementObject.GetStatementType() != StatementType.DELETE_DB) return false; DeleteDB dbObj = (DeleteDB)statementObject; if (dbObj.GetDatabaseName() != "databasename1") return false; Message message = new Message(); message.Msg = "DELETE DB query was executed successfully"; message.TestID = 15; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } catch (Exception ex) { ex.ToString(); return false; } }
private bool test13() { Console.WriteLine("Demo the privilege changing function"); Message test13 = new Message(); test13.TestID = 13; test13.Passed = false; try { channel1.Authenticate("User1", "123412341234", out User1Token); authR = channel1.ChangeUserPrivilege("User1", true, User1Token); } catch (Exception ex) { Console.WriteLine(ex); } if (!authR.valid) test13.Msg = "Changing Privilege of User1 Case is passed!"; else test13.Msg = "Changing Privilege of User1 Case is failed!"; Console.WriteLine(test13.Msg); if (authR.valid == false) test13.Passed = true; m_MsgList.Add(test13); return test13.Passed; }
private bool test3() { Message test3 = new Message(); test3.TestID = 3; test3.Passed = false; Console.WriteLine("Demo WCF using IsAdmin"); try { test3.Passed = channel1.IsAdmin(token); if (test3.Passed) test3.Msg = "The IsAdmin is passed!"; else test3.Msg = "The IsAdmin is failed!"; Console.WriteLine(test3.Msg); } catch (Exception ex) { Console.WriteLine(ex); } m_MsgList.Add(test3); return test3.Passed; }
private bool test15() { Console.WriteLine("Demo Change password"); Message test15 = new Message(); test15.TestID = 15; test15.Passed = false; try { channel1.Authenticate("User7", "_12456774", out User7Token); authR = channel1.ChangePassword("User7", "123123123123", User7Token); } catch (Exception ex) { Console.WriteLine(ex); } if (authR.valid) test15.Msg = "The Change password Case is passed!"; else test15.Msg = "The Change password Case is failed!"; Console.WriteLine(test15.Msg); test15.Passed = authR.valid; m_MsgList.Add(test15); return test15.Passed; }
private bool test5() { Message test5 = new Message(); test5.TestID = 5; test5.Passed = false; Console.WriteLine("Demo WCF using Create user"); try { authR = channel1.CreateUser("User2", "123123321321", token); } catch (Exception ex) { Console.WriteLine(ex); } if (authR.valid) test5.Msg = "Create User2 Case has been passed!"; else test5.Msg = "Create User2 Case has been failed!"; Console.WriteLine(test5.Msg); test5.Passed = authR.valid; m_MsgList.Add(test5); return test5.Passed; }
private bool test17() { Console.WriteLine("Demo validate!"); Message test17 = new Message(); test17.TestID = 17; test17.Passed = false; DateTime dT = new DateTime(); try { test17.Passed = channel2.Validate(token, out dT); Console.WriteLine("\nThe expire time is:"); Console.WriteLine(dT.ToString()); } catch (Exception ex) { Console.WriteLine(ex); } if (test17.Passed) test17.Msg = "The Validate Case is passed!"; else test17.Msg = "The Validate Case is Failed"; Console.WriteLine(test17.Msg); m_MsgList.Add(test17); return test17.Passed; }
private bool Case59() { QParser qParser = new QParser(); try { Statement statementObject = qParser.ValidateQuery("RENAME TABLE tab1 TO tab2;"); RenameTable obj = (RenameTable)statementObject; if(obj.GetStatementType() != StatementType.RENAME_TABLE) return false; if (obj.GetOldTableName() != "tab1") return false; if (obj.GetNewTableName() != "tab2") return false; Message message = new Message(); message.Msg = "RENAME TABLE Query was executed succesfully"; message.TestID = 59; message.Passed = true; string m_Message = message.ToString(); messageList.Add(m_Message); return true; } catch (Exception ex) { ex.ToString(); return false; } }
private bool test2() { Message test2 = new Message(); test2.TestID = 2; test2.Passed = false; Console.WriteLine("Demo WCF Using Authenticate!"); try { authR = channel1.Authenticate("team1", "123456789", out invalidToken); } catch (Exception ex) { Console.WriteLine(ex); } if (!authR.valid) test2.Msg = "The Authenticate is passed!"; else test2.Msg = "The Authenticate is failed!"; Console.WriteLine(test2.Msg); if (authR.valid == false) test2.Passed = true; m_MsgList.Add(test2); return test2.Passed; }
private bool test8() { Message test8 = new Message(); test8.TestID = 8; test8.Passed = false; Console.WriteLine("Demo WCF using Create user"); try { authR = channel1.CreateUser("User5", "completely", invalidToken); } catch (Exception ex) { Console.WriteLine(ex); } if (!authR.valid) test8.Msg = "Create User5 Case has been passed!"; else test8.Msg = "Create User5 Case has been failed!"; Console.WriteLine(test8.Msg); if (authR.valid == false) test8.Passed = true; m_MsgList.Add(test8); return test8.Passed; }
private bool test6() { Message test6 = new Message(); test6.TestID = 6; test6.Passed = false; Console.WriteLine("Demo WCF using Create user"); try { authR = channel1.CreateUser("User3", "123456", token); } catch (Exception ex) { Console.WriteLine(ex); } if (!authR.valid) test6.Msg = "Create User3 Case has been passed!"; else test6.Msg = "Create User3 Case has been failed!"; Console.WriteLine(test6.Msg); if (authR.valid == false) test6.Passed = true; m_MsgList.Add(test6); return test6.Passed; }
public bool Test() { if (!Case1()) { Message message = new Message(); message.Msg = "Failure while processing CREATE DB query"; message.TestID = 1; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case2()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing database name and semicolon in CREATE DB query"; message.TestID = 2; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case3()) { Message message = new Message(); message.Msg = "Exceptiion was not thrown for missing semicolon in CREATE DB query"; message.TestID = 3; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case4()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing database name in CREATE DB query"; message.TestID = 4; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case5()) { Message message = new Message(); message.Msg = "Failure occured while processing CREATE TABLE query"; message.TestID = 5; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case6()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing semicolon in CREATE TABLE query"; message.TestID = 6; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case7()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing table name in CREATE TABLE query"; message.TestID = 7; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case8()) { Message message = new Message(); message.Msg = "Exception was not thrown for extra space betwwen the kewords CREATE and TABLE in CREATE TABLE query"; message.TestID = 8; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case9()) { Message message = new Message(); message.Msg = "Exception was not thrown for inputting lowercase and uppercase keywords in tha same CREATE TABLE query"; message.TestID = 9; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case10()) { Message message = new Message(); message.Msg = "Failure occured while processing SELECT DB query"; message.TestID = 10; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case11()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing semicolon in the SELECT DB query"; message.TestID = 11; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case12()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing database name in the SELECT DB query"; message.TestID = 12; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case13()) { Message message = new Message(); message.Msg = "Exception was not thrown for additional spaces between the keywords SELECT and DB in SELECT DB query"; ; message.TestID = 13; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case14()) { Message message = new Message(); message.Msg = "Exception was not thrown for improper syntax in the SELECT DB query"; message.TestID = 14; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case15()) { Message message = new Message(); message.Msg = "Failure occured while processing DELETE DB query"; message.TestID = 15; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case16()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing semicolon in the DELETE DB query"; message.TestID = 16; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case17()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing database name in the DELETE DB query"; message.TestID = 17; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case18()) { Message message = new Message(); message.Msg = "Exception was not thrown for additional spaces between keywords DELETE and DB in DELETE DB query"; message.TestID = 18; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case19()) { Message message = new Message(); message.Msg = "Exception was not thrown for improper syntax in DELETE DB query"; message.TestID = 19; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case20()) { Message message = new Message(); message.Msg = "Failure occured while processing DELETE TABLE query"; message.TestID = 20; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case21()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing semicolon in the DELETE TABLE query"; message.TestID = 21; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case22()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing table name in the DELETE TABLE query"; message.TestID = 22; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case23()) { Message message = new Message(); message.Msg = "Exception was not thrown for additional spaces between Keywords DELETE and TABLE in the DELETE TABLE query"; message.TestID = 23; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case24()) { Message message = new Message(); message.Msg = "Exception was not thrown for improper syntax in the DELETE TABLE query"; message.TestID = 24; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case25()) { Message message = new Message(); message.Msg = "Failure in processing EMPTY TABLE query"; message.TestID = 25; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case26()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing semicolon in the EMPTY TABLE query"; message.TestID = 26; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case27()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing table name in the EMPTY TABLE query"; message.TestID = 27; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case28()) { Message message = new Message(); message.Msg = "Exception was not thrown for improper spacing between Keywords EMPTY and TABLE in the EMPTY TABLE query"; message.TestID = 28; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case29()) { Message message = new Message(); message.Msg = "Exception was not thrown for improper syntax in the EMPTY TABLE query"; message.TestID = 29; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case30()) { Message message = new Message(); message.Msg = "Failure occured while processing DELETE COLUMN query"; message.TestID = 30; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case31()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing semicolon in the DELETE COLUMN query"; message.TestID = 31; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case32()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing table name in the DELETE COLUMN query"; message.TestID = 32; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case33()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing column name in the DELETE COLUMN query"; message.TestID = 33; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case34()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing COLUMN Keyword in the DELETE COLUMN query"; message.TestID = 34; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case35()) { Message message = new Message(); message.Msg = "Exception was not thrown for improper syntax in the DELETE COLUMN query"; message.TestID = 35; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case36()) { Message message = new Message(); message.Msg = "Failure occured while processing ADD COLUMN query"; message.TestID = 36; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case37()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing semicolon in the ADD COLUMN query"; message.TestID = 37; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case38()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing table name in the ADD COLUMN query"; message.TestID = 38; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case39()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing column name in the ADD COLUMN query"; message.TestID = 39; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case40()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing COLUMN Keyword in the ADD COLUMN query"; message.TestID = 40; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case41()) { Message message = new Message(); message.Msg = "Exception was not thrown for improper syntax in the ADD COLUMN query"; message.TestID = 41; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case42()) { Message message = new Message(); message.Msg = "Failure occurred while processing INSERT Query"; message.TestID = 42; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case43()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing semicolon in the INSERT query"; message.TestID = 43; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case44()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing table name in the INSERT query"; message.TestID = 44; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case45()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing VALUES Keyword in the INSERT query"; message.TestID = 45; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case46()) { Message message = new Message(); message.Msg = "Exception was not thrown for improper spacing between Keywords INSERT and INTO in the INSERT query"; message.TestID = 46; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case47()) { Message message = new Message(); message.Msg = "Exception was not thrown for missing comma in between the column names in the INSERT query"; message.TestID = 47; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case48()) { Message message = new Message(); message.Msg = "Failure occurred while processing basic SELECT query"; message.TestID = 48; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case49()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query with WHERE clause"; message.TestID = 49; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case50()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query with ORDER BY clause"; message.TestID = 50; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case51()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query with LIMIT range"; message.TestID = 51; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case52()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query with WHERE and ORDER BY clauses"; message.TestID = 52; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case53()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query with WHERE and LIMIT clauses"; message.TestID = 53; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case54()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query with ORDER BY and LIMIT clauses"; message.TestID = 54; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case55()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query with WHERE, ORDER BY and LIMIT clauses"; message.TestID = 55; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case56()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query which selects specific columns"; message.TestID = 56; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case57()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query with COUNT"; message.TestID = 57; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case58()) { Message message = new Message(); message.Msg = "Failure occurred while processing SELECT query with COUNT"; message.TestID = 58; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case59()) { Message message = new Message(); message.Msg = "Failure occured while processing RENAME TABLE Query"; message.TestID = 59; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } if (!Case60()) { Message message = new Message(); message.Msg = "Failure occured while processing RENAME COLUMN Query"; message.TestID = 60; message.Passed = false; string m_Message = message.ToString(); messageList.Add(m_Message); return false; } return true; }