The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
 / 
App-Sqitch-0.9996
River stage one • 2 direct dependents • 2 total dependents
43 ++

Changes for version 0.9996 - 2017-07-17

  • Fixed an error where Oracle sometimes truncated timestamp formats so that date parsing failed. Thanks to Johann Wilfling for the report and @nmaqsudov for the solution (#316).
  • Added pager configuration, prioritizing the new `core.pager` configuration variable over the `$PAGER` environment variable. The new `$SQITCH_PAGER` environment variable trumps all. Thanks to Yati Sagade for the pull request (#329).
  • Documented the `core.editor` configuration variable.
  • Updated PostgreSQL registry detection to avoid errors when not running Sqitch as a superuser and the registry schema already exists. Done by looking for the `changes` table in the `pg_tables` view instead of looking for the registry schema in the `pg_namespace` catalog table, and by using `CREATE SCHEMA IF NOT EXISTS` on PostgreSQL 9.3 and higher. Thanks to @djk447 for the pull request (#307).
  • Updated PostgreSQL registry detection to avoid errors when the `psql` client is newer than the server version. Sqitch now fetches the version from the server instead of parsing it from the client.
  • Specifying a change before a target name on the command-line no longer ignores the target (#281).
  • The `--db-*` options are now more consistently applied to a target, including when the target is specified as a URI (#293).
  • `HEAD` and `ROOT` are now properly recognized as aliases for `@HEAD` and `@ROOT`, when querying the database. This was supposedly done in v0.991, but due to a bug, it wasn't really. Sorry about that.
  • The `revert` and `verify` commands will now fail if a change is specified and matches multiple changes. This happens when referencing a reworked change only by its name. In this case, Sqitch will emit an error listing properly tag-qualified changes to use. Suggested by Jay Hannah (#312).
  • Sqitch no longer returns an error when a target name is passed to a command and the default target's plan file does not exist (#324).
  • Added missing options to the `rework` usage statement. Thanks to Jay Hannah for the PR (#342).
  • Passing an engine name or plan file as the `<database>` parameter to the `log`, `status`, and `upgrade` commands now works correctly, matching what the documention has said for some time (#324).
  • Added the `--target` option to the `plan` and `show` commands.
  • Added the `<database>` parameter to the `plan` command.
  • Sqitch now loads targets from all config files, not just the local file, when trying to determine if a `<database>` parameter is a plan file name.
  • Improved the error message when a change is found more than once in a plan, typically a reworked changed referenced only by name. The error will no longer be "Key at multiple indexes", but "Change is ambiguous. Please specify a tag-qualified change:", followed by a list of tag-qualified variants of the change.
  • Fixed a bug where the verify command would return a database error when it finds no registory. Now it reports that the registry wasn't found in the database.

Documentation

sqitch-add-usage
Sqitch add usage statement
sqitch-add
Add a database change to plans
sqitch-bundle-usage
Sqitch bundle usage statement
sqitch-bundle
Bundle a Sqitch project for distribution
sqitch-checkout-usage
Sqitch checkout usage statement
sqitch-checkout
Revert, checkout another VCS branch, and re-deploy changes
sqitch-config-usage
Sqitch config usage statement
sqitch-config
Get and set local, user, or system Sqitch options
sqitch-configuration
Hierarchical engine and target configuration
sqitch-deploy-usage
Sqitch deploy usage statement
sqitch-deploy
Deploy changes to a database
sqitch-engine-usage
Sqitch engine usage statement
sqitch-engine
Manage database engine configuration
sqitch-environment
Environment variables recognized by Sqitch
sqitch-help-usage
Sqitch help usage statement
sqitch-help
Display help for Sqitch and Sqitch commands
sqitch-init-usage
Sqitch init usage statement
sqitch-init
Create a new Sqitch project
sqitch-log-usage
Sqitch log usage statement
sqitch-log
Show Sqitch change logs
sqitch-passwords
Guide to using database passwords with Sqitch
sqitch-plan-usage
Sqitch plan usage statement
sqitch-plan
Show planned database changes
sqitch-rebase-usage
Sqitch rebase usage statement
sqitch-rebase
Revert and redeploy database changes
sqitch-revert-usage
Sqitch revert usage statement
sqitch-revert
Revert changes to a database
sqitch-rework-usage
Sqitch rework usage statement
sqitch-rework
Rework a database change
sqitch-show-usage
Sqitch show usage statement
sqitch-show
Show object information or change file contents
sqitch-status-usage
Sqitch status usage statement
sqitch-status
Show the current deployment status of a database
sqitch-tag-usage
Sqitch tag usage statement
sqitch-tag
Create or list tag objects
sqitch-target-usage
Sqitch target usage statement
sqitch-target
Manage target database configuration
sqitch-upgrade-usage
Sqitch upgrade usage statement
sqitch-upgrade
Upgrade the registry to the current version
sqitch-verify-usage
Sqitch verify usage statement
sqitch-verify
Verify deployed database changes
sqitch
Sane database change management
sqitchchanges
Specifying changes for Sqitch
sqitchcommands
List of common sqitch commands
sqitchguides
List of common Sqitch guides
sqitchtutorial-firebird
A tutorial introduction to Sqitch change management on Firebird
sqitchtutorial-mysql
A tutorial introduction to Sqitch change management on MySQL
sqitchtutorial-oracle
A tutorial introduction to Sqitch change management on Oracle
sqitchtutorial-sqlite
A tutorial introduction to Sqitch change management on SQLite
sqitchtutorial-vertica
A tutorial introduction to Sqitch change management on Vertica
sqitchtutorial
A tutorial introduction to Sqitch change management on PostgreSQL
sqitchusage
Sqitch usage statement

Modules

App::Sqitch
Sane database change management
App::Sqitch::Command
Sqitch Command support
App::Sqitch::Command::add
Add a new change to Sqitch plans
App::Sqitch::Command::bundle
Bundle Sqitch changes for distribution
App::Sqitch::Command::checkout
Revert, change checkout a VCS branch, and redeploy
App::Sqitch::Command::config
Get and set local, user, or system Sqitch options
App::Sqitch::Command::deploy
Deploy Sqitch changes to a database
App::Sqitch::Command::engine
Add, modify, or list Sqitch database engines
App::Sqitch::Command::help
Display help information about Sqitch
App::Sqitch::Command::init
Initialize a Sqitch project
App::Sqitch::Command::log
Show a database event log
App::Sqitch::Command::plan
List the changes in the plan
App::Sqitch::Command::rebase
Revert and redeploy Sqitch changes
App::Sqitch::Command::revert
Revert Sqitch changes from a database
App::Sqitch::Command::rework
Rework a Sqitch change
App::Sqitch::Command::show
Show Sqitch changes to a database
App::Sqitch::Command::status
Display status information about Sqitch
App::Sqitch::Command::tag
Add or list tags in Sqitch plans
App::Sqitch::Command::target
Add, modify, or list Sqitch target databases
App::Sqitch::Command::upgrade
Upgrade the Sqitch registry
App::Sqitch::Command::verify
Verify deployed Sqitch changes
App::Sqitch::Config
Sqitch configuration management
App::Sqitch::DateTime
Sqitch DateTime object
App::Sqitch::Engine
Sqitch Deployment Engine
App::Sqitch::Engine::firebird
Sqitch Firebird Engine
App::Sqitch::Engine::mysql
Sqitch MySQL Engine
App::Sqitch::Engine::oracle
Sqitch Oracle Engine
App::Sqitch::Engine::pg
Sqitch PostgreSQL Engine
App::Sqitch::Engine::sqlite
Sqitch SQLite Engine
App::Sqitch::Engine::vertica
Sqitch Vertica Engine
App::Sqitch::ItemFormatter
Format events and changes for command output
App::Sqitch::Plan
Sqitch Deployment Plan
App::Sqitch::Plan::Blank
Sqitch deployment plan blank line
App::Sqitch::Plan::Change
Sqitch deployment plan tag
App::Sqitch::Plan::ChangeList
Sqitch deployment plan change list
App::Sqitch::Plan::Depend
Sqitch dependency specification
App::Sqitch::Plan::Line
Sqitch deployment plan line
App::Sqitch::Plan::LineList
Sqitch deployment plan line list
App::Sqitch::Plan::Pragma
Sqitch deployment plan blank line
App::Sqitch::Plan::Tag
Sqitch deployment plan tag
App::Sqitch::Role::DBIEngine
An engine based on the DBI
App::Sqitch::Role::RevertDeployCommand
A command that reverts and deploys
App::Sqitch::Role::TargetConfigCommand
A command that handles target-related configuration
App::Sqitch::Target
Sqitch deployment target
App::Sqitch::Types
Definition of attribute data types
App::Sqitch::X
Sqitch Exception class

Other files