David E. Wheeler > App-Sqitch-0.972 > sqitch-verify

Download:
App-Sqitch-0.972.tar.gz

Annotate this POD

Website

View/Report Bugs
Source   Latest Release: App-Sqitch-0.992

Name ^

sqitch-verify - Verify deployed database changes

Synopsis ^

  sqitch [options] verify
  sqitch [options] verify --from-target <target>
  sqitch [options] verify --to-target <target>
  sqitch [options] verify --from-target <target> --to-target <target>

Description ^

Verify that a database is valid relative to the plan and the verification scripts for each deployed change.

More specifically, verify iterates over all deployed and planned changes (or the subset identified by --from-target and/or --to-target) and checks that each:

Verify tests are scripts that may be associated with each change. If a change has no verify script, a warning is emitted, but it is not considered a failure.

Verify scripts should make no assumptions about the contents of the database, as unit tests might. Rather, their job is to ensure that the state of a database is correct after a deploy script has completed. Verify scripts are run through the database engine command-line client, just like deploy and revert scripts. They should cause the client to exit with a non-zero exit code if they fail.

Options ^

--from-target
--from

Specify the change target with which to start the verification. Defaults to the earliest deployed change. See sqitchchanges for the various ways in which change targets can be specified.

--to-target
--to

Specify the change target with which to complete the verification. Defaults to the last deployed change. See sqitchchanges for the various ways in which change targets can be specified.

-s
--set

Set a variable name and value for use by the database engine client, if it supports variables. The format must be name=value, e.g., --set defuser='Homer Simpson'. Overrides any values loaded from the verify.variables configuration.

Configuration Variables ^

[verify.variables]

A section defining database client variables. Useful if your database engine supports variables in scripts, such as PostgreSQL's psql variables.

Sqitch ^

Part of the sqitch suite.

syntax highlighting: