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
|
/* Copyright (C) 2020 C. McEnroe <june@causal.agency>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
#include <err.h>
#include <stdio.h>
#include <stdlib.h>
#include <sysexits.h>
#include "server.h"
const char *EventsAfterQuery = SQL(
SELECT
events.event,
events.time,
events.type,
names.nick,
names.user,
names.host,
events.target,
events.message
FROM events
JOIN contexts USING (context)
JOIN names USING (name)
WHERE contexts.network = :network
AND contexts.name = :context
AND coalesce(contexts.query = :query, true)
AND events.time >= strftime('%s', :time)
ORDER BY events.time
LIMIT :limit;
);
const char *EventsBeforeQuery = SQL(
WITH before AS (
SELECT
events.event,
events.time,
events.type,
names.nick,
names.user,
names.host,
events.target,
events.message
FROM events
JOIN contexts USING (context)
JOIN names USING (name)
WHERE contexts.network = :network
AND contexts.name = :context
AND coalesce(contexts.query = :query, true)
AND events.time < strftime('%s', :time)
ORDER BY events.time DESC
LIMIT :limit
)
SELECT *
FROM before
ORDER BY time;
);
enum kcgi_err pageEvents(struct kreq *req) {
if (!req->fieldmap[Network] || !req->fieldmap[Context]) {
return httpFail(req, KHTTP_400);
}
if (!req->fieldmap[After] && !req->fieldmap[Before]) {
return httpFail(req, KHTTP_400);
}
enum kcgi_err error = httpHead(req, KHTTP_200, KMIME_TEXT_HTML);
if (req->method == KMETHOD_HEAD) return error;
const char *network = req->fieldmap[Network]->parsed.s;
const char *context = req->fieldmap[Context]->parsed.s;
const char *time = req->fieldmap[Before]
? req->fieldmap[Before]->parsed.s
: req->fieldmap[After]->parsed.s;
struct khtmlreq html;
error = error
|| khttp_body(req)
|| khtml_open(&html, req, KHTML_PRETTY)
|| htmlHead(&html, context)
|| htmlNav(&html, network, context)
|| htmlSearch(&html, network, context);
if (error) return error;
sqlite3_stmt *events = stmt.eventsAfter;
if (req->fieldmap[Before]) events = stmt.eventsBefore;
dbBindText(events, ":network", network);
dbBindText(events, ":context", context);
if (pagePublic) dbBindInt(events, ":query", false);
dbBindText(events, ":time", time);
dbBindInt(events, ":limit", pageLimit);
int result;
while (SQLITE_ROW == (result = sqlite3_step(events))) {
const char *msg = (const char *)sqlite3_column_text(events, 7);
if (!msg) continue;
error = 0
|| khtml_puts(&html, msg)
|| khtml_elem(&html, KELEM_BR);
if (error) break;
}
if (result != SQLITE_DONE) errx(EX_SOFTWARE, "%s", sqlite3_errmsg(db));
sqlite3_reset(events);
return error || khtml_close(&html);
}
|