niceSOFT/sqlite: Official Git mirror of the SQLite source tree

ext/wasm/batch-runner.html

90 строк4 KB

stephan

Apply considerable acrobatics to get the JS/WASM deliverables building to and loadable from a directory other than the one which contains the app-level code. Requires an only-slightly-leaky abstraction of passing a URL argument when loading sqlite3.js but provides much greater flexibility in where the JS/WASM files are located.

19 окт 2022, 07:44

19 окт 2022, 07:44cd0df83

<!doctype html>
<html lang="en-us">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <link rel="shortcut icon" href="data:image/x-icon;," type="image/x-icon">
    <link rel="stylesheet" href="common/emscripten.css"/>
    <link rel="stylesheet" href="common/testing.css"/>
    <title>sqlite3-api batch SQL runner</title>
  </head>
  <body>
    <header id='titlebar'><span>sqlite3-api batch SQL runner</span></header>
    <!-- emscripten bits -->
    <figure id="module-spinner">
      <div class="spinner"></div>
      <div class='center'><strong>Initializing app...</strong></div>
      <div class='center'>
        On a slow internet connection this may take a moment.  If this
        message displays for "a long time", intialization may have
        failed and the JavaScript console may contain clues as to why.
      </div>
    </figure>
    <div class="emscripten" id="module-status">Downloading...</div>
    <div class="emscripten">
      <progress value="0" max="100" id="module-progress" hidden='1'></progress>  
    </div><!-- /emscripten bits -->
    <p>
      This page is for batch-running extracts from the output
      of <tt>speedtest1 --script</tt>, as well as other standalone SQL
      scripts.
    </p>
    <p id='warn-list' class='warning'>ACHTUNG: this file requires a generated input list
      file. Run "make batch" from this directory to generate it.
    </p>
    <p id='warn-opfs' class='warning hidden'>WARNING: if the WASMFS/OPFS layer crashes, this page may
      become completely unresponsive and need to be closed and reloaded to recover.
    </p>
    <p id='warn-websql' class='warning hidden'>WARNING: WebSQL's limited API requires that
      this app split up SQL batches into separate statements for execution. That will
      only work so long as semicolon characters are <em>only</em> used to terminate
      SQL statements, and not used within string literals or the like.
    </p>
    <hr>
    <fieldset id='toolbar'>
      <div>
        <select class='disable-during-eval' id='sql-select'>
          <option disabled selected>Populated via script code</option>
        </select>
        <button class='disable-during-eval' id='sql-run'>Run selected SQL</button>
        <button class='disable-during-eval' id='sql-run-next'>Run next...</button>
        <button class='disable-during-eval' id='sql-run-remaining'>Run all remaining...</button>
        <button class='disable-during-eval' id='export-metrics' disabled>Export metrics (WIP)<br>(broken by refactoring)</button>
        <button class='disable-during-eval' id='db-reset'>Reset db</button>
        <button id='output-clear'>Clear output</button>
        <span class='input-wrapper flex-col'>
          <label for='select-impl'>Storage impl:</label>
          <select id='select-impl'>
            <option value='virtualfs'>Virtual filesystem</option>
            <option value='memdb'>:memory:</option>
            <option value='wasmfs-opfs'>WASMFS OPFS</option>
            <option value='websql'>WebSQL</option>
          </select>
        </span>
      </fieldset>
    </div>
    <hr>
      <span class='input-wrapper'>
        <input type='checkbox' class='disable-during-eval' id='cb-reverse-log-order' checked></input>
        <label for='cb-reverse-log-order'>Reverse log order (newest first)</label>
      </span>
    <div id='test-output'></div>
    <script src="jswasm/sqlite3.js"></script>
    <script src="common/SqliteTestUtil.js"></script>
    <script src="batch-runner.js"></script>
    <style>
      .flex-col {
          display: flex;
          flex-direction: column;
      }
      #toolbar > div {
          display: flex;
          flex-direction: row;
          flex-wrap: wrap;
      }
      #toolbar > div > * {
          margin: 0.25em;
      }
    </style>
  </body>
</html>