12cae138fSstephan<!doctype html> 22cae138fSstephan<html lang="en-us"> 32cae138fSstephan <head> 42cae138fSstephan <meta charset="utf-8"> 52cae138fSstephan <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 62cae138fSstephan <link rel="shortcut icon" href="data:image/x-icon;," type="image/x-icon"> 72cae138fSstephan <link rel="stylesheet" href="common/emscripten.css"/> 82cae138fSstephan <link rel="stylesheet" href="common/testing.css"/> 92cae138fSstephan <title>sqlite3-api batch SQL runner</title> 102cae138fSstephan </head> 112cae138fSstephan <body> 122cae138fSstephan <header id='titlebar'><span>sqlite3-api batch SQL runner</span></header> 132cae138fSstephan <!-- emscripten bits --> 142cae138fSstephan <figure id="module-spinner"> 152cae138fSstephan <div class="spinner"></div> 162cae138fSstephan <div class='center'><strong>Initializing app...</strong></div> 172cae138fSstephan <div class='center'> 182cae138fSstephan On a slow internet connection this may take a moment. If this 192cae138fSstephan message displays for "a long time", intialization may have 202cae138fSstephan failed and the JavaScript console may contain clues as to why. 212cae138fSstephan </div> 222cae138fSstephan </figure> 232cae138fSstephan <div class="emscripten" id="module-status">Downloading...</div> 242cae138fSstephan <div class="emscripten"> 252cae138fSstephan <progress value="0" max="100" id="module-progress" hidden='1'></progress> 262cae138fSstephan </div><!-- /emscripten bits --> 272f06bf25Sstephan <p> 2849cb8d73Sstephan This page is for batch-running extracts from the output 2949cb8d73Sstephan of <tt>speedtest1 --script</tt>, as well as other standalone SQL 3049cb8d73Sstephan scripts. 312f06bf25Sstephan </p> 322f06bf25Sstephan <p id='warn-list' class='warning'>ACHTUNG: this file requires a generated input list 332cae138fSstephan file. Run "make batch" from this directory to generate it. 342cae138fSstephan </p> 355ad36319Sstephan <p id='warn-opfs' class='warning hidden'>WARNING: if the WASMFS/OPFS layer crashes, this page may 365ad36319Sstephan become completely unresponsive and need to be closed and reloaded to recover. 375ad36319Sstephan </p> 385ad36319Sstephan <p id='warn-websql' class='warning hidden'>WARNING: WebSQL's limited API requires that 395ad36319Sstephan this app split up SQL batches into separate statements for execution. That will 405ad36319Sstephan only work so long as semicolon characters are <em>only</em> used to terminate 415ad36319Sstephan SQL statements, and not used within string literals or the like. 422cae138fSstephan </p> 432cae138fSstephan <hr> 44cb22bd80Sstephan <fieldset id='toolbar'> 45cb22bd80Sstephan <div> 462f06bf25Sstephan <select class='disable-during-eval' id='sql-select'> 472cae138fSstephan <option disabled selected>Populated via script code</option> 482cae138fSstephan </select> 492f06bf25Sstephan <button class='disable-during-eval' id='sql-run'>Run selected SQL</button> 502f06bf25Sstephan <button class='disable-during-eval' id='sql-run-next'>Run next...</button> 512f06bf25Sstephan <button class='disable-during-eval' id='sql-run-remaining'>Run all remaining...</button> 52cb22bd80Sstephan <button class='disable-during-eval' id='export-metrics' disabled>Export metrics (WIP)<br>(broken by refactoring)</button> 532f06bf25Sstephan <button class='disable-during-eval' id='db-reset'>Reset db</button> 542cae138fSstephan <button id='output-clear'>Clear output</button> 555ad36319Sstephan <span class='input-wrapper flex-col'> 565ad36319Sstephan <label for='select-impl'>Storage impl:</label> 575ad36319Sstephan <select id='select-impl'> 585ad36319Sstephan <option value='virtualfs'>Virtual filesystem</option> 595ad36319Sstephan <option value='memdb'>:memory:</option> 605ad36319Sstephan <option value='wasmfs-opfs'>WASMFS OPFS</option> 615ad36319Sstephan <option value='websql'>WebSQL</option> 625ad36319Sstephan </select> 6353f635dfSstephan </span> 64cb22bd80Sstephan </fieldset> 652cae138fSstephan </div> 662cae138fSstephan <hr> 675ad36319Sstephan <span class='input-wrapper'> 685ad36319Sstephan <input type='checkbox' class='disable-during-eval' id='cb-reverse-log-order' checked></input> 695ad36319Sstephan <label for='cb-reverse-log-order'>Reverse log order (newest first)</label> 705ad36319Sstephan </span> 712cae138fSstephan <div id='test-output'></div> 72*cd0df83cSstephan <script src="jswasm/sqlite3.js"></script> 732cae138fSstephan <script src="common/SqliteTestUtil.js"></script> 742cae138fSstephan <script src="batch-runner.js"></script> 755ad36319Sstephan <style> 765ad36319Sstephan .flex-col { 775ad36319Sstephan display: flex; 785ad36319Sstephan flex-direction: column; 795ad36319Sstephan } 80cb22bd80Sstephan #toolbar > div { 815ad36319Sstephan display: flex; 825ad36319Sstephan flex-direction: row; 835ad36319Sstephan flex-wrap: wrap; 845ad36319Sstephan } 85cb22bd80Sstephan #toolbar > div > * { 865ad36319Sstephan margin: 0.25em; 875ad36319Sstephan } 885ad36319Sstephan </style> 892cae138fSstephan </body> 902cae138fSstephan</html> 91