The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

Changes for version 0.960 - 2013-04-05

  • Removed `-CAS` from the shebang line on Perl 5.10.0. This is to eliminate `Too late for "-CAS" option` errors. This means that UTF-8 semantics will be suboptimal on Perl 5.10.0. Consider upgrading to 5.12 or higher.
  • Added the `checkout` command. Pass it the name of a VCS branch, and it will compare the plans between that branch and the current branch, revert to the last common change, check out the branch, and then redeploy. This makes it easy to switch between working branches that have different sets of commits. Git-only for now. Idea and code by Ronan Dunklau.
  • The `rebase` command no longer fails if the database is already reverted, but just makes a note of it and goes on to the deploy.
  • Added the `plan` command. It's like `log`, but shows a list of changes in the plan, rather than events recorded in the database.
  • Added `search_changes()` to Plan. Used by the `plan` command.
  • Added the `--oneline` option to the `log` command.
  • Allow tagging of an arbitrary change, not just the last change in the plan, by passing a change specification (name, ID, or tag) as the second argument to the `tag` command.
  • Updated error messages to note that blank characters are not allowed in project, change, or tag names.
  • Factored most of the engine-specific code into App::Sqitch::Role::DBIEngine. Future DBI-based engines should be able to use this role to handle most of the work.
  • Factored the live engine tests int `t/lib/DBIEngineTest`. Future DBI-based engines can use this module to do all or most of the live testing.
  • Added the SQLite engine. The Sqitch metadata is stored in a separate file from a database, by default in the same directory as the database file.
  • Added `sqitchtutorial-sqlite.pod`, a SQLite-specific variant of `sqitchtutorial.pod`.

Documentation

Sqitch add usage statement
Add a database change to the plan
Sqitch bundle usage statement
Bundle a Sqitch project for distribution
Sqitch checkout usage statement
Revert, checkout another VCS branch, and re-deploy changes
Sqitch config usage statement
Get and set local, user, or system Sqitch options
Sqitch deploy usage statement
Deploy changes to a database
Sqitch help usage statement
Display help for Sqitch and Sqitch commands
Sqitch init usage statement
Create a new Sqitch project
Sqitch log usage statement
Show database change logs
Sqitch plan usage statement
Show database change planned changes
Sqitch rebase usage statement
Revert and redeploy database changes
Sqitch revert usage statement
Revert changes to a database
Sqitch rework usage statement
Rework a database change
Sqitch show usage statement
Show object information or change file contents
Sqitch status usage statement
Show the current deployment status of a database
Sqitch tag usage statement
Create or list tag objects
Sqitch verify usage statement
Verify deployed database changes
Sane database change management
List of common sqitch commands
A tutorial introduction to Sqitch change management on SQLite
A tutorial introduction to Sqitch

Modules

Sane database change management
Sqitch Command support
Add a new change to a Sqitch plan
Bundle Sqitch changes for distribution
Revert, change checkout a VCS branch, and redeploy
Get and set local, user, or system Sqitch options
Deploy Sqitch changes to a database
Display help information about Sqitch
Initialize a Sqitch project
Show a database event log
List the changes in the plan
Revert and redeploy Sqitch changes
Revert Sqitch changes from a database
Rework a Sqitch change
Show Sqitch changes to a database
Display status information about Sqitch
Add or list tags in a Sqitch plan
Verify deployed Sqitch changes
Sqitch configuration management
Sqitch DateTime object
Sqitch Deployment Engine
Sqitch PostgreSQL Engine
Sqitch SQLite Engine
Format events and changes for command output
Sqitch Deployment Plan
Sqitch deployment plan blank line
Sqitch deployment plan tag
Sqitch deployment plan change list
Sqitch dependency specification
Sqitch deployment plan line
Sqitch deployment plan line list
Sqitch deployment plan blank line
Sqitch deployment plan tag
An engine based on the DBI
A command that reverts and deploys
Sqitch Exception class