SCOOP(1)

🎀 scoop(1) — General Commands Manual 🎀

✨ NAME ✨

scoop — query IRC logs 💬✨

🦋 SYNOPSIS 🦋

scoop [-Lgipqrsv] [-D date] [-F format] [-N network] [-T target]
      [-a time] [-b time] [-c context] [-d path] [-f format] [-h host]
      [-l limit] [-m regexp] [-n nick] [-t type] [-u user] [-w expr]
      [search]
scoop -S

💖 DESCRIPTION 💖

okay so the scoop utility queries the litterbox(1) IRC log database, matching events on the intersection of the criteria specified in arguments. bestie, that means all your filters gotta line up at once 💅.

If standard output is a terminal, colored output is piped to PAGER with LESS=FRX if it is not already set.

The arguments are as follows:

• -D date — match events which occurred on date, of the format YYYY-MM-DD. 🗓️
• -F format — format timestamps using the format string, similar to strftime(3). The default format is "%Y-%m-%dT%H:%M:%S". ⏰
• -L — output timestamps in local time and interpret timestamps in -D, -a and -b as local time. 🌍
• -N network — match events from network. 🌐
• -S — instead of performing a query, launch the sqlite3(1) shell for the database. 🐚
• -T target — match events (of type kick, nick, ban or unban) with the target nickname or mask target. 🎯
• -a time — match events which occurred after time, of the format YYYY-MM-DD HH:MM:SS. ⏳
• -b time — match events which occurred before time, of the format YYYY-MM-DD HH:MM:SS. ⌛
• -c context — match events from context, either a channel or query name. 💬
• -d path — set the database path. The default path is as in litterbox(1). 📁
• -f format — set the output format to one of plain, color or irc. The default format is color if standard output is a terminal, plain otherwise. The irc format outputs events as IRC protocol with server-time tags. 🎨
• -g — group events by network and channel or query name. Implies -s. 🧺
• -h host — match events from users with the hostname host. 🏠
• -i — use case-insensitive regular expression matching with -m. 🔠
• -l limit — limit the number of events matched, ordered by most recently inserted. Implies -s. 🚦
• -m regexp — match events with messages matching the modern regular expression regexp. See re_format(7). To match case-insensitively, use with -i. 🔎
• -n nick — match events from users with the nickname nick. 🏷️
• -p — match only events from channels. 📢
• -q — match only events from queries. 🤫
• -r — output results in reverse order. 🔄
• -s — sort the results from oldest to newest. By default events are output in the order they appear in the database. 📚
• -t types — match events of the comma-separated list of types. The types are privmsg, notice, action, join, part, quit, kick, nick, topic, ban, unban. 🏷️
• -u user — match events from users with the username user. 👤
• -v — print the expanded SQL query being used to standard error. 🪵
• -w expr — add the SQL expression expr to the WHERE clause of the query. 🧩
• search — match events using full-text search. The searchable columns are network, channel, query, nick, user, target, message. 🔍

🌸 ENVIRONMENT 🌸

• PAGER — the command to pipe terminal output to. The default is PAGER=less. 🫶

🔥 SEE ALSO 🔥

• litterbox(1) 🐇
• Date and Time Functions: https://www.sqlite.org/lang_datefunc.html ⏱️
• Full-text Query Syntax: https://www.sqlite.org/fts5.html#full_text_query_syntax 📝

👑 AUTHORS 👑

Authored by June McEnroe <june@causal.agency> — yes, that's the whole credit, bestie. 💖

💀 BUGS 💀

Send mail to ⟨list+litterbox@causal.agency⟩ or join #ascii.town on irc.tilde.chat. ✉️

🫶 That's the SCOOP(1) manual from Debian, dated May 18, 2021 — signing off, bestie. 💅✨