Name
sqitch-log - Show database deployment event history
Synopsis
sqitch [options] log [<options>]
Description
Sqitch keeps a record of the deployment, failed deployment, or reversion of all changes in a database. Even after a change has been reverted, a log of its earlier deployment is retained. The log
command is your key to accessing it. You can simply list all the events, search for events matching regular expressions, and limit the results.
Options
--event
-
Filter by event type. May be specified more than once. Allowed values are:
deploy
revert
fail
--change-pattern
--change
-
A regular expression to match against change names.
--committer-pattern
--committer
-
A regular expression to match against committer names.
--format
-f
-
The format to use. May be one of:
See "Formats" for details on each format. Defaults to <medium>.
--date-format
--date
-
Format to use for timestamps. Defaults to
iso
. Allowed values:iso
iso8601
-
Shows timestamps in ISO-8601 format.
rfc
rfc2822
-
Show timestamps in RFC-2822 format.
full
long
medium
short
-
Show timestamps in the specified format length, using the system locale's
LC_TIME
category. strftime:$string
-
Show timestamps using an arbitrary
strftime
pattern. See "strftime Paterns" in DateTime for comprehensive documentation of supported patterns. cldr:$string
-
Show timestamps using an arbitrary
cldr
pattern. See "CLDR Paterns" in DateTime for comprehensive documentation of supported patterns.
--max-count
-n
-
Limit the number of events to output.
--skip
-
Skip the specified number events before starting to show the event output.
--reverse
-
Output the events in reverse order.
--no-reverse
-
Do not output the events in reverse order.
--color
-
Show colored output. The value may be one of:
--no-color
-
Turn off colored output. It is the same as
--color never
. --abbrev
-
Instead of showing the full 40-byte hexadecimal change ID, show only a partial prefix the specified number of characters long.
Configuration Variables
log.format
-
Output format to use. Supports the same values as
--format
. log.date_format
-
Format to use for timestamps. Supports the same values as the
--date-format
option. log.color
-
Output colors. Supports the same values as the
--color
option.
Formats
The format:<string> format allows you to specify which information you want to show. It works a little bit like printf
format. Like the Git log format, you can use %n
for a newline, but an actual newline is okay, too.
%e
: Event type (deploy, revert, fail)%H
: Event change ID%h
: Event change ID (respects--abbrev
)%c
: Event change name%($len)h
: abbreviated change of length$len
%l
: Localized lowercase event type label%L
: Localized title case event type label%{event}_
Localized label for "event"%{change}_
Localized label for "change"%{committer}_
Localized label for "committer"%{by}_
Localized label for "by"%{date}_
Localized label for "date"%{name}_
Localized label for "name"%a
: Event committer name%d
: Formatted Event date (respects--date-format
)%{rfc}d
: date, RFC2822 format%{iso}d
: date, ISO-8601 format%{full}d
: date, full format%{long}d
: date, long format%{medium}d
: date, medium format%{short}d
: date, short format%t
: Comma-delimited list of tags%{$sep}t
: list of tags delimited by$sep
%T
: Parenthesized list of comma-delimited tags%{$sep}T
: Parenthesized list of tags delimited by$sep
%n
newline%{color}C
: An ANSI color: black red green yellow blue magenta cyan white, reset
Sqitch
Part of the sqitch suite.