xref: /sqlite-3.40.0/ext/wasm/batch-runner.html (revision 49cb8d73)
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>
28*49cb8d73Sstephan      This page is for batch-running extracts from the output
29*49cb8d73Sstephan      of <tt>speedtest1 --script</tt>, as well as other standalone SQL
30*49cb8d73Sstephan      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>
352f06bf25Sstephan    <p id='warn-opfs' class='warning'>WARNING: if the WASMFS/OPFS layer crashes, this page may
362cae138fSstephan      become completely unresponsive and need to be closed and
372cae138fSstephan      reloaded to recover.
382cae138fSstephan    </p>
392cae138fSstephan    <hr>
402cae138fSstephan    <div>
412f06bf25Sstephan      <select class='disable-during-eval' id='sql-select'>
422cae138fSstephan        <option disabled selected>Populated via script code</option>
432cae138fSstephan      </select>
442f06bf25Sstephan      <button class='disable-during-eval' id='sql-run'>Run selected SQL</button>
452f06bf25Sstephan      <button class='disable-during-eval' id='sql-run-next'>Run next...</button>
462f06bf25Sstephan      <button class='disable-during-eval' id='sql-run-remaining'>Run all remaining...</button>
4753f635dfSstephan      <button class='disable-during-eval' id='export-metrics'>Export metrics (WIP)</button>
482f06bf25Sstephan      <button class='disable-during-eval' id='db-reset'>Reset db</button>
492cae138fSstephan      <button id='output-clear'>Clear output</button>
5053f635dfSstephan      <span class='input-wrapper'>
5153f635dfSstephan        <input type='checkbox' class='disable-during-eval' id='cb-reverse-log-order' checked></input>
5253f635dfSstephan        <label for='cb-reverse-log-order'>Reverse log order</label>
5353f635dfSstephan      </span>
542cae138fSstephan    </div>
552cae138fSstephan    <hr>
5653f635dfSstephan    <div id='reverse-log-notice' class='hidden'>(Log output is in reverse order, newest first!)</div>
572cae138fSstephan    <div id='test-output'></div>
582cae138fSstephan
592cae138fSstephan    <script src="sqlite3.js"></script>
602cae138fSstephan    <script src="common/SqliteTestUtil.js"></script>
612cae138fSstephan    <script src="batch-runner.js"></script>
622cae138fSstephan    <style>
632f06bf25Sstephan      body {
642f06bf25Sstephan          display: flex;
652f06bf25Sstephan          flex-direction: column;
662f06bf25Sstephan          flex-wrap: wrap;
672f06bf25Sstephan      }
682cae138fSstephan      .warning { color: firebrick; }
6953f635dfSstephan      .input-wrapper {
7053f635dfSstephan          white-space: nowrap;
7153f635dfSstephan      }
722cae138fSstephan      #test-output {
732cae138fSstephan          border: 1px inset;
742cae138fSstephan          padding: 0.25em;
752f06bf25Sstephan          /*max-height: 30em;*/
762cae138fSstephan          overflow: auto;
772cae138fSstephan          white-space: break-spaces;
7853f635dfSstephan          display: flex; flex-direction: column;
7953f635dfSstephan      }
8053f635dfSstephan      #test-output.reverse {
8153f635dfSstephan          flex-direction: column-reverse;
8253f635dfSstephan      }
8353f635dfSstephan      .hidden {
8453f635dfSstephan          position: absolute !important;
8553f635dfSstephan          opacity: 0 !important;
8653f635dfSstephan          pointer-events: none !important;
8753f635dfSstephan          display: none !important;
882cae138fSstephan      }
892cae138fSstephan    </style>
902cae138fSstephan  </body>
912cae138fSstephan</html>
92