xref: /sqlite-3.40.0/ext/wasm/batch-runner.html (revision 53f635df)
1<!doctype html>
2<html lang="en-us">
3  <head>
4    <meta charset="utf-8">
5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
6    <link rel="shortcut icon" href="data:image/x-icon;," type="image/x-icon">
7    <link rel="stylesheet" href="common/emscripten.css"/>
8    <link rel="stylesheet" href="common/testing.css"/>
9    <title>sqlite3-api batch SQL runner</title>
10  </head>
11  <body>
12    <header id='titlebar'><span>sqlite3-api batch SQL runner</span></header>
13    <!-- emscripten bits -->
14    <figure id="module-spinner">
15      <div class="spinner"></div>
16      <div class='center'><strong>Initializing app...</strong></div>
17      <div class='center'>
18        On a slow internet connection this may take a moment.  If this
19        message displays for "a long time", intialization may have
20        failed and the JavaScript console may contain clues as to why.
21      </div>
22    </figure>
23    <div class="emscripten" id="module-status">Downloading...</div>
24    <div class="emscripten">
25      <progress value="0" max="100" id="module-progress" hidden='1'></progress>
26    </div><!-- /emscripten bits -->
27    <p>
28      This page is for running extracts from the output of <tt>speedtest --script</tt>.
29    </p>
30    <p id='warn-list' class='warning'>ACHTUNG: this file requires a generated input list
31      file. Run "make batch" from this directory to generate it.
32    </p>
33    <p id='warn-opfs' class='warning'>WARNING: if the WASMFS/OPFS layer crashes, this page may
34      become completely unresponsive and need to be closed and
35      reloaded to recover.
36    </p>
37    <hr>
38    <div>
39      <select class='disable-during-eval' id='sql-select'>
40        <option disabled selected>Populated via script code</option>
41      </select>
42      <button class='disable-during-eval' id='sql-run'>Run selected SQL</button>
43      <button class='disable-during-eval' id='sql-run-next'>Run next...</button>
44      <button class='disable-during-eval' id='sql-run-remaining'>Run all remaining...</button>
45      <button class='disable-during-eval' id='export-metrics'>Export metrics (WIP)</button>
46      <button class='disable-during-eval' id='db-reset'>Reset db</button>
47      <button id='output-clear'>Clear output</button>
48      <span class='input-wrapper'>
49        <input type='checkbox' class='disable-during-eval' id='cb-reverse-log-order' checked></input>
50        <label for='cb-reverse-log-order'>Reverse log order</label>
51      </span>
52    </div>
53    <hr>
54    <div id='reverse-log-notice' class='hidden'>(Log output is in reverse order, newest first!)</div>
55    <div id='test-output'></div>
56
57    <script src="sqlite3.js"></script>
58    <script src="common/SqliteTestUtil.js"></script>
59    <script src="batch-runner.js"></script>
60    <style>
61      body {
62          display: flex;
63          flex-direction: column;
64          flex-wrap: wrap;
65      }
66      .warning { color: firebrick; }
67      .input-wrapper {
68          white-space: nowrap;
69      }
70      #test-output {
71          border: 1px inset;
72          padding: 0.25em;
73          /*max-height: 30em;*/
74          overflow: auto;
75          white-space: break-spaces;
76          display: flex; flex-direction: column;
77      }
78      #test-output.reverse {
79          flex-direction: column-reverse;
80      }
81      .hidden {
82          position: absolute !important;
83          opacity: 0 !important;
84          pointer-events: none !important;
85          display: none !important;
86      }
87    </style>
88  </body>
89</html>
90