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
|
"use strict";
const $ = require("jquery");
const cm = require("codemirror");
const { Pool } = require("pg");
require("datatables")(window, $);
require("codemirror/mode/sql/sql");
const Split = require("split.js");
const editorContext = cm(document.getElementById("editor"), {
value: "select *\nfrom information_schema.tables",
mode: "text/x-sql",
theme: "dracula",
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,
order: [],
dom: "tr",
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");
}
function _onKeyUp(event) {
if (event.ctrlKey && event.keyCode == 13) {
runQuery();
}
}
$(document).ready(function () {
// Event handlers
$("#run-query").click(runQuery);
$(document).keyup(_onKeyUp);
Split([".editor-row", ".results-row"], {
sizes: [50, 50],
direction: "vertical",
gutterSize: 10,
elementStyle: function (dimension, size, gutterSize) {
return {
"flex-basis": "calc(" + size + "% - " + gutterSize + "px"
}
},
gutterStyle: function (dimension, gutterSize) {
return {
"flex-basis": gutterSize + "px"
}
}
});
})
|