BEGIN TRANSACTION; CREATE TABLE TestCase (ExecuteSequence INTEGER, TestName TEXT, ParamSets TEXT, Description TEXT, TestType TEXT, Prerequisite TEXT); INSERT INTO "TestCase" VALUES(1, 'WebLayout_LoadMapDefinition', '1000,1001,', 'Load the web layout definition in the repository', 'Api', 'None'); INSERT INTO "TestCase" VALUES(2, 'WebLayout_AllTests', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39', 'Runs all web layout tests', 'Api', 'Run WebLayout_LoadMapDefinition test first'); CREATE TABLE Params (ParamSet INTEGER, ParamName TEXT, ParamValue TEXT); INSERT INTO "Params" VALUES(1000, 'OPERATION', 'DELETERESOURCE'); INSERT INTO "Params" VALUES(1000, 'RESOURCEID', 'Library://UnitTest/layouts/Test.WebLayout'); INSERT INTO "Params" VALUES(1000, 'ALWAYSPASS', 'Cleanup'); INSERT INTO "Params" VALUES(1001, 'OPERATION', 'SETRESOURCE'); INSERT INTO "Params" VALUES(1001, 'RESOURCEID', 'Library://UnitTest/layouts/Test.WebLayout'); INSERT INTO "Params" VALUES(1001, 'CONTENT', '..\..\TestData\WebLayout\Test.WebLayout'); INSERT INTO "Params" VALUES(1, 'OPERATION', 'WL_GETTITLE'); INSERT INTO "Params" VALUES(2, 'OPERATION', 'WL_GETMAPDEFINITION'); INSERT INTO "Params" VALUES(3, 'OPERATION', 'WL_GETSCALE'); INSERT INTO "Params" VALUES(4, 'OPERATION', 'WL_GETCENTER'); INSERT INTO "Params" VALUES(5, 'OPERATION', 'WL_SHOWTOOLBAR'); INSERT INTO "Params" VALUES(6, 'OPERATION', 'WL_SHOWSTATUSBAR'); INSERT INTO "Params" VALUES(7, 'OPERATION', 'WL_SHOWTASKPANE'); INSERT INTO "Params" VALUES(8, 'OPERATION', 'WL_SHOWTASKBAR'); INSERT INTO "Params" VALUES(9, 'OPERATION', 'WL_SHOWLEGEND'); INSERT INTO "Params" VALUES(10, 'OPERATION', 'WL_SHOWPROPERTIES'); INSERT INTO "Params" VALUES(11, 'OPERATION', 'WL_GETTASKPANEWIDTH'); INSERT INTO "Params" VALUES(12, 'OPERATION', 'WL_GETINFORMATIONPANEWIDTH'); INSERT INTO "Params" VALUES(13, 'OPERATION', 'WL_GETINITIALTASKURL'); INSERT INTO "Params" VALUES(14, 'OPERATION', 'WL_SHOWCONTEXTMENU'); INSERT INTO "Params" VALUES(15, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(15, 'CONTAINER', 'toolbar'); INSERT INTO "Params" VALUES(15, 'INDEX', '0'); INSERT INTO "Params" VALUES(16, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(16, 'CONTAINER', 'toolbar'); INSERT INTO "Params" VALUES(16, 'INDEX', '1'); INSERT INTO "Params" VALUES(17, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(17, 'CONTAINER', 'toolbar'); INSERT INTO "Params" VALUES(17, 'INDEX', '2'); INSERT INTO "Params" VALUES(18, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(18, 'CONTAINER', 'toolbar'); INSERT INTO "Params" VALUES(18, 'INDEX', '3'); INSERT INTO "Params" VALUES(19, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(19, 'CONTAINER', 'toolbar'); INSERT INTO "Params" VALUES(19, 'INDEX', '4'); INSERT INTO "Params" VALUES(20, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(20, 'CONTAINER', 'toolbar'); INSERT INTO "Params" VALUES(20, 'INDEX', '5'); INSERT INTO "Params" VALUES(21, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(21, 'CONTAINER', 'toolbar'); INSERT INTO "Params" VALUES(21, 'INDEX', '6'); INSERT INTO "Params" VALUES(22, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(22, 'CONTAINER', 'tasklist'); INSERT INTO "Params" VALUES(22, 'INDEX', '0'); INSERT INTO "Params" VALUES(23, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(23, 'CONTAINER', 'tasklist'); INSERT INTO "Params" VALUES(23, 'INDEX', '1'); INSERT INTO "Params" VALUES(24, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(24, 'CONTAINER', 'tasklist'); INSERT INTO "Params" VALUES(24, 'INDEX', '2'); INSERT INTO "Params" VALUES(25, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(25, 'CONTAINER', 'tasklist'); INSERT INTO "Params" VALUES(25, 'INDEX', '3'); INSERT INTO "Params" VALUES(26, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(26, 'CONTAINER', 'tasklist'); INSERT INTO "Params" VALUES(26, 'INDEX', '4'); INSERT INTO "Params" VALUES(27, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(27, 'CONTAINER', 'tasklist'); INSERT INTO "Params" VALUES(27, 'INDEX', '5'); INSERT INTO "Params" VALUES(28, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(28, 'CONTAINER', 'tasklist'); INSERT INTO "Params" VALUES(28, 'INDEX', '6'); INSERT INTO "Params" VALUES(29, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(29, 'CONTAINER', 'tasklist'); INSERT INTO "Params" VALUES(29, 'INDEX', '7'); INSERT INTO "Params" VALUES(30, 'OPERATION', 'WL_TESTUIITEM'); INSERT INTO "Params" VALUES(30, 'CONTAINER', 'tasklist'); INSERT INTO "Params" VALUES(30, 'INDEX', '8'); INSERT INTO "Params" VALUES(31, 'OPERATION', 'WL_HOMETOOLTIP'); INSERT INTO "Params" VALUES(32, 'OPERATION', 'WL_HOMEDESCRIPTION'); INSERT INTO "Params" VALUES(33, 'OPERATION', 'WL_BACKTOOLTIP'); INSERT INTO "Params" VALUES(34, 'OPERATION', 'WL_BACKDESCRIPTION'); INSERT INTO "Params" VALUES(35, 'OPERATION', 'WL_FORWARDTOOLTIP'); INSERT INTO "Params" VALUES(36, 'OPERATION', 'WL_FORWARDDESCRIPTION'); INSERT INTO "Params" VALUES(37, 'OPERATION', 'WL_TASKSNAME'); INSERT INTO "Params" VALUES(38, 'OPERATION', 'WL_TASKSTOOLTIP'); INSERT INTO "Params" VALUES(39, 'OPERATION', 'WL_TASKSDESCRIPTION'); CREATE TABLE CommonParams (ParamName text, ParamValue text); CREATE TABLE ApiTestResults (Description TEXT, ParamSet INTEGER, ContentType TEXT, Result TEXT); INSERT INTO "ApiTestResults" VALUES('Get map definition ID', 2, 'text/plain', 'Library://maps/World.MapDefinition'); INSERT INTO "ApiTestResults" VALUES('Get application title', 1, 'text/plain', 'World countries'); INSERT INTO "ApiTestResults" VALUES('Get map scale', 3, 'text/plain', '100000'); INSERT INTO "ApiTestResults" VALUES('Get map center', 4, 'text/plain', '10.5/-15'); INSERT INTO "ApiTestResults" VALUES('Show toolbar', 5, 'text/plain', 'True'); INSERT INTO "ApiTestResults" VALUES('Show statusbar', 6, 'text/plain', 'True'); INSERT INTO "ApiTestResults" VALUES('Show task pane', 7, 'text/plain', 'True'); INSERT INTO "ApiTestResults" VALUES('Show task bar', 8, 'text/plain', 'True'); INSERT INTO "ApiTestResults" VALUES('Show legend band', 9, 'text/plain', 'True'); INSERT INTO "ApiTestResults" VALUES('Show properties band', 10, 'text/plain', 'True'); INSERT INTO "ApiTestResults" VALUES('Get task pane width', 11, 'text/plain', '250'); INSERT INTO "ApiTestResults" VALUES('Get information pane width', 12, 'text/plain', '200'); INSERT INTO "ApiTestResults" VALUES('Get initial task URL', 13, 'text/plain', 'GettingStarted.php'); INSERT INTO "ApiTestResults" VALUES('Show context menu', 14, 'text/plain', 'True'); INSERT INTO "ApiTestResults" VALUES('Toolbar button 0', 15, 'text/plain', '[Label: Select/1/Select]'); INSERT INTO "ApiTestResults" VALUES('Toolbar button 1', 16, 'text/plain', '[/2]'); INSERT INTO "ApiTestResults" VALUES('Toolbar button 2', 17, 'text/plain', '[Label: Pan/1/Pan]'); INSERT INTO "ApiTestResults" VALUES('Toolbar button 3', 18, 'text/plain', '[/2]'); INSERT INTO "ApiTestResults" VALUES('Toolbar button 4', 19, 'text/plain', '[Zooms/3/stdicons/icon_open.gif/[Label: Zoom Dynamic/1/Zoom Dynamic]/[Label: Zoom In/1/Zoom In]/[Label: Zoom Out/1/Zoom Out]/[Label: Zoom Rectangle/1/Zoom Rectangle]/[/2]/[Label: Fit To Window/1/Fit To Window]]'); INSERT INTO "ApiTestResults" VALUES('Toolbar button 5', 20, 'text/plain', '[/2]'); INSERT INTO "ApiTestResults" VALUES('Toolbar button 6', 21, 'text/plain', '[More pans/3/stdicons/icon_open.gif/[Label: Pan Left/1/Pan Left]/[Label: Pan Up/1/Pan Up]/[Label: Pan Right/1/Pan Right]/[Label: Pan Down/1/Pan Down]]'); INSERT INTO "ApiTestResults" VALUES('Task list menu 0', 22, 'text/plain', '[Label: Select/1/Select]'); INSERT INTO "ApiTestResults" VALUES('Task list menu 1', 23, 'text/plain', '[/2]'); INSERT INTO "ApiTestResults" VALUES('Task list menu 2', 24, 'text/plain', '[Label: Pan/1/Pan]'); INSERT INTO "ApiTestResults" VALUES('Task list menu 3', 25, 'text/plain', '[/2]'); INSERT INTO "ApiTestResults" VALUES('Task list menu 4', 26, 'text/plain', '[Label: Zoom Dynamic/1/Zoom Dynamic]'); INSERT INTO "ApiTestResults" VALUES('Task list menu 5', 27, 'text/plain', '[Label: Zoom In/1/Zoom In]'); INSERT INTO "ApiTestResults" VALUES('Task list menu 6', 28, 'text/plain', '[Label: Zoom Out/1/Zoom Out]'); INSERT INTO "ApiTestResults" VALUES('Task list menu 7', 29, 'text/plain', '[Label: Zoom Rectangle/1/Zoom Rectangle]'); INSERT INTO "ApiTestResults" VALUES('Task list menu 8', 30, 'text/plain', '[Label: Fit To Window/1/Fit To Window]'); INSERT INTO "ApiTestResults" VALUES('Home button tooltip', 31, 'text/plain', 'Getting started'); INSERT INTO "ApiTestResults" VALUES('Home button description', 32, 'text/plain', 'Getting started - Help on basic viewer commands'); INSERT INTO "ApiTestResults" VALUES('Back button tooltip', 33, 'text/plain', 'Back'); INSERT INTO "ApiTestResults" VALUES('Back button description', 34, 'text/plain', 'Back to Previous page'); INSERT INTO "ApiTestResults" VALUES('Forward button tooltip', 35, 'text/plain', 'Forward'); INSERT INTO "ApiTestResults" VALUES('Forward button description', 36, 'text/plain', 'Forward to Next page'); INSERT INTO "ApiTestResults" VALUES('Tasks button name', 37, 'text/plain', 'Tasks'); INSERT INTO "ApiTestResults" VALUES('Tasks button tooltip', 38, 'text/plain', 'Task Menu'); INSERT INTO "ApiTestResults" VALUES('Tasks button description', 39, 'text/plain', 'Open the list of available tasks'); INSERT INTO "ApiTestResults" VALUES('', 1000, '', ''); INSERT INTO "ApiTestResults" VALUES('', 1001, '', ''); CREATE TABLE HttpTestResults (Description TEXT, ParamSet INTEGER, ContentType TEXT, Result BLOB); COMMIT;