forked from inloop/sqlite-viewer
-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
155 lines (127 loc) · 5.87 KB
/
index.html
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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
<!DOCTYPE html>
<html lang="en">
<head>
<link rel="stylesheet" type="text/css" href="css/main.css"/>
<meta charset="utf-8">
<meta name="description" content="sqlite file viewer">
<meta name="keywords" content="sqlite,viewer,db,database,online">
<meta name="author" content="Juraj Novák">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>SQLite Viewer</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/select2.css" rel="stylesheet">
<link href="css/select2-bootstrap.css" rel="stylesheet">
<link href="css/main.css" rel="stylesheet">
<link href="css/ribbons.min.css" rel="stylesheet">
<link rel="image_src" href="img/icon.png" />
<link rel="icon" type="image/png" href="img/icon.png"/>
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<img src="img/icon.png" style="display: none;"/>
<div id="main-container" class="container">
<div id="header">
<div class="row">
<div class="col-xs-6">
<img src="img/logo.svg" class="img-responsive pull-left" style="margin-right: 16px;"/>
<h3>SQLite Viewer</h3>
<p>view sqlite file online</p>
</div>
<div class="col-xs-6">
<a href="#" id="resizer" class="pull-right">
<i class="glyphicon glyphicon-resize-full"></i>
</a>
</div>
</div>
</div>
<div id="compat-error" class="alert alert-danger" style="display: none">
<div class="clearfix">
<img src="img/seriously.png" class="img-responsive pull-left"/>
<p>Sorry but your browser does not support some of new HTML5 features! Try using latest version of Google Chrome or
Firefox.</p>
</div>
</div>
<div class="panel panel-info" id="dropzone" onclick="dropzoneClick(this)">
<div id="drop-text" class="panel-body">
<b>Drop file here</b> to load content or click on this box to open file dialog.<br/>
<div class="nouploadinfo small">No file will be uploaded - uses only JavaScript HTML5 FileReader.<br/><br/>
</div>
<a id="sample-db-link" class="no-propagate small" href="examples/Chinook_Sqlite.sqlite">… or download & try this sample file</a>
</div>
<div id="drop-loading" class="panel-body" style="display: none">
<span class="glyphicon glyphicon-refresh glyphicon-refresh-animate"></span> <b>Processing file ...</b>
</div>
</div>
<div id="output-box" class="container-fluid">
<div class="row">
<div class="col-md-12">
<select id="tables" class="form-control select2" title="Table"></select><br />
</div>
<div class="col-md-11">
<div id="sql-editor" class="panel panel-default form-control form-control-lg" onkeydown="onKeyDown(event)"></div>
</div>
<div class="col-sm-1">
<button class="btn btn-sm btn-primary" id="sql-run" type="submit" onclick="executeSql(this)">Execute</button>
</div>
<div class="col-md-12">
<div style="overflow-x: auto">
<table id="data" class="table table-condensed table-bordered table-hover table-striped">
<thead>
<tr></tr>
</thead>
<tbody></tbody>
</table>
</div>
<div class="alert alert-danger box" id="error" style="display: none"></div>
</div>
</div>
</div>
<div class="alert alert-danger box" style="display: none"></div>
<div class="alert alert-warning box" style="display: none"></div>
<div class="alert alert-info box" style="display: none"></div>
</div>
<div id="bottom-bar" class="text-center">
<div class="inline">
<button class="btn btn-default btn-sm " id="page-prev" type="submit" onclick="setPage(this, false)"><span class="glyphicon glyphicon-chevron-left" aria-hidden="true"></span></button>
<a href="javascript:void(0)" data-toggle="tooltip" data-placement="top" onclick="setPage(this)" id="pager"></a>
<button class="btn btn-default btn-sm " id="page-next" type="submit" onclick="setPage(this, true)"><span class="glyphicon glyphicon-chevron-right" aria-hidden="true"></span></button>
</div>
</div>
<div class="container">
<footer>
© 2020, Juraj Novák<br>
<small>| <a href="http://inloop.github.io/">other projects</a> |</small>
</footer>
</div>
<input type="file" id="dropzone-dialog" style="opacity: 0;display:none">
<div class="ribbon right grey hidden-xs">
<a href="https://github.com/inloop/sqlite-viewer">Fork me on GitHub</a>
</div>
<script src="js/jquery-1.11.3.min.js"></script>
<script src="js/filereader.js"></script>
<script src="js/sql.js"></script>
<script src="js/select2.min.js"></script>
<script src="js/ace/ace.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/mindmup-editabletable.js"></script>
<script src="js/main.js?v=11"></script>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', 'UA-67535271-1', 'auto');
ga('send', 'pageview');
</script>
<script>
function onKeyDown(e) {
if ((e.ctrlKey || e.metaKey) && e.which == 13) {
executeSql()
}
}
</script>
</body>
</html>