Bot releases are visible (Hide)
Changes for v1.4.1
sqitchtutorial-snowflake.pod
on the need to use URI escapes for special characters. Thanks to Patrick Sabo for the find, and to @marc-marketparts for validating that URI encoding works.sqitch-target.pod
, the main reference for database URLs in the Sqitch documentation.--verbose
twice, as described in the v1.4.0 changes, and not just once. Thanks to Erik Wienhold for the PR (#785)!-VV
. Thanks to Erik Wienhold for the PR (#787)!chmod
. Thanks to Slaven Rezić for the report and the fix (#807)!mysql
client installed by Homebrew on macOS. Thanks to Carlos Ramos for the bug report and PR (#791)!Published by github-actions[bot] about 1 year ago
Changes for v1.4.0
--verbose
is specified at least twice. Thanks to @vectro for the PR (#702).0
separators in lists of things (such as %{0}t
for a list of tags). Thanks to @web-vertalo for the pull request (#703).no_prompt
and no_prompt
attributes of App::Sqitch::Engine in favor of passing booleans to the revert
and verify
methods. The attributes still exist for reverse compatibility, but now emit warnings and will be removed in the future. Thanks to Thanks to @vectro for the PR (#704).add
command. Thanks to @blairjordan for the PR (#724)!revert.strict
boolean configuration variable which, when set to true, requires the specification of a change to revert to. It also disables the rebase
and checkout
commands, though the rebase.strict
and checkout.strict
variables, respectively, may override it. Use revert.strict
to prevent accidental reverts in sensitive environments. Thanks to @vectro for the PR (#719; revised in #735)!%F
to sqitch plan
that prints the path for the deploy file for each migration in the plan.sqlplus
client when the ORACLE_HOME
environment variable is set. It now returns either $ORACLE_HOME/bin/sqlplus
or $ORACLE_HOME/sqlplus
if it exists and is executable (and ends in .exe
on Windows). Otherwise it simply returns sqlplus
as before, assuming it will be found in the path. Thanks to @vectro for the suggestion (#747).Published by github-actions[bot] about 2 years ago
Changes for v1.3.1
psql
, thus ignoring the PGPORT
environment variable. Thanks to Cam Feenstra for the spot (#675)!\
) in change and tag names. It would be ignored on Unix-style systems, but create unexpected subdirectories on Windows systems./
) in tag names. They're still allowed in change names to enable script organization, but can wreak havoc when used in tag names. Thanks to @ewie for the report (#680)!Published by github-actions[bot] about 2 years ago
Changes for v1.3.0
isql
, and when using a local Firebird (e.g., the Engine12 provider), which allows only one connection at a time. Thanks to Slaven Rezić for the the reproducible configuration (#597).sqitch engine update-config
action, originally added for compatibility reasons in 2014, and the prompt to use it was removed as of 0.9999 in 2019.Published by theory almost 3 years ago
Changes for v1.2.1
local
directory from the distribution, accidentally included in v1.2.0. Thanks to gregor herrmann for the report (#600).Published by github-actions[bot] almost 3 years ago
Changes for v1.2.0
sqitch -vvv
). Thanks to @wkoszek for the suggestion (#155).AUTHMETHOD
query parameter (to allow Open ID authentication) and the SSLCERTIFICATE=SSL_VERIFY_NONE
query parameter to disable SSL verification. Thanks to Torsten Glunde for the report (#588).--max-count
option when used with --reverse
to show the proper items. Thanks to Adrian Klaver for the report (#517).check
command on Firebird, Exasol, Oracle, and Vertica. Broken since the check
command was added in v1.1.0.Published by theory over 4 years ago
-t
option to specify a target, due to a missing dependency declaration in the Target class. Thanks to Clinton Adams for the fix (#509)!--password
option to the MySQL client if it was not read from the .my.cnf
file, as it's more secure to let the client use .my.cnf
, and it eliminates a warning from recent versions of the client. Thanks to Kiel R Stirling for the fix (#484)!engine.$engine.client
config when using the Docker image.check
command, which compares the SHA1 hashes of the deploy scripts to the database, and reports if any have been modified since they were deployed. Thanks to Matthieu Foucault for the pull--modified
option to the rebase
and revert
commands, to revert to the earliest change with a modified deploy script. Handy for rapid rebasing during iterative development cycles. Thanks to Matthieuinit
. Thanks to Stack Overflow user vbp13 for the report (#502).Published by theory over 5 years ago
sqitch-authentication
, as well as $SNOWSQL_PRIVATE_KEY_PASSPHRASE
in sqitch-environment
. Thanks to Casey Largent for figuring it out (#441).ask_yes_no()
method as a replacement for ask_y_n()
, which is now deprecated. The new method expects localized responses from the user when translations are provided. Defaults to the English "yes" and "no" when no translation is available. Suggested by German translator Thomas Iguchi (#449).show
actions of the target
and engine
commands, fixing a "Negative repeat count does nothing" warning in the process. Thanks to @maximejanssens for thePublished by theory over 5 years ago
$PGUSER
and $PGPASSWORD
foo:greeble
, Sqitch would raise an error if foo:greeble
--abort-source-on-error
to the Maria mysql
client to ensure that SQLundef
arguments that should be defined.connections.warehousename
,connections.dbname
, and connections.rolename
variables in the SnowSQL~/.snowsql/config
) before falling back on thedeploy
detects undeployed dependencies, it now eliminates duplicates$SQITCH_TARGET
environment variable, which takescore.engine
isn't set unless no targets are found. This lets enginescore.engine
is set. Thisno_default
parameter to theparse_args()
method of App::Sqitch Command. It also greatly reduces the--engine
option, which was previously required to workASSERT()
function for verify scripts toverify
command now reads deploy.variables
, and individualverify.variables override
deploy.variables, on the assumption that the verify variables in general ought to be the same as the deploy variables. This makes
verifyvariable configuration consistent with
revert` variable--set-deploy
option on the rebase
and checkout
--set
option to apply a variable to both reverts and deploys.--set
option on the init
, engine
,target
commands. These commands allow the configuration of databasedeploy
, revert
, verify
,rebase
, and checkout
). The commands merge the variables from each level--set-deploy
and --set-revert
options on rebase
and checkout
--set
optiontarget.$target.variables
engine.$engine.variables
deploy.variables
, revert.variables
, and verify.variables
core.variables
sqitch-configuration
for general documentation of of the hierarchy for--chdir
/--cd
/-C
option to specify a directory to change to--no-pager
option to disable the pager (#414).--opt=val
syntax instead of --opt val
, so that Sqitch doesn't thinkval
is the command. Even in that case, it will search the rest of thesqitch [command] [options]
.-V
has been--version
, although -v
remains for now,-v
in a command be discovered.--registry
, --client
, --db-name
, --db-user
, --db-host
, and--db-port
(and their aliases) have been moved to the checkout
,deploy
, log
, rebase
, revert
, status
, upgrade
, andverify
commands.--plan-file
and --top-dir
(deprecated; see below) have been movedadd
, bundle
, checkout
, deploy
, rebase
, revert
,rework
, show
, status
, tag
, and verify
commands. They wereinit
, engine
, and target
commands--top-dir
is not deprecated).--verbose
option on the --engine
and --target
commands has been--verbose
option.--dir
alias for --top-dir
has been removed, as itinit
, engine
, and target
commands.-d
alias for --set-deploy
in the rebase
and checkout
commands-e
so as not to conflict with the -d
alias for--db-name
.--top-dir
option in favor of --chdir
with a warninginit
, engine
, and target
--deploy-dir
, --revert-dir
, and --verify-dir
options,--dir
option to the init
, engine
, and target
commands--engine
option. The init
command stillsqitch deploy mysql
— or implicitly as part of a target,sqitch revert db:pg:tryme
. When Sqitch is unable to determine the--engine
andinit
core.$engine
configuration, which has beenengine.$engine
since 0.997 (Novembersqitch engine update-config
action remains available to update--deploy
, --revert
, and --verify
options on the add
--no-*
variants. They have been deprecated with--with
and --without
options since v0.990--deploy-template
, --revert-template
, and--verify-template
options to the add
command. They have been deprecated--use
option since v0.990 (January 2014).add.deploy_template
, add.revert_template
, andadd.verify_template
configuration settings. They have been deprecated withadd.templates
configuration section since v0.990@FIRST
and @LAST
symbolic tags, which have been deprecated@ROOT
and @HEAD
, respectively, since 0.997--to-target
, --upto-target
, which have been deprecated with warnings--to-change
--upto-change
, since v0.997 (November 2014).engine
and target
command set-*
actions and theiralter
user
, host
, port
, and dbname
toall_targets
grouptarget_params
method to App::Sqitch::Command and updated allclass_for
method to App::Sqitch::Command so that the new optionscreate
constructor to App::Sqitch::Command to let Sqitchclass_for
.load
method, which handled the functionalityclass_for
and create
. That method still exists but is used only--top-dir
triggers a warning.verbosity
attribute from App::Sqitch::Command::engine and--verbose
option is no longer--verbose
option.config
parameter to theall_targets
constructor of App::Sqitch::Target, since it was never used bysqitch
parameter.config
parameter has not been removed, since third-partiesset_*
methods in the engine
and target
commands, whichalter
method since v0.9993old_id
and old_info
methods from Change and Tag, which datePublished by theory over 11 years ago