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
|
const $ = require('jquery');
const cm = require("codemirror");
const { Pool } = require("pg");
require('datatables')(window, $);
require("codemirror/mode/sql/sql");
const editorContext = cm(document.getElementById("editor"), {
value: "select *\nfrom foo",
mode: "text/x-sql",
lineNumbers: true
});
const connectionPool = new Pool({
user: 'postgres',
host: 'localhost',
database: 'postgres',
password: '',
port: 5432
});
let dataTable;
function runQuery() {
var query = editorContext.getValue();
console.log(query);
connectionPool.query(query, (err, res) => {
console.log(err, res)
displayResults(res);
});
}
function displayResults(results) {
if(dataTable) {
dataTable.destroy();
_resultsTable().empty();
}
dataTable = _resultsTable().DataTable({
paging: false,
destroy: true,
data: results.rows,
columns: _mapColumnProperties(results)
});
}
function _mapColumnProperties(results) {
return results.fields.map(function (column) {
return {
"data": column.name,
"title": column.name
};
});
}
function _resultsTable() {
return $("#result-table");
}
$(document).ready(function () {
$('#run-query').click(runQuery);
})
|