BEGIN TRANSACTION;
CREATE TABLE HttpTestResults (Description TEXT, ParamSet INTEGER, ContentType TEXT, Result BLOB);
CREATE TABLE Params(ParamSet INTEGER, ParamName TEXT, ParamValue TEXT);
INSERT INTO "Params" VALUES(1, 'OPERATION', 'GETINFO');
INSERT INTO "Params" VALUES(1, 'SECTION', 'InfoProperties');
INSERT INTO "Params" VALUES(2, 'OPERATION', 'GETSTATISTICS');
INSERT INTO "Params" VALUES(2, 'SECTION', 'StatisticProperties');
INSERT INTO "Params" VALUES(3, 'OPERATION', 'OFFLINE');
INSERT INTO "Params" VALUES(4, 'OPERATION', 'ONLINE');
INSERT INTO "Params" VALUES(5, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(5, 'LOGTYPE', 'AdminLog');
INSERT INTO "Params" VALUES(6, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(6, 'LOGTYPE', 'garbage');
INSERT INTO "Params" VALUES(7, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(7, 'LOGTYPE', 'AdminLog');
INSERT INTO "Params" VALUES(8, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(8, 'LOGTYPE', 'AdminLog');
INSERT INTO "Params" VALUES(8, 'NUMENTRIES', '3');
INSERT INTO "Params" VALUES(9, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(9, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(9, 'NUMENTRIES', '-1');
INSERT INTO "Params" VALUES(10, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(10, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(10, 'FROMDATE', '2005,1,2,0,0,0,0');
INSERT INTO "Params" VALUES(10, 'TODATE', '2005,1,2,0,0,0,0');
INSERT INTO "Params" VALUES(11, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(11, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(12, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(1001, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1001, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(1002, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1002, 'LOGTYPE', 'AdminLog');
INSERT INTO "Params" VALUES(1003, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1003, 'LOGTYPE', 'AuthenticationLog');
INSERT INTO "Params" VALUES(1004, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1004, 'LOGTYPE', 'ErrorLog');
INSERT INTO "Params" VALUES(1005, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1005, 'LOGTYPE', 'MapLayerAccessLog');
INSERT INTO "Params" VALUES(1006, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1006, 'LOGTYPE', 'SessionLog');
INSERT INTO "Params" VALUES(1007, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1007, 'LOGTYPE', 'TraceLog');
INSERT INTO "Params" VALUES(1008, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1008, 'LOGTYPE', 'InvalidLog');
INSERT INTO "Params" VALUES(1009, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1009, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(1009, 'NUMENTRIES', '3');
INSERT INTO "Params" VALUES(1010, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1010, 'LOGTYPE', 'AdminLog');
INSERT INTO "Params" VALUES(1010, 'NUMENTRIES', '3');
INSERT INTO "Params" VALUES(1011, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1011, 'LOGTYPE', 'AuthenticationLog');
INSERT INTO "Params" VALUES(1011, 'NUMENTRIES', '3');
INSERT INTO "Params" VALUES(1012, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1012, 'LOGTYPE', 'ErrorLog');
INSERT INTO "Params" VALUES(1012, 'NUMENTRIES', '3');
INSERT INTO "Params" VALUES(1013, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1013, 'LOGTYPE', 'MapLayerAccessLog');
INSERT INTO "Params" VALUES(1013, 'NUMENTRIES', '3');
INSERT INTO "Params" VALUES(1014, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1014, 'LOGTYPE', 'SessionLog');
INSERT INTO "Params" VALUES(1014, 'NUMENTRIES', '3');
INSERT INTO "Params" VALUES(1015, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1015, 'LOGTYPE', 'TraceLog');
INSERT INTO "Params" VALUES(1015, 'NUMENTRIES', '3');
INSERT INTO "Params" VALUES(1016, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1016, 'LOGTYPE', 'InvalidLog');
INSERT INTO "Params" VALUES(1016, 'NUMENTRIES', '3');
INSERT INTO "Params" VALUES(1017, 'OPERATION', 'GETLOG');
INSERT INTO "Params" VALUES(1017, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(1017, 'NUMENTRIES', '-1');
INSERT INTO "Params" VALUES(1018, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1018, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(1018, 'FROMDATE', '2005,1,2,3,0,0,0');
INSERT INTO "Params" VALUES(1018, 'TODATE', '2005,1,3,0,0,0,0');
INSERT INTO "Params" VALUES(1019, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1019, 'LOGTYPE', 'AdminLog');
INSERT INTO "Params" VALUES(1019, 'FROMDATE', '2005,1,2,3,0,0,0');
INSERT INTO "Params" VALUES(1019, 'TODATE', '2005,1,3,0,0,0,0');
INSERT INTO "Params" VALUES(1020, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1020, 'LOGTYPE', 'AuthenticationLog');
INSERT INTO "Params" VALUES(1020, 'FROMDATE', '2005,1,2,3,0,0,0');
INSERT INTO "Params" VALUES(1020, 'TODATE', '2005,1,3,0,0,0,0');
INSERT INTO "Params" VALUES(1021, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1021, 'LOGTYPE', 'ErrorLog');
INSERT INTO "Params" VALUES(1021, 'FROMDATE', '2005,1,2,3,0,0,0');
INSERT INTO "Params" VALUES(1021, 'TODATE', '2005,1,3,0,0,0,0');
INSERT INTO "Params" VALUES(1022, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1022, 'LOGTYPE', 'SessionLog');
INSERT INTO "Params" VALUES(1022, 'FROMDATE', '2005,1,2,3,0,0,0');
INSERT INTO "Params" VALUES(1022, 'TODATE', '2005,1,3,0,0,0,0');
INSERT INTO "Params" VALUES(1023, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1023, 'LOGTYPE', 'TraceLog');
INSERT INTO "Params" VALUES(1023, 'FROMDATE', '2005,1,2,3,0,0,0');
INSERT INTO "Params" VALUES(1023, 'TODATE', '2005,1,3,0,0,0,0');
INSERT INTO "Params" VALUES(1024, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1024, 'LOGTYPE', 'DoesNotExist');
INSERT INTO "Params" VALUES(1024, 'FROMDATE', '2005,1,2,3,0,0,0');
INSERT INTO "Params" VALUES(1024, 'TODATE', '2005,1,3,0,0,0,0');
INSERT INTO "Params" VALUES(1025, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1025, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(1025, 'FROMDATE', '');
INSERT INTO "Params" VALUES(1025, 'TODATE', '');
INSERT INTO "Params" VALUES(1026, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1026, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(1026, 'FROMDATE', '2005,1,2,3,4,5,6');
INSERT INTO "Params" VALUES(1026, 'TODATE', '2005,1,1,3,4,5,6');
INSERT INTO "Params" VALUES(1027, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1027, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(1027, 'FROMDATE', '2005,1,2,0,0,0,0');
INSERT INTO "Params" VALUES(1027, 'TODATE', '2005,1,3,0,0,0,1');
INSERT INTO "Params" VALUES(1028, 'OPERATION', 'GETLOGBYDATE');
INSERT INTO "Params" VALUES(1028, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(1028, 'FROMDATE', '2005,1,2');
INSERT INTO "Params" VALUES(1028, 'TODATE', '2005,1,2,0,0,0,0');
INSERT INTO "Params" VALUES(2001, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(2001, 'LOGTYPE', 'AuthenticationLog');
INSERT INTO "Params" VALUES(2002, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(2002, 'LOGTYPE', 'ErrorLog');
INSERT INTO "Params" VALUES(2003, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(2003, 'LOGTYPE', 'MapLayerAccessLog');
INSERT INTO "Params" VALUES(2004, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(2004, 'LOGTYPE', 'SessionLog');
INSERT INTO "Params" VALUES(2005, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(2005, 'LOGTYPE', 'TraceLog');
INSERT INTO "Params" VALUES(2006, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(2006, 'LOGTYPE', 'InvalidLog');
INSERT INTO "Params" VALUES(2007, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(2007, 'LOGTYPE', 'AccessLog');
INSERT INTO "Params" VALUES(2008, 'OPERATION', 'CLEARLOG');
INSERT INTO "Params" VALUES(2008, 'LOGTYPE', 'AdminLog');
INSERT INTO "Params" VALUES(4001, 'OPERATION', 'DELETELOG');
INSERT INTO "Params" VALUES(4001, 'FILENAME', 'DoesNotExist.log');
INSERT INTO "Params" VALUES(4002, 'OPERATION', 'DELETELOG');
INSERT INTO "Params" VALUES(4002, 'FILENAME', '');
INSERT INTO "Params" VALUES(4002, 'DELETELOG', '');
INSERT INTO "Params" VALUES(5001, 'OPERATION', 'RENAMELOG');
INSERT INTO "Params" VALUES(5001, 'OLDFILENAME', 'DoesNotExist.log');
INSERT INTO "Params" VALUES(5001, 'NEWFILENAME', 'NewLogName.log');
INSERT INTO "Params" VALUES(5002, 'OPERATION', 'RENAMELOG');
INSERT INTO "Params" VALUES(5002, 'OLDFILENAME', '');
INSERT INTO "Params" VALUES(5002, 'NEWFILENAME', 'ThisWillNotBeCreated');
INSERT INTO "Params" VALUES(5003, 'OPERATION', 'RENAMELOG');
INSERT INTO "Params" VALUES(5003, 'OLDFILENAME', 'SomeLog.log');
INSERT INTO "Params" VALUES(5003, 'NEWFILENAME', '');
INSERT INTO "Params" VALUES(5004, 'OPERATION', 'RENAMELOG');
INSERT INTO "Params" VALUES(5004, 'OLDFILENAME', 'SameLogName.log');
INSERT INTO "Params" VALUES(5004, 'NEWFILENAME', 'SameLogName.log');
INSERT INTO "Params" VALUES(5005, 'OPERATION', 'RENAMELOG');
INSERT INTO "Params" VALUES(5005, 'OLDFILENAME', 'Access.log');
INSERT INTO "Params" VALUES(5005, 'NEWFILENAME', 'Admin.log');
INSERT INTO "Params" VALUES(12, 'LOGTYPE', 'SessionLog');
INSERT INTO "Params" VALUES(1002, 'ALWAYSPASS', '');
INSERT INTO "Params" VALUES(1004, 'ALWAYSPASS', '');
INSERT INTO "Params" VALUES(1006, 'ALWAYSPASS', '');
INSERT INTO "Params" VALUES(1010, 'ALWAYSPASS', '');
INSERT INTO "Params" VALUES(1012, 'ALWAYSPASS', '');
INSERT INTO "Params" VALUES(1014, 'ALWAYSPASS', '');
INSERT INTO "Params" VALUES(5001, 'ALWAYSPASS', '');
INSERT INTO "Params" VALUES(5004, 'ALWAYSPASS', '');
INSERT INTO "Params" VALUES(5005, 'ALWAYSPASS', '');
INSERT INTO "Params" VALUES(13, 'OPERATION', 'DELETELOG');
INSERT INTO "Params" VALUES(13, 'FILENAME', 'somelog.log');
INSERT INTO "Params" VALUES(14, 'OPERATION', 'LOADPACKAGE');
INSERT INTO "Params" VALUES(14, 'PACKAGENAME', 'doesnotexist.mgp');
INSERT INTO "Params" VALUES(15, 'OPERATION', 'GETPACKAGELOG');
INSERT INTO "Params" VALUES(15, 'PACKAGENAME', 'doesnotexist.mgp');
INSERT INTO "Params" VALUES(16, 'OPERATION', 'GETPACKAGESTATUS');
INSERT INTO "Params" VALUES(16, 'PACKAGENAME', 'doesnotexist.mgp');
INSERT INTO "Params" VALUES(6001, 'PACKAGENAME', '../invalid.mgp');
INSERT INTO "Params" VALUES(6001, 'OPERATION', 'LOADPACKAGE');
INSERT INTO "Params" VALUES(6002, 'OPERATION', 'LOADPACKAGE');
INSERT INTO "Params" VALUES(6002, 'PACKAGENAME', 'doesnotexist.mgp');
INSERT INTO "Params" VALUES(6003, 'OPERATION', 'LOADPACKAGE');
INSERT INTO "Params" VALUES(6003, 'PACKAGENAME', '..\invalid.mgp');
INSERT INTO "Params" VALUES(6004, 'OPERATION', 'LOADPACKAGE');
INSERT INTO "Params" VALUES(6004, 'PACKAGENAME', '');
INSERT INTO "Params" VALUES(7001, 'OPERATION', 'DELETEPACKAGE');
INSERT INTO "Params" VALUES(7001, 'PACKAGENAME', '../invalid.mgp');
INSERT INTO "Params" VALUES(7002, 'OPERATION', 'DELETEPACKAGE');
INSERT INTO "Params" VALUES(7002, 'PACKAGENAME', '..\invalid.mgp');
INSERT INTO "Params" VALUES(7003, 'OPERATION', 'DELETEPACKAGE');
INSERT INTO "Params" VALUES(7003, 'PACKAGENAME', 'doesnotexist.mgp');
INSERT INTO "Params" VALUES(7004, 'OPERATION', 'DELETEPACKAGE');
INSERT INTO "Params" VALUES(7004, 'PACKAGENAME', '');
INSERT INTO "Params" VALUES(14, 'ALWAYSPASS', 'Operation returns machine dependent output. Thus, it is executed but not validated');
INSERT INTO "Params" VALUES(15, 'ALWAYSPASS', 'Operation returns machine dependent output. Thus, it is executed but not validated');
INSERT INTO "Params" VALUES(6002, 'ALWAYSPASS', 'The operation returns machine dependent output. Thus, it is executed but not validated');
INSERT INTO "Params" VALUES(7, 'ALWAYSPASS', 'true');
INSERT INTO "Params" VALUES(8, 'ALWAYSPASS', 'true');
CREATE TABLE CommonParams (ParamName text, ParamValue text);
INSERT INTO "CommonParams" VALUES('VERSION', '1.0.0');
INSERT INTO "CommonParams" VALUES('CREDENTIALS', 'qwerty');
INSERT INTO "CommonParams" VALUES('LOCALE', 'eng');
CREATE TABLE ApiTestResults (Description TEXT, ParamSet INTEGER, ContentType TEXT, Result TEXT);
INSERT INTO "ApiTestResults" VALUES('Get Version property', 1, 'text/plain', '');
INSERT INTO "ApiTestResults" VALUES('Get Information property', 2, 'text/plain', '');
INSERT INTO "ApiTestResults" VALUES('Put the server Offline', 3, 'text/plain', 'False');
INSERT INTO "ApiTestResults" VALUES('Put the server Online', 4, 'text/plain', 'True');
INSERT INTO "ApiTestResults" VALUES('Clears the admin log', 5, 'text/plain', 'True');
INSERT INTO "ApiTestResults" VALUES('Tries to clear an invalid log', 6, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Gets all entries in the admin log', 7, '', X'23204C6F6720547970653A2041646D696E204C6F670D0A23204C6F6720506172616D65746572733A20434C49454E542C434C49454E5449502C555345522C4F5049440D0A2009090941646D696E6973747261746F7209436C6561724C6F672E313A312841646D696E4C6F672920537563636573730D0A2009090941646D696E6973747261746F7209436C6561724C6F672E313A31286761726261676529204661696C7572650D0A');
INSERT INTO "ApiTestResults" VALUES('Gets the last 3 entries of the admin log', 8, '', X'2009090941646D696E6973747261746F7209436C6561724C6F672E313A312841646D696E4C6F672920537563636573730D0A2009090941646D696E6973747261746F7209436C6561724C6F672E313A31286761726261676529204661696C7572650D0A2009090941646D696E6973747261746F72094765744C6F672E313A312841646D696E4C6F672920537563636573730D0A');
INSERT INTO "ApiTestResults" VALUES('Tries to get an invalid number of admin log entries', 9, 'text/plain', X'6D67617267756D656E746F75746F6672616E6765657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to get admin log entries using dates', 10, '', '');
INSERT INTO "ApiTestResults" VALUES('Gets all entries in the access log', 1001, '', X'');
INSERT INTO "ApiTestResults" VALUES('Gets all entries in the admin log', 1002, '', X'202020436C6561724C6F672E313A312841646D696E4C6F67292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312830292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312831292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312832292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312830292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312833292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312830292053756363657373200D0A2020204765744C6F672E313A31284163636573734C6F67292053756363657373200D0A2020204765744C6F672E313A312841646D696E4C6F67292053756363657373200D0A2020204765744C6F672E313A312841757468656E7469636174696F6E4C6F67292053756363657373200D0A2020204765744C6F672E313A31284572726F724C6F67292053756363657373200D0A2020204765744C6F672E313A31284D61704C617965724163636573734C6F6729204661696C757265200D0A2020204765744C6F672E313A312853657373696F6E4C6F67292053756363657373200D0A2020204765744C6F672E313A312854726163654C6F67292053756363657373200D0A2020204765744C6F672E313A3128496E76616C69644C6F6729204661696C757265200D0A2020204765744C6F672E313A32284163636573734C6F672C33292053756363657373200D0A2020204765744C6F672E313A322841646D696E4C6F672C33292053756363657373200D0A2020204765744C6F672E313A322841757468656E7469636174696F6E4C6F672C33292053756363657373200D0A2020204765744C6F672E313A32284572726F724C6F672C33292053756363657373200D0A2020204765744C6F672E313A32284D61704C617965724163636573734C6F672C3329204661696C757265200D0A2020204765744C6F672E313A322853657373696F6E4C6F672C33292053756363657373200D0A2020204765744C6F672E313A322854726163654C6F672C33292053756363657373200D0A2020204765744C6F672E313A3228496E76616C69644C6F672C3329204661696C757265200D0A2020204765744C6F672E313A32284163636573734C6F672C2D3129204661696C757265200D0A2020204765744C6F672E313A33284163636573734C6F672C54494D455354414D502027323030352D312D3220333A303A302E30272C54494D455354414D502027323030352D312D3320303A303A302E3027292053756363657373200D0A2020204765744C6F672E313A332841646D696E4C6F672C54494D455354414D502027323030352D312D3220333A303A302E30272C54494D455354414D502027323030352D312D3320303A303A302E3027292053756363657373200D0A2020204765744C6F672E313A332841757468656E7469636174696F6E4C6F672C54494D455354414D502027323030352D312D3220333A303A302E30272C54494D455354414D502027323030352D312D3320303A303A302E3027292053756363657373200D0A2020204765744C6F672E313A33284572726F724C6F672C54494D455354414D502027323030352D312D3220333A303A302E30272C54494D455354414D502027323030352D312D3320303A303A302E3027292053756363657373200D0A2020204765744C6F672E313A332853657373696F6E4C6F672C54494D455354414D502027323030352D312D3220333A303A302E30272C54494D455354414D502027323030352D312D3320303A303A302E3027292053756363657373200D0A2020204765744C6F672E313A332854726163654C6F672C54494D455354414D502027323030352D312D3220333A303A302E30272C54494D455354414D502027323030352D312D3320303A303A302E3027292053756363657373200D0A2020204765744C6F672E313A3328446F65734E6F7445786973742C54494D455354414D502027323030352D312D3220333A303A302E30272C54494D455354414D502027323030352D312D3320303A303A302E302729204661696C757265200D0A2020204765744C6F672E313A33284163636573734C6F672C4E554C4C2C4E554C4C29204661696C757265200D0A2020204765744C6F672E313A33284163636573734C6F672C54494D455354414D502027323030352D312D3220333A343A352E303030303036272C54494D455354414D502027323030352D312D3120333A343A352E3030303030362729204661696C757265200D0A2020204765744C6F672E313A33284163636573734C6F672C54494D455354414D502027323030352D312D3220303A303A302E30272C54494D455354414D502027323030352D312D3320303A303A302E3030303030312729204661696C757265200D0A2020204765744C6F672E313A33284163636573734C6F672C54494D455354414D502027323030352D312D3220303A303A302E30272C54494D455354414D502027323030352D312D3220303A303A302E3027292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312830292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312831292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312832292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312830292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312833292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A20202041757468656E7469636174652E313A3328417755736572496E666F726D6174696F6E2C4177537472696E67436F6C6C656374696F6E2C66616C7365292053756363657373200D0A202020526571756573745365727665722E313A312830292053756363657373200D0A2020204765744C6F672E313A31284163636573734C6F67292053756363657373200D0A');
INSERT INTO "ApiTestResults" VALUES('Gets all entries in the authentication log', 1003, '', X'');
INSERT INTO "ApiTestResults" VALUES('Gets all entries in the map layer access log', 1005, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Gets all entries in the session log', 1006, '', X'202020302E30313038383120312031200D0A202020302E30313035393420312031200D0A202020302E30313435353020312031200D0A202020302E30313035323820312031200D0A202020302E30333036333120312031200D0A202020302E30313330363720312031200D0A202020302E30303934333720312031200D0A202020302E30313135343220312031200D0A202020302E30313132383320312031200D0A202020302E30313032303920312031200D0A202020302E30313235353220312031200D0A202020302E30303839333320312031200D0A202020302E30303739303020312031200D0A202020302E30313036303020312031200D0A202020302E30313133303420312031200D0A202020302E30303738373120312031200D0A202020302E30313034373920312031200D0A202020302E30313033353520312031200D0A202020302E30313037343720312031200D0A202020302E30313135393220312031200D0A202020302E30303931393520312031200D0A202020302E30313034313520312031200D0A202020302E30313137383220312031200D0A202020302E30303935363320312031200D0A202020302E30313138383320312031200D0A202020302E30303937313420312031200D0A202020302E30313131323920312031200D0A202020302E30303935393920312031200D0A202020302E30313532353020312031200D0A202020302E30313530393220312031200D0A202020302E30303836343120312031200D0A202020302E30313631343320312031200D0A202020302E30303834393720312031200D0A202020302E30313032303920312031200D0A202020302E30303938303320312031200D0A202020302E30303937363720312031200D0A202020302E30313332353420312031200D0A202020302E30313037333720312031200D0A202020302E30303937323420312031200D0A202020302E30313336303420312031200D0A202020302E30313430373320312031200D0A202020302E30323234343920312031200D0A202020302E30313236363820312031200D0A202020302E30313237343720312031200D0A202020302E30313436333220312031200D0A202020302E30313239323620312031200D0A202020302E30313035393120312031200D0A202020302E30313431323820312031200D0A202020302E30313433323720312031200D0A202020302E30313439323020312031200D0A202020302E30313838303820312031200D0A202020302E30333131353420312031200D0A202020302E30313633393120312031200D0A202020302E30313038333020312031200D0A202020302E30313036323020312031200D0A202020302E30313231303620312031200D0A202020302E30313130383120312031200D0A202020302E30313038303520312031200D0A202020302E30313233333320312031200D0A202020302E30303939353820312031200D0A202020302E30313137373820312031200D0A202020302E30313135383520312031200D0A202020302E30313135313920312031200D0A202020302E30313234343520312031200D0A202020302E30313234323820312031200D0A202020302E30313230303720312031200D0A202020302E30313130373320312031200D0A202020302E30313139383320312031200D0A202020302E30313137373020312031200D0A202020302E30313233323020312031200D0A202020302E30313235363220312031200D0A202020302E30313133393720312031200D0A202020302E30313032323920312031200D0A202020302E30303938393120312031200D0A202020302E30313138303020312031200D0A202020302E30313539353120312031200D0A');
INSERT INTO "ApiTestResults" VALUES('Gets all entries in the trace log', 1007, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to get all entries of an invalid log', 1008, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Gets last 3 entries of the access log', 1009, '', X'');
INSERT INTO "ApiTestResults" VALUES('Gets last 3 entries of the admin log', 1010, '', X'2041646D696E6973747261746F72094765744C6F672E313A312854726163654C6F672920537563636573730D0A2041646D696E6973747261746F72094765744C6F672E313A3128496E76616C69644C6F6729204661696C7572650D0A2041646D696E6973747261746F72094765744C6F672E313A32284163636573734C6F672C332920537563636573730D0A');
INSERT INTO "ApiTestResults" VALUES('Gets last 3 entries of the authentication log', 1011, '', X'');
INSERT INTO "ApiTestResults" VALUES('Gets last 3 entries of the map layer access log', 1013, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Gets last 3 entries of the session log', 1014, '', X'202020302E30313133353720312031200D0A202020302E30313133373320312031200D0A202020302E30313537333820312031200D0A');
INSERT INTO "ApiTestResults" VALUES('Gets last 3 entries of the trace log', 1015, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to get last 3 entries of an invalid log', 1016, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to get an invalid number of entries from the access log', 1017, 'text/plain', X'6D67617267756D656E746F75746F6672616E6765657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to get entires from that session log that occurred between 2 dates', 1022, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to get entires from that error log that occurred between 2 dates', 1021, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to get entires from that admin log that occurred between 2 dates', 1019, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to get entires from that authentication log that occurred between 2 dates', 1020, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to get entires from that trace log that occurred between 2 dates', 1023, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to get entires from that access log that occurred between 2 dates', 1018, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to get entires from an invalid log', 1024, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('This test case tries to use a null date when getting log contents by date', 1025, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('This test case tries to use a fromdate that comes after the todate', 1026, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Try to use dates that are more than 24 hours apart', 1027, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Try to use a date that has no time', 1028, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Clears the admin log', 2001, 'text/plain', 'True');
INSERT INTO "ApiTestResults" VALUES('Clears the authentication log', 2002, 'text/plain', 'True');
INSERT INTO "ApiTestResults" VALUES('Clears the error log', 2003, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Clears the map layer access log', 2004, 'text/plain', X'54727565');
INSERT INTO "ApiTestResults" VALUES('Clears the session log', 2005, 'text/plain', 'True');
INSERT INTO "ApiTestResults" VALUES('Clears the trace log', 2006, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to clear an invalid log', 2007, 'text/plain', X'54727565');
INSERT INTO "ApiTestResults" VALUES('Clears the access log', 2008, 'text/plain', 'True');
INSERT INTO "ApiTestResults" VALUES('Clears the access log', 11, 'text/plain', 'True');
INSERT INTO "ApiTestResults" VALUES('Tries to delete a log that doesn''t exist', 4001, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to delete a log with filename blank', 4002, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to rename a log that does not exist', 5001, 'text/plain', 'The specified file was not found: C:\Program Files\Autodesk\TuxServer2007\Logs\DoesNotExist.log');
INSERT INTO "ApiTestResults" VALUES('Tries to rename a log with a blank filename', 5002, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to rename a log to a blank file name', 5003, 'text/plain', X'6D676E756C6C617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Clears the session log', 12, 'text/plain', 'True');
INSERT INTO "ApiTestResults" VALUES('Tries to rename a log to its own filename', 5004, 'text/plain', 'File already exists: C:\Program Files\Autodesk\TuxServer2007\Logs\SameLogName.log');
INSERT INTO "ApiTestResults" VALUES('Tries to rename a log to a file that already exists', 5005, 'text/plain', 'File already exists: C:\Program Files\Autodesk\TuxServer2007\Logs\Admin.log');
INSERT INTO "ApiTestResults" VALUES('Tries to delete a log', 13, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to load a package that does not exist', 14, 'text/plain', 'The specified file was not found: C:\Program Files\Autodesk\TuxServer2007\Packages\doesnotexist.mgp');
INSERT INTO "ApiTestResults" VALUES('Tries to get the log of a package that does not exist', 15, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to get the status of a package that does not exist', 16, 'text/plain', 'UNKNOWN');
INSERT INTO "ApiTestResults" VALUES('Tries to load a package with an invalid name', 6001, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to load a package that does not exist', 6002, 'text/plain', 'The specified file was not found: C:\Program Files\Autodesk\TuxServer2007\Packages\doesnotexist.mgp');
INSERT INTO "ApiTestResults" VALUES('Tries to load a package with an invalid name', 6003, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to load a package with an invalid name', 6004, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to delete a package with an invalid name', 7001, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to delete a package with an invalid name', 7002, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
INSERT INTO "ApiTestResults" VALUES('Tries to delete a package that does not exist', 7003, '', '');
INSERT INTO "ApiTestResults" VALUES('Tries to delete a package with an invalid name', 7004, 'text/plain', X'6D67696E76616C6964617267756D656E74657863657074696F6E');
CREATE TABLE TestCase (ExecuteSequence INTEGER, TestName TEXT, ParamSets TEXT, Description TEXT, TestType TEXT, Prerequisite TEXT);
INSERT INTO "TestCase" VALUES(1, 'ServerAdmin_AllTests', '3,4,5,6,7,8,9,10,11,12,13,14,15,16,', 'Runs all server admin operations in the database', 'Api', 'None');
INSERT INTO "TestCase" VALUES(2, 'ServerAdmin_ClearLogApiBranchTest', '2001,2002,2003,2004,2005,2006,2007,2008,', 'Tests cover branches of ClearLog', 'Api', 'None');
INSERT INTO "TestCase" VALUES(3, 'ServerAdmin_GetLogApiBranchTest', '1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,', 'Tests cover branches of GetLog', 'Api', 'Run ServerAdmin:ClearLogApiBranchTest first');
INSERT INTO "TestCase" VALUES(4, 'ServerAdmin_DeleteLogApiBranchTest', '4001,4002,', 'Tests cover branches of DeleteLog', 'Api', 'Run preceding tests first');
INSERT INTO "TestCase" VALUES(5, 'ServerAdmin_RenameLogApiBranchTest', '5001,5002,5003,5004,5005,', 'Tests cover branches of RenameLog', 'Api', 'Run preceding tests first');
INSERT INTO "TestCase" VALUES(6, 'ServerAdmin_LoadPackageApiBranceTest', '6001,6002,6003,6004,', 'Tests cover branches of LoadPackage', 'Api', 'None');
INSERT INTO "TestCase" VALUES(7, 'ServerAdmin_DeletePackageApiBranchTest', '7001,7002,7003,7004,', 'Tests cover branches of DeletePackage', 'Api', 'None');
COMMIT;