PRAGMA foreign_keys=OFF;
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','');
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','mginvalidargumentexception');
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','mginvalidargumentexception');
INSERT INTO "ApiTestResults" VALUES('Tries to rename a log to a blank file name',5003,'text/plain','mginvalidargumentexception');
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;