-
Notifications
You must be signed in to change notification settings - Fork 3
/
index.js
42 lines (38 loc) · 1.24 KB
/
index.js
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
var express = require('express');
var exphbs = require('express-handlebars');
var fs = require('fs');
var initSqlJs = require('sql.js');
var filebuffer = fs.readFileSync('sqlitedb');
var all = {}
var app = express();
app.engine('handlebars', exphbs());
app.set('view engine', 'handlebars');
app.get('/', function (req, res) {
initSqlJs().then(function(SQL){
var db = new SQL.Database(filebuffer);
var schema = db.exec('SELECT name, sql FROM sqlite_master WHERE type="table";')[0].values;
schema.forEach(t => all[t[0]] = db.exec('SELECT * FROM ' + t[0]));
var renderedTables= '';
Object.keys(all).forEach(table => {
renderedTables+= '<span>' + table + '</span><table><tbody><tr>';
all[table][0].columns.forEach(column => {
renderedTables+= '<th>' + column + '</th>'
});
renderedTables+= '</tr>';
all[table][0].values.forEach(row => {
renderedTables+= '<tr>';
row.forEach(value => {
renderedTables+= '<td>' + value + '</td>'
});
renderedTables+= '</tr>';
});
renderedTables+= '</tbody></table>'
});
res.render('home', {
helpers: {
renderedTables: function () { return renderedTables; }
}
});
});
});
app.listen(3333);