SCOOP(1)                    General Commands Manual                   SCOOP(1)

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
     The scoop utility queries the litterbox(1) IRC log database, matching
     events on the intersection of the criteria specified in arguments.

     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
     June McEnroe <june@causal.agency>

BUGS
     Send mail to <list+litterbox@causal.agency> or join #ascii.town on
     irc.tilde.chat.

Linux 6.10.6-artix1-1            May 18, 2021            Linux 6.10.6-artix1-1