diff options
| author | uvok cheetah | 2025-01-04 11:21:58 +0100 |
|---|---|---|
| committer | uvok cheetah | 2025-01-04 11:21:58 +0100 |
| commit | 07190efefd29e0cc6fcf5e68e5330673bd14569b (patch) | |
| tree | 8d271df4bd62e930ffa689ff881f1b2236016332 | |
| parent | 22779aeb657b374024ffe2ba1236f9716cb61922 (diff) | |
Add comment extractor
| -rw-r--r-- | _comments.sh | 3 |
1 files changed, 3 insertions, 0 deletions
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;' |