From 07190efefd29e0cc6fcf5e68e5330673bd14569b Mon Sep 17 00:00:00 2001 From: uvok cheetah Date: Sat, 4 Jan 2025 11:21:58 +0100 Subject: Add comment extractor --- _comments.sh | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 _comments.sh (limited to '_comments.sh') diff --git a/_comments.sh b/_comments.sh new file mode 100644 index 0000000..2dc6c85 --- /dev/null +++ b/_comments.sh @@ -0,0 +1,3 @@ +#!/bin/sh +#scp hetzner:/var/www/hatsu/hatsu.sqlite3 . +sqlite3 -box hatsu.sqlite3 'SELECT id, in_reply_to_root FROM post where in_reply_to IS NOT NULL;' -- cgit v1.2.3