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
|
const pullButton = document.getElementById("pull-button");
const pullResponse = document.getElementById("pull-response");
const resetInput = document.getElementById("reset-input");
const resetButton = document.getElementById("reset-button");
const resetResponse = document.getElementById("reset-response");
const queryForm = document.getElementById("query-form");
const queryResponse = document.getElementById("query-response");
pullButton.addEventListener("click", async e => {
const resp = await fetch("api/pull");
const res = await resp.json();
if (res.success) {
pullResponse.textContent = res.stdout;
} else {
console.log(res.error);
pullResponse.textContent = res.stderr;//.replace(/\n/g, "\n\r");
}
});
resetButton.addEventListener("click", async e => {
const uid = resetInput.value;
const body = JSON.stringify({ uid });
const method = "POST";
const resp = await fetch("api/reset", { method, body, headers: { "Content-Type": "application/json" } });
const res = await resp.json();
while (resetResponse.children.length > 0) resetResponse.removeChild(resetResponse.children[0]);
if (res.success) {
const b = document.createElement("b");
b.textContent = `${res.uid}: `;
const span = document.createElement("span");
span.textContent = res.pwd;
resetResponse.append(b, span);
} else {
console.log(res);
resetResponse.textContent = JSON.stringify(res.e);
}
});
queryForm.addEventListener("submit", async e => {
e.preventDefault();
const textarea = queryForm.querySelector("textarea");
const body = JSON.stringify({ query: textarea.value.trim() });
const resp = await fetch("api/query", {
method: "POST", body, headers: { "Content-Type": "application/json" }
});
const res = await resp.json();
while (queryResponse.children.length > 0) queryResponse.removeChild(queryResponse.children[0]);
if (res.success) { // SELECT response
if (Array.isArray(res.response) && res.response.length > 0) {
const keys = Object.keys(res.response[0]);
const head = document.createElement("thead");
for (const key of keys) {
const th = document.createElement("th");
th.textContent = key;
head.append(th);
}
for (const row of res.response) {
const tr = document.createElement("tr");
for (const colI in row) {
if (!row.hasOwnProperty(colI)) continue;
const td = document.createElement("td");
td.textContent = row[colI];
tr.append(td);
}
queryResponse.append(tr);
}
queryResponse.append(head);
} else { // other requests
const keys = Object.keys(res.response);
const head = document.createElement("thead");
for (const key of keys) {
const th = document.createElement("th");
th.textContent = key;
head.append(th);
}
const tr = document.createElement("tr");
for (const colI in res.response) {
if (!res.response.hasOwnProperty(colI)) continue;
const td = document.createElement("td");
td.textContent = res.response[colI];
tr.append(td);
}
queryResponse.append(head, tr);
}
} else if (!res.success && res.message) { // Error handling
const keys = Object.keys(res.message);
const head = document.createElement("thead");
for (const key of keys) {
const th = document.createElement("th");
th.textContent = key;
head.append(th);
}
const tr = document.createElement("tr");
for (const colI in res.message) {
if (!res.message.hasOwnProperty(colI)) continue;
const td = document.createElement("td");
td.textContent = res.message[colI];
tr.append(td);
}
queryResponse.append(head, tr);
}
});
|
