Name

sqitch-revert - Revert and redeploy database changes

Synopsis

  sqitch [options] rebase --onto-target <target>
  sqitch [options] rebase --onto-target <target> --upto-target <target>
  sqitch [options] rebase <target>
  sqitch [options] rebase <target> --upto-target <target>
  sqitch [options] rebase <target> <target>

Description

Revert and redeploy changes to the database. It's effectively a shortcut for running sqitch revert and sqitch deploy in succession.

More specifically, starting from the current deployment state, changes will be reverted in reverse the order of application. All changes will be reverted unless a target is specified, either via --onto or with no option flag, in which case changes will be reverted back to that target.

Once the revert finishes, changes will be deployed starting from the deployed state through the rest of the deployment plan. They will run to the latest change in the plan, unless a target is specified, either via --upto or with no option flag, in which case changes will be deployed up-to and including that target.

If the database has not been deployed to, or its state already matches the specified target, no reverts will be run. And if, at that point, the database is up-to-date, no deploys will be run.

Options

--onto-target

--onto

Specify the reversion target. Defaults to reverting all changes. See sqitchchanges for the various ways in which change targets can be specified.

--upto-target

--upto

Specify the deployment target. Defaults to the last point in the plan. 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 deploy.variables or revert.variables configurations.

-d

--set-deploy

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

-r

--set-revert

Sets a variable name to be used by the database engine client during when reverting, if it supports variables. The format must be name=value, e.g., --set defuser='Homer Simpson'. Overrides any values from --set or loaded from the deploy.variables and revert.variables configurations.

-y

Disable the prompt that normally asks whether or not to execute the revert.

Configuration Variables

[deploy.variables]

[revert.variables]

A section defining database client variables. The deploy.variables configuration is read from the deploy command configuration, on the assumption that the values will generally be the same. If they're not, use revert.variables to override deploy.variables.

These variables are Useful if your database engine supports variables in scripts, such as PostgreSQL's psql variables.

[rebase.no_prompt]

[revert.no_prompt]

A boolean value indicating whether or not to disable the prompt before executing the revert. The rebase.no_prompt variable takes precedence over revert.no_prompt, and both may of course be overridden by -y.

Sqitch

Part of the sqitch suite.