./databases/p5-App-Sqitch, Sensible database change management

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 1.3.1, Package name: p5-App-Sqitch-1.3.1, Maintainer: schmonz

Sqitch is a VCS-aware SQL change management application. What makes
it different from your typical migration-style approaches? A few
things:

* No opinions
* Native scripting
* VCS integration
* Dependency resolution
* No numbering
* Bundling
* Reduced duplication


Required to run:
[textproc/p5-String-ShellQuote] [www/p5-URI] [www/p5-Template-Toolkit] [misc/p5-Locale-libintl] [databases/p5-DBI] [lang/perl5] [security/p5-Digest-SHA] [time/p5-DateTime] [devel/p5-IO-Pager] [devel/p5-Scalar-List-Utils] [devel/p5-List-MoreUtils] [devel/p5-Path-Class] [devel/p5-Devel-StackTrace] [devel/p5-Clone] [devel/p5-Sub-Exporter] [devel/p5-IPC-Run3] [devel/p5-Hash-Merge] [devel/p5-SUPER] [devel/p5-Term-ANSIColor] [devel/p5-namespace-autoclean] [devel/p5-IPC-System-Simple] [devel/p5-Class-XSAccessor] [devel/p5-Try-Tiny] [devel/p5-Config-GitLike] [textproc/p5-Template-Tiny] [devel/p5-Throwable] [textproc/p5-Encode-Locale] [devel/p5-Moo] [textproc/p5-String-Formatter] [www/p5-URI-db] [devel/p5-PerlIO-utf8_strict] [devel/p5-Type-Tiny] [devel/p5-Type-Tiny-XS]

Required to build:
[textproc/p5-Text-Diff] [databases/p5-DBD-SQLite] [devel/p5-Test-Exception] [devel/p5-Test-NoWarnings] [devel/p5-Module-Build] [devel/p5-Test-Deep] [devel/p5-Test-File-Contents] [devel/p5-Test-MockModule] [devel/p5-Capture-Tiny] [devel/p5-Module-Runtime] [devel/p5-Test-Dir] [devel/p5-Test-File] [pkgtools/cwrappers]

Package options: sqlite

Master sites: (Expand)

Filesize: 620.577 KB

Version history: (Expand)


CVS history: (Expand)


   2022-10-03 01:51:06 by Amitai Schleier | Files touched by this commit (2)
Log message:
Update to 1.3.1. From the changelog:

- Fixed a bug introduced in v1.3.0 where the Postgres engine would
  always pass the port to `psql`, thus ignoring the `PGPORT` environment
  variable. Thanks to Cam Feenstra for the spot (#675)!
- Fixed test failures on OSes where the local time zone cannot be
  determined. Thanks to Slaven Rezić for the test reports, and to
  Dave Rolsky for the solution (#672).
- Updated the MySQL deploy/revert lock to be specific to the target
  database. This allows multiple instances of Sqitch to run at the
  same time on the same server as long as they're connecting to different
  databases. Thanks to Dmytro Kh for the report and discussion of the
  options (#670).
- Fixed test failures where DBD::Mem was not installed. Likely only
  occurred on some CPAN Testers nodes. Thanks to Slaven Rezić for those
  (#673).
- Banned the backslash character (`\`) in change and tag names. It would
  be ignored on Unix-style systems, but create unexpected subdirectories
  on Windows systems.
- Banned the slash character (`/`) 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)!
   2022-08-14 19:21:50 by Amitai Schleier | Files touched by this commit (3) | Package updated
Log message:
Update to 1.3.0. From the changelog:

- Fixed an issue when testing Firebird on a host with Firebird installed
  but no `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).
- Tweaked the Postgres engine to support Yugabyte. The only unsupported
  features are explicit locks, so users need to manually ensure that only
  one instance of Sqitch is updating the cluster at a time.
- Added support for CockroachDB. Almost exactly the same as for Postgres,
  so the new App::Sqitch::Engine::cockroach class extends
  App::Sqitch::Engine::pg to make a few changes. The SQL files with
  the registry DDL varies in a few ways, so they're separate.
- Now require URI::db v0.20 for Cockroach and Yugabyte URI support.
- Dropped support for MySQL 5.0.
- Added explicit sorting for aggregated lists (such as the tags associated
  with a commit) to the MySQL, Exasol, Snowflake, and Postgres (8.4 and
  higher) engines.
- Fixed slow deploys on MariaDB thanks to fractional timestamp support
  added in 5.03.05. Thanks to @rbrigot for the PR (#658)!
- Fixed a bug where destination locking failed on the first deploy to
  MySQL. Bug introduced along with destination locking in v1.2.0.
  Thanks Tom Bloor the report and to Alberto Simões for the help
  replicating the issue (#601).
- Removed the `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.
- Fixed a warning when searching for the Firebird client on Windows.

pkgsrc changes:

- Enable 'sqlite' by default to pass the self-tests.
   2022-06-28 13:38:00 by Thomas Klausner | Files touched by this commit (3952)
Log message:
*: recursive bump for perl 5.36
   2021-12-06 13:48:15 by Amitai Schleier | Files touched by this commit (2)
Log message:
Update to 1.2.1. From the changelog:

- Updated all the live engine tests, aside from Oracle, to test with
  unique registry names, so as to avoid conflicts when multiple
  instances are being tested at once. Thanks to Slaven Rezić for the
  report (#597).
- Removed `local` directory from the distribution, accidentally included
  in v1.2.0. Thanks to gregor herrmann for the report (#600).
   2021-11-21 15:55:44 by Amitai Schleier | Files touched by this commit (2) | Package updated
Log message:
Update to 1.2.0. From the changelog:

- Fixed partitioned search for deployed changes on Oracle and Exasol to
  correctly support plans with more than 250 changes. Thanks to @Nicqu
  for the report (#521).
- DBI connections to the registry will now be set to trace level one
  when a verbosity level of three or higher is passed to Sqitch
  (i.e., `sqitch -vvv`). Thanks to @wkoszek for the suggestion (#155).
- Renamed the "master" branch to "main" and updated all relevant
  references.
- Fixed the parsing of the Snowflake account name from the target URL
  to that it no longer strips out the region and cloud platform parts.
  Also deprecated the use of the region, host, and port config and
  environment variables. This is to comply with the new account name
  format. Thanks to @ldsingh00 for the report (#544).
- The checkout command will now show a usage statement when no branch
  name is passed to it, rather than a series of warnings and a Git error.
  Thanks to François Beausoleil for the report (#561).
- The checkout command now works when operating on a Sqitch project in
  a subdirectory of a Git project. Thanks to François Beausoleil for the
  report and suggested fix (#560).
- Fixed a failing bundle test when a top directory was configured in the
  user or system configuration. Thanks to @CodingMinds for the spot
  (#587).
- Added support to the Exasol engine for the `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).
- Fixed "Use of uninitialized value $engine in concatenation" error when
  Sqitch is unable to determine the engine when writing a plan file. Only
  happens in the rare case that the core.engine value is not set.
- Improved the error message when attempting to update a plan file and no
  project pragma is present. Thanks to Laurentiu Diaconu for the report
  (#577).
- Fixed the error message when attempting to deploy a change that has
  already been deployed to display the name of the change, rather than a
  memory address. Thanks to Neil Mayhew for the report (#579).
- Added destination locking, currently implemented for PostgresQL and
  MySQL. On starting a deploy or revert, Sqitch attempts to "lock the
  destination" using advisory locks, to ensure that only one instance of
  Sqitch makes changes to the database at any one time. This complements
  the existing locking, which applies as each change is deployed or
  reverted, as that pattern led to failures when multiple instances of
  Sqitch were working at once. Thanks to Neil Mayhew for the report
  (#579).
- Added the --lock-timeout option to the deploy, revert, rebase, and
  checkout commands, to allow for shorter or longer times to wait for an
  exclusive target database advisory lock for engines that support it.
  Defaults to 60 seconds.
- Fixed the behavior of the plan command's `--max-count` option when used
  with `--reverse` to show the proper items. Thanks to Adrian Klaver for
  the report (#517).
- Fixed an issue that could cause bugs with the `check` command on
  Firebird, Exasol, Oracle, and Vertica. Broken since the `check` command
  was added in v1.1.0.
   2021-10-26 12:10:08 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Replace RMD160 checksums with BLAKE2s checksums

All checksums have been double-checked against existing RMD160 and
SHA512 hashes

The following distfiles could not be fetched (some may be only fetched
conditionally):

./databases/cstore/distinfo D6.data.ros.gz
./databases/cstore/distinfo cstore0.2.tar.gz
./databases/cstore/distinfo data4.tar.gz
   2021-10-07 15:35:53 by Nia Alarie | Files touched by this commit (417)
Log message:
databases: Remove SHA1 distfile hashes
   2021-05-24 21:56:06 by Thomas Klausner | Files touched by this commit (3575)
Log message:
*: recursive bump for perl 5.34