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:

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.

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:

auto (the default)
always
never
--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.