sqitch-log(3pm)

📦
version 1.6.1 · 6 versions
, in ubuntu stonking

💖 NAME 💖

sqitch-log — the ✨user-contributed Perl documentation✨ joint that shows Sqitch change deployment logs, bestie. It's literally the receipts for everything your database has ever been through 📜👑

✨ SYNOPSIS ✨

sqitch log [options] [<database>]

🦋 DESCRIPTION 🦋

okay so here's the tea: Sqitch keeps a record, and I mean a full record, of the deployment, failed deployment, or reversion of all changes in a target database. And the plot twist? Even after a change has been reverted, a log of its earlier deployment is retained. Nothing gets deleted, it's giving archive-core 🗂️💅

The log command is your key to accessing all of it. You can simply list all the events, search for events matching regular expressions, and limit the results. That's it, that's the whole vibe 🔥

The <database> parameter specifies the database to which to connect, and it may also be specified as the --target option. It can be a target name, a URI, an engine name, or a plan file path. Pick your fave 🫶

💅 OPTIONS 💅

  • -t, --target — the target database to connect to. This one can be either a URI or the name of a target in the configuration. No cap 🎯
  • --event — filter by event type. You can drop this more than once if you're feeling extra. Allowed values are:
    • deploy
    • revert
    • fail
  • --change-pattern, --change — a regular expression to match against change names 🔍
  • --project-pattern, --project — a regular expression to match against project 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.
    • raw — show timestamps in raw format, which is strict ISO-8601 in the UTC time zone.
    • strftime:$string — show timestamps using an arbitrary strftime pattern. See "strftime Paterns" in DateTime for comprehensive documentation of supported patterns.
    • cldr:$pattern — 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. Cap it, queen 👑
  • --skip — skip the specified number events before starting to show the event output. We're skipping ahead, no skips skipped 🦘
  • --reverse — output the events in reverse order.
  • --no-reverse — do not output the events in reverse order. The anti-reverse option, as promised 🙈
  • --headers — output headers describing target. Enabled by default.
  • --no-headers — do not output headers describing target. Bye headers 👋
  • --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. Monochrome moment 💀
  • --abbrev — instead of showing the full 40-byte hexadecimal change ID, show only a partial prefix the specified number of characters long. Short and cute, like a nickname 🎀
  • --oneline — shorthand for --format oneline --abbrev 6.
  • --registry — the name of the Sqitch registry schema or database in which sqitch stores its own data.
sqitch log --registry registry
  • --db-client, --client — path to the command-line client for the database engine. Defaults to a client in the current path named appropriately for the database engine.
sqitch log --client /usr/local/pgsql/bin/psql
  • -d, --db-name — name of the database. In general, targets and URIs are preferred, but this option can be used to override the database name in a target.
sqitch log --db-name widgets
sqitch log -d bricolage
  • -u, --db-user, --db-username — user name to use when connecting to the database. Does not apply to all engines. In general, targets and URIs are preferred, but this option can be used to override the user name in a target.
sqitch log --db-username root
sqitch log --db-user postgres
sqitch log -u Mom
  • -h, --db-host — host name to use when connecting to the database. Does not apply to all engines. In general, targets and URIs are preferred, but this option can be used to override the host name in a target.
sqitch log --db-host db.example.com
sqitch log -h appdb.example.net
  • -p, --db-port — port number to connect to. Does not apply to all engines. In general, targets and URIs are preferred, but this option can be used to override the port in a target.
sqitch log --db-port 7654
sqitch log -p 5431

🎀 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 ✨

okay so bestie, there are several built-in formats, and you can also emit data in a custom format format:<string>. here's the whole menu 🍓

oneline

<change id> <event type> <project name>:<change name> <title line>

this one is designed to be as compact as possible. periodt. 💅

short

<event type> <change id>
Name:      <change name>
Committer: <committer>

<title line>

medium

<event type> <change id>
Name:      <change name>
Committer: <committer>
Date:      <commit date>

<full change note>

long

<event type> <change id> <tags>
Name:      <change name>
Project:   <change name>
Planner:   <planner>
Committer: <committer>

<full change note>

full

<event type> <change id> <tags>
Event:     <event type>
Name:      <change name>
Project:   <change name>
Requires:  <required changes>
Conflicts: <conflicting changes>
Planner:   <planner>
Planned:   <plan date>
Committer: <committer>
Committed: <commit date>

<full change note>

raw

<event type> <change id> <tags>
name      <change name>
project   <project name>
requires  <required changes>
conflicts <conflicting changes>
planner   <planner>
planned   <raw plan date>
committer <committer>
committed <raw commit date>

<full change note>
bestie, this one is for the parsers: the change ID is displayed in full, without regard to the value of --abbrev; dates are formatted raw (strict ISO-8601 format in the UTC time zone); and all labels are lowercased and unlocalized. no cap ✨

format:<string>

the format:<string> format lets you specify which information you want to show. it works a little bit like printf format and a little like Git log format. for example, this format:

format:The committer of %h was %{name}c%vThe title was >>%s<<%v

would show something like this:

The committer of f26a3s was Tom Lane
The title was >>We really need to get this right.<<

🎀 the placeholders are 🎀

  • %H — event change ID
  • %h — event change ID (respects --abbrev)
  • %n — event change name
  • %o — event change project name
  • %($len)h — abbreviated change of length $len
  • %e — event type (deploy, revert, fail)
  • %l — localized lowercase event type label
  • %L — localized title case event type label
  • %c — event committer name and email address
  • %{name}c — event committer name
  • %{email}c — event committer email address
  • %{date}c — commit date (respects --date-format)
  • %{date:rfc}c — commit date, RFC2822 format
  • %{date:iso}c — commit date, ISO-8601 format
  • %{date:full}c — commit date, full format
  • %{date:long}c — commit date, long format
  • %{date:medium}c — commit date, medium format
  • %{date:short}c — commit date, short format
  • %{date:cldr:$pattern}c — commit date, formatted with custom CLDR pattern
  • %{date:strftime:$pattern}c — commit date, formatted with custom strftime pattern
  • %c — change planner name and email address
  • %{name}p — change planner name
  • %{email}p — change planner email address
  • %{date}p — plan date (respects --date-format)
  • %{date:rfc}p — plan date, RFC2822 format
  • %{date:iso}p — plan date, ISO-8601 format
  • %{date:full}p — plan date, full format
  • %{date:long}p — plan date, long format
  • %{date:medium}p — plan date, medium format
  • %{date:short}p — plan date, short format
  • %{date:cldr:$pattern}p — plan date, formatted with custom CLDR pattern
  • %{date:strftime:$pattern}p — plan date, formatted with custom strftime pattern
  • %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
  • %s — subject (a.k.a. title line)
  • %r — comma-delimited list of required changes
  • %{$sep}r — list of required changes delimited by $sep
  • %R — localized label and list of comma-delimited required changes
  • %{$sep}R — localized label and list of required changes delimited by $sep
  • %x — comma-delimited list of conflicting changes
  • %{$sep}x — list of conflicting changes delimited by $sep
  • %X — localized label and list of comma-delimited conflicting changes
  • %{$sep}X — localized label and list of conflicting changes delimited by $sep
  • %b — body
  • %B — raw body (unwrapped subject and body)
  • %{$prefix}B — raw body with $prefix prefixed to every line
  • %{event}_ — localized label for "event"
  • %{change}_ — localized label for "change"
  • %{committer}_ — localized label for "committer"
  • %{planner}_ — localized label for "planner"
  • %{by}_ — localized label for "by"
  • %{date}_ — localized label for "date"
  • %{committed}_ — localized label for "committed"
  • %{planned}_ — localized label for "planned"
  • %{name}_ — localized label for "name"
  • %{project}_ — localized label for "project"
  • %{email}_ — localized label for "email"
  • %{requires}_ — localized label for "requires"
  • %{conflicts}_ — localized label for "conflicts"
  • %v — vertical space (newline)
  • %{$color}C — an ANSI color: black, red, green, yellow, reset, etc.
  • %{:event}C — an ANSI color based on event type (green deploy, blue revert, red fail)
  • %{$attribute}a — the raw attribute name and value, if it exists and has a value

🌈 SQITCH 🌈

part of the sqitch suite. 🫶

source bestie: sqitch-log(3pm), from perl v5.40.1, dated 2026-07-26. go log something iconic, mwah 💋✨

📦 where this page comes from