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;
}
