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
• 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.