-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathindex.html
More file actions
83 lines (68 loc) · 4.52 KB
/
index.html
File metadata and controls
83 lines (68 loc) · 4.52 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>AlaSQL - JavaScript SQL database console</title>
<link rel="stylesheet" href="style.css" type="text/css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/xls/0.7.6/xls.core.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.core.min.js"></script>
<script src='http://cdn.jsdelivr.net/alasql/latest/alasql.min.js'></script>
<style>
html{
margin: 4vw 1vw;
line-height: 1.5;
}
body{
max-width: 1200px;
margin: 0 auto;
}
</style>
</head>
<body>
<h1>AlaSQL - JavaScript SQL database console</h1>
<p>This is a demo console for AlaSQL javascript database. Read more information and documentation on
<a href="https://github.com/agershun/alasql">https://github.com/agershun/alasql</a></p>
<p>Enter <b>SOURCE 'world.sql'</b> to load sample database, then <b>SHOW TABLES</b>, and then <b>SELECT TOP 10 * FROM City</b>. Then enter <b>SELECT VALUE COUNT(*) FROM TXT('world.sql') WHERE LEN([0])>20</b> to count number of lines with length more than 20 characters</p>
<div id='myconsole'></div>
<p>
<tt><span id="useid">alasql</span> ></tt> <input id='myprompt' autofocus/>
</p>
<p><center><button onclick="showHelp()">Show list of commands</button></center></p>
<script>
var first = decodeURI(location.search.substr(1));
alasql.options.logtarget = 'myconsole';
alasql.prompt('myprompt','useid');
alasql.prompt('myprompt','useid', first);
function showHelp(){
alasql.log([
{command:'ALTER TABLE table RENAME TO table'},
{command:'ALTER TABLE table ADD COLUMN column coldef'},
{command:'ALTER TABLE table MODIFY COLUMN column coldef'},
{command:'ALTER TABLE table RENAME COLUMN column TO column'},
{command:'ALTER TABLE table DROP column'},
{command:'ATTACH engine DATABASE database'},
{command:'ASSERT value'},
{command:'CREATE [engine] DATABASE [IF NOT EXISTS] database'},
{command:'CREATE TABLE [IF NOT EXISTS] table (column definitions)'},
{command:'DELETE FROM table [WHERE expression]'},
{command:'DETACH DATABASE database'},
{command:'DROP [engine] DATABASE [IF EXISTS] database'},
{command:'DROP TABLE [IF EXISTS] table'},
{command:'INSERT INTO table VALUES value,...'},
{command:'INSERT INTO table DEFAULT VALUES'},
{command:'INSERT INTO table SELECT select'},
{command:'ROLLBACK [TRANSACTION]'},
{command:'SELECT [modificator] columns [INTO table] [FROM table,...] [[mode] JOIN [ON] [USING]] [WHERE ] [GROUP BY] [HAVING] [ORDER BY] '},
{command:'SET option value'},
{command:'SHOW [engine] DATABASES'},
{command:'SHOW TABLES'},
{command:'SHOW CREATE TABLE table'},
{command:'UPDATE table SET column1 = expression1, ... [WHERE expression]'},
{command:'USE [DATABASE] database'},
{command:'See also <a href="http://github/agershun/alasql">http://github/agershun/alasql</a> for more information'}
])
}
</script>
<a href="https://github.com/agershun/alasql" class="github-corner" aria-label="View source on Github"><svg width="80" height="80" viewBox="0 0 250 250" style="fill:#151513; color:#fff; position: absolute; top: 0; border: 0; right: 0;" aria-hidden="true"><path d="M0,0 L115,115 L130,115 L142,142 L250,250 L250,0 Z"></path><path d="M128.3,109.0 C113.8,99.7 119.0,89.6 119.0,89.6 C122.0,82.7 120.5,78.6 120.5,78.6 C119.2,72.0 123.4,76.3 123.4,76.3 C127.3,80.9 125.5,87.3 125.5,87.3 C122.9,97.6 130.6,101.9 134.4,103.2" fill="currentColor" style="transform-origin: 130px 106px;" class="octo-arm"></path><path d="M115.0,115.0 C114.9,115.1 118.7,116.5 119.8,115.4 L133.7,101.6 C136.9,99.2 139.9,98.4 142.2,98.6 C133.8,88.0 127.5,74.4 143.8,58.0 C148.5,53.4 154.0,51.2 159.7,51.0 C160.3,49.4 163.2,43.6 171.4,40.1 C171.4,40.1 176.1,42.5 178.8,56.2 C183.1,58.6 187.2,61.8 190.9,65.4 C194.5,69.0 197.7,73.2 200.1,77.6 C213.8,80.2 216.3,84.9 216.3,84.9 C212.7,93.1 206.9,96.0 205.4,96.6 C205.1,102.4 203.0,107.8 198.3,112.5 C181.9,128.9 168.3,122.5 157.7,114.1 C157.9,116.9 156.7,120.9 152.7,124.9 L141.0,136.5 C139.8,137.7 141.6,141.9 141.8,141.8 Z" fill="currentColor" class="octo-body"></path></svg></a><style>.github-corner:hover .octo-arm{animation:octocat-wave 560ms ease-in-out}@keyframes octocat-wave{0%,100%{transform:rotate(0)}20%,60%{transform:rotate(-25deg)}40%,80%{transform:rotate(10deg)}}@media (max-width:500px){.github-corner:hover .octo-arm{animation:none}.github-corner .octo-arm{animation:octocat-wave 560ms ease-in-out}}</style>
</body>
</html>