sqitch-log - Show database deployment event history
sqitch [options] log [<options>]
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.
log
--event
Filter by event type. May be specified more than once. Allowed values are:
deploy
revert
fail
--change-pattern
--change
-c
A regular expression to match against change names.
--actor-pattern
--actor
-a
A regular expression to match against actor (user) names.
--format
-f
The format to use. May be one of:
full
long
medium
short
oneline
raw
format:<string>
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.
Show timestamps in the specified format length, using the system locale's LC_TIME category.
LC_TIME
strftime:$string
Show timestamps using an arbitrary strftime pattern. See "strftime Paterns" in DateTime for comprehensive documentation of supported patterns.
strftime
cldr:$string
Show timestamps using an arbitrary cldr pattern. See "CLDR Paterns" in DateTime for comprehensive documentation of supported patterns.
cldr
--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:
auto
always
never
--no-color
Turn off colored output. It is the same as --color never.
--color never
--abbrev
Instead of showing the full 40-byte hexadecimal change ID, show only a partial prefix the specified number of characters long.
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.
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.
printf
%n
%e: Event type (deploy, revert, fail)
%e
%H: Event change ID
%H
%h: Event change ID (respects --abbrev)
%h
%c: Event change name
%c
%($len)h: abbreviated change of length $len
%($len)h
$len
%l: Localized lowercase event type label
%l
%L: Localized title case event type label
%L
%{event}_ Localized label for "event"
%{event}_
%{change}_ Localized label for "change"
%{change}_
%{actor}_ Localized label for "actor"
%{actor}_
%{by}_ Localized label for "by"
%{by}_
%{date}_ Localized label for "date"
%{date}_
%{name}_ Localized label for "name"
%{name}_
%a: Event actor name
%a
%d: Formatted Event date (respects --date-format)
%d
%{rfc}d: date, RFC2822 format
%{rfc}d
%{iso}d: date, ISO-8601 format
%{iso}d
%{full}d: date, full format
%{full}d
%{long}d: date, long format
%{long}d
%{medium}d: date, medium format
%{medium}d
%{short}d: date, short format
%{short}d
%t: Comma-delimited list of tags
%t
%{$sep}t: list of tags delimited by $sep
%{$sep}t
$sep
%T: Parenthesized list of comma-delimited tags
%T
%{$sep}T: Parenthesized list of tags delimited by $sep
%{$sep}T
%n newline
%{color}C: An ANSI color: black red green yellow blue magenta cyan white, reset
%{color}C
Part of the sqitch suite.
To install App::Sqitch, copy and paste the appropriate command in to your terminal.
cpanm
cpanm App::Sqitch
CPAN shell
perl -MCPAN -e shell install App::Sqitch
For more information on module installation, please visit the detailed CPAN module installation guide.