Name

sqitch-status - Show the current deployment status of a database

Synopsis

sqitch [options] status [<options>] [<database>]

Description

Displays information about the current deployment status of a database. The most recently deployed change information is displayed, as well as any related tags. If there are undeployed changes in the plan, they will be listed. Otherwise, a message will indicate that the database is up-to-date.

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

Options

-t
--target

The target database to which to connect. This option can be either a URI or the name of a target in the configuration.

--project

Project for which to retrieve the status. Defaults to the status of the current project, if a plan can be found.

--show-changes

Also display a list of deployed changes.

--show-tags

Also display a list of applied tags.

--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:$string

Show timestamps using an arbitrary cldr pattern. See "CLDR Paterns" in DateTime for comprehensive documentation of supported patterns.

Configuration Variables

status.show_changes

Boolean value indicates whether or not to display changes in the output. Defaults to false.

status.show_tags

Boolean value indicates whether or not to display tags in the output. Defaults to false.

status.date_format

Format to use for timestamps. Supports the same values as the --date-format option.

Sqitch

Part of the sqitch suite.