sql.js/examples/repl.html at master · sql-js/sql.js · GitHub

34 lines (30 loc) · 962 Bytes

<!doctype html>

<html>

<head>

</head>

<body>

<input type='text' id='input' placeholder="ENTER SOME SQL" size='50'

value="CREATE TABLE test(val);INSERT INTO test VALUES (666); SELECT * FROM test">

<button id='submit'>Execute</button>

//Open a blank database

var db;

initSqlJs({ locateFile: filename => `../dist/${filename}` }).then(function (SQL) {

db = new SQL.Database();

});

document.getElementById('submit').onclick = function () {

var sql = document.getElementById('input').value;

var result = '', error = '';

try { result = db.exec(sql); }

catch (e) { error = e; }

document.getElementById('result').innerHTML = JSON.stringify(result, null, ' ');

document.getElementById('error').innerHTML = error;

};

</script>

</body>

Expand file tree