summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-07-10 08:35:11 -0400
committerJune McEnroe <june@causal.agency>2020-07-10 08:35:11 -0400
commitdefff5181f36da178c38510009ff0ecfaf30cd0a (patch)
tree2debf2736ee308e2a3f3e13b870e04721659ab7d
parentList active contexts first (diff)
downloadscooper-defff5181f36da178c38510009ff0ecfaf30cd0a.tar.gz
scooper-defff5181f36da178c38510009ff0ecfaf30cd0a.zip
List active networks first
Diffstat (limited to '')
-rw-r--r--networks.c49
1 files changed, 42 insertions, 7 deletions
diff --git a/networks.c b/networks.c
index a81722c..ed19394 100644
--- a/networks.c
+++ b/networks.c
@@ -22,9 +22,25 @@
 #include "server.h"
 
 const char *NetworksQuery = SQL(
-	SELECT DISTINCT network
-	FROM contexts
-	ORDER BY network;
+	WITH recentEvents AS (
+		SELECT time, context
+		FROM events
+		ORDER BY event DESC
+		LIMIT 500 // TODO: Configurable.
+	), activeNetworks AS (
+		SELECT DISTINCT network
+		FROM contexts
+		JOIN recentEvents USING (context)
+		GROUP BY context
+		ORDER BY max(time) DESC
+	), allNetworks AS (
+		SELECT DISTINCT network
+		FROM contexts
+		ORDER BY network
+	)
+	SELECT network, 1 FROM activeNetworks
+	UNION ALL
+	SELECT network, 0 FROM allNetworks;
 );
 
 enum kcgi_err pageNetworks(struct kreq *req) {
@@ -35,22 +51,41 @@ enum kcgi_err pageNetworks(struct kreq *req) {
 	error = error
 		|| khttp_body(req)
 		|| khtml_open(&html, req, KHTML_PRETTY)
-		|| htmlHead(&html, "Networks")
+		|| htmlHead(&html, "Litterbox")
 		|| htmlNav(&html, NULL, NULL)
-		|| htmlSearch(&html, NULL, NULL)
-		|| khtml_elem(&html, KELEM_UL);
+		|| htmlSearch(&html, NULL, NULL);
 	if (error) return error;
 
+	enum State {
+		None,
+		Active,
+		Networks,
+	} state = None;
+	const char *Headings[] = { NULL, "Active", "Networks" };
+
 	int result;
 	while (SQLITE_ROW == (result = sqlite3_step(stmt.networks))) {
 		const char *network = (const char *)sqlite3_column_text(stmt.networks, 0);
+		bool active = sqlite3_column_int(stmt.networks, 1);
+
+		enum State prev = state;
+		state = (active ? Active : Networks);
+		if (state != prev) {
+			error = 0
+				|| khtml_closeelem(&html, 1)
+				|| khtml_elem(&html, KELEM_H2)
+				|| khtml_puts(&html, Headings[state])
+				|| khtml_closeelem(&html, 1)
+				|| khtml_elem(&html, KELEM_UL);
+			if (error) return error;
+		}
+
 		char *href = khttp_urlpart(
 			NULL, NULL, Pages[Contexts],
 			Keys[Network].name, network,
 			NULL
 		);
 		if (!href) err(EX_OSERR, "khttp_urlpart");
-
 		error = 0
 			|| khtml_elem(&html, KELEM_LI)
 			|| khtml_attr(&html, KELEM_A, KATTR_HREF, href, KATTR__MAX)
r'>2020-10-27Use SendEnv for cd host:pathJune McEnroe Works properly for weird paths, etc. 2020-10-27Allow cd host:path over sshJune McEnroe Requires AcceptEnv SSH_CD in the remote sshd_config. 2020-10-07Use mandoc -T utf8 for text.June McEnroe Don't depend on LANG being set. 2020-09-20Add The Awakened KingdomJune McEnroe A cute extra novella. Finally finished this series. 2020-09-12Move /opt/local back, cheat port select to use system manJune McEnroe This is not really how you're supposed to use the select system, I don't think, since the mandoc package actually creates those files, but it does work. This lets me actually use the git installed by MacPorts. 2020-09-12Move /opt/local behind /usr againJune McEnroe The reason I did this with pkgsrc was because I actually don't want the man(1) from mandoc, since it won't follow MANSECT. Same applies to MacPorts. I wish I could disable its man(1) with a variant or whatever. 2020-09-12Enable toc in cgit renderings of man pagesJune McEnroe But keep it disabled for READMEs since they always use non-standard sections and the TOC is just distracting there, I think. Also add the style so its h1 is the same size as the ones inside sections... 2020-09-11Install mandoc on macOSJune McEnroe 2020-09-11Rewrite install script yet againJune McEnroe 2020-09-11Remove NetBSD from install scriptJune McEnroe I never use it. 2020-09-11Use MacPorts rather than pkgsrcJune McEnroe My system is probably such a mess now... 2020-09-11Add debian VM name to sshJune McEnroe 2020-09-11Add influencer tweetJune McEnroe 2020-09-10Add The Kingdom of GodsJune McEnroe Reading has really slowed down :( 2020-09-07Add SunglassesJune McEnroe An IRC find. 2020-09-06Add Between the BreathsJune McEnroe One of those good songs from a soundtrack of a film that probably isn't? The summary sounds a lot more interesting than the title implies, at least. 2020-09-04Open /dev/tty in nudgeJune McEnroe This makes it work even when it's run connected to a pipe, i.e. as the notify command of catgirl... 2020-09-04Add nudgeJune McEnroe 2020-09-03Build fbclock with -lzJune McEnroe I guess this got lost somewhere, long ago... 2020-08-29Add tweets from retweetsJune McEnroe