diff --git a/databases/p5-App-Sqitch/Makefile b/databases/p5-App-Sqitch/Makefile index fe5b10dbb7c6..93fde053b326 100644 --- a/databases/p5-App-Sqitch/Makefile +++ b/databases/p5-App-Sqitch/Makefile @@ -1,31 +1,37 @@ +# Created by: Henrik Hodne + PORTNAME= App-Sqitch -PORTVERSION= 0.9994 -PORTREVISION= 1 +PORTVERSION= 1.2.1 +DISTVERSIONPREFIX= v CATEGORIES= databases perl5 MASTER_SITES= CPAN -MASTER_SITE_SUBDIR= CPAN:MIYAGAWA +MASTER_SITE_SUBDIR= CPAN:DWHEELER PKGNAMEPREFIX= p5- MAINTAINER= henrik@hodne.io -COMMENT= Sane database change management +COMMENT= Sensible database change management LICENSE= MIT TEST_DEPENDS= p5-Capture-Tiny>=0:devel/p5-Capture-Tiny \ + p5-IO-Pager>=0.34:devel/p5-IO-Pager \ p5-Test-Dir>=0:misc/p5-Test-Dir \ + p5-Test-File>=0:devel/p5-Test-File \ p5-Test-File-Contents>=0:devel/p5-Test-File-Contents \ - p5-Test-MockModule>=0:devel/p5-Test-MockModule + p5-Module-Runtime>=0:devel/p5-Module-Runtime \ + p5-Test-MockModule>=0.17:devel/p5-Test-MockModule \ + p5-Test-Warn>=0:devel/p5-Test-Warn BUILD_DEPENDS= ${RUN_DEPENDS} -RUN_DEPENDS= p5-Clone>=0:devel/p5-Clone \ - p5-Config-GitLike>=1.11:devel/p5-Config-GitLike \ +RUN_DEPENDS= p5-Algorithm-Backoff>=0.006:devel/p5-Algorithm-Backoff \ + p5-Clone>=0:devel/p5-Clone \ + p5-Config-GitLike>=1.15:devel/p5-Config-GitLike \ p5-DBI>=0:databases/p5-DBI \ - p5-DateTime>=0:devel/p5-DateTime \ + p5-DateTime>=1.04:devel/p5-DateTime \ p5-DateTime-TimeZone>=0:devel/p5-DateTime-TimeZone \ p5-Devel-StackTrace>=1.30:devel/p5-Devel-StackTrace \ p5-Encode-Locale>=0:converters/p5-Encode-Locale \ - p5-File-HomeDir>=0:devel/p5-File-HomeDir \ p5-Hash-Merge>=0:textproc/p5-Hash-Merge \ - p5-IO-Pager>=0:devel/p5-IO-Pager \ + p5-IO-Pager>=0.34:devel/p5-IO-Pager \ p5-IPC-Run3>=0:devel/p5-IPC-Run3 \ p5-IPC-System-Simple>=1.17:devel/p5-IPC-System-Simple \ p5-List-MoreUtils>=0:lang/p5-List-MoreUtils \ @@ -33,6 +39,8 @@ RUN_DEPENDS= p5-Clone>=0:devel/p5-Clone \ p5-Moo>=1.002000:devel/p5-Moo \ p5-Path-Class>=0.33:devel/p5-Path-Class \ p5-PerlIO-utf8_strict>=0:devel/p5-PerlIO-utf8_strict \ + p5-Pod-Escapes>=1.04:textproc/p5-Pod-Escapes \ + p5-Pod-Parser>=0:textproc/p5-Pod-Parser \ p5-Template-Tiny>=0.11:textproc/p5-Template-Tiny \ p5-String-Formatter>=0:devel/p5-String-Formatter \ p5-String-ShellQuote>=0:textproc/p5-String-ShellQuote \ @@ -42,10 +50,10 @@ RUN_DEPENDS= p5-Clone>=0:devel/p5-Clone \ p5-Try-Tiny>=0:lang/p5-Try-Tiny \ p5-Type-Tiny>=0.040:devel/p5-Type-Tiny \ p5-URI>=0:net/p5-URI \ - p5-URI-db>=0.15:net/p5-URI-db \ + p5-URI-db>=0.19:net/p5-URI-db \ p5-namespace-autoclean>=0.16:devel/p5-namespace-autoclean -USES= gettext perl5 +USES= perl5 USE_PERL5= modbuild NO_ARCH= YES diff --git a/databases/p5-App-Sqitch/distinfo b/databases/p5-App-Sqitch/distinfo index 68ab2d52a9ce..912470a82254 100644 --- a/databases/p5-App-Sqitch/distinfo +++ b/databases/p5-App-Sqitch/distinfo @@ -1,2 +1,3 @@ -SHA256 (App-Sqitch-0.9994.tar.gz) = 24de7770884419f199d24fa2ce81f5e7a27583028f685e6973a06840be00c646 -SIZE (App-Sqitch-0.9994.tar.gz) = 490681 +TIMESTAMP = 1659585581 +SHA256 (App-Sqitch-v1.2.1.tar.gz) = 020835a13429effd8fda12d5627604ecf99293775918f4f8ba9ccc5ed796e5e7 +SIZE (App-Sqitch-v1.2.1.tar.gz) = 613784 diff --git a/databases/p5-App-Sqitch/pkg-descr b/databases/p5-App-Sqitch/pkg-descr index fdf8e0b17880..406af72a2059 100644 --- a/databases/p5-App-Sqitch/pkg-descr +++ b/databases/p5-App-Sqitch/pkg-descr @@ -3,7 +3,7 @@ different from your typical migration-style approaches? A few things: ## No opinions -Sqitch is not integrated with any framework, ORM, or platform. +Sqitch is not tied to any framework, ORM, or platform. Rather, it is a standalone change management system with no opinions about your database engine, application framework, or development environment. @@ -12,7 +12,7 @@ environment. Changes are implemented as scripts native to your selected database engine. Writing a PostgreSQL application? Write SQL scripts for -psql. Writing a MySQL-backed app? Write SQL scripts for mysql. +psql. Writing an Oracle-backed app? Write SQL scripts for SQL*Plus. ## Dependency resolution @@ -21,18 +21,20 @@ on changes from other Sqitch projects. This ensures proper order of execution, even when you've committed changes to your VCS out-of-order. -## No numbering +## Deployment integrity -Change deployment is managed by maintaining a plan file. As such, -there is no need to number your changes, although you can if you -want. Sqitch doesn't much care how you name your changes. +Sqitch manages changes and dependencies via a plan file, and employs a +Merkle tree pattern similar to Git and Blockchain to ensure +deployment integrity. As such, there is no need to number your changes, +although you can if you want. Sqitch doesn't much care how you name your +changes. ## Iterative development -Up until you tag and release your application, you can modify your -change deployment scripts as often as you like. They're not locked -in just because they've been committed to your VCS. This allows you -to take an iterative approach to developing your database schema. -Or, better, you can do test-driven database development. +Up until you tag and release your project, you can modify your change +deployment scripts as often as you like. They're not locked in just because +they've been committed to your VCS. This allows you to take an iterative +approach to developing your database schema. Or, better, you can do +test-driven database development. WWW: https://metacpan.org/release/App-Sqitch diff --git a/databases/p5-App-Sqitch/pkg-plist b/databases/p5-App-Sqitch/pkg-plist index fc7ce79e17c9..d918968b069c 100644 --- a/databases/p5-App-Sqitch/pkg-plist +++ b/databases/p5-App-Sqitch/pkg-plist @@ -1,20 +1,26 @@ bin/sqitch +etc/sqitch/templates/deploy/exasol.tmpl etc/sqitch/templates/deploy/firebird.tmpl etc/sqitch/templates/deploy/mysql.tmpl etc/sqitch/templates/deploy/oracle.tmpl etc/sqitch/templates/deploy/pg.tmpl +etc/sqitch/templates/deploy/snowflake.tmpl etc/sqitch/templates/deploy/sqlite.tmpl etc/sqitch/templates/deploy/vertica.tmpl +etc/sqitch/templates/revert/exasol.tmpl etc/sqitch/templates/revert/firebird.tmpl etc/sqitch/templates/revert/mysql.tmpl etc/sqitch/templates/revert/oracle.tmpl etc/sqitch/templates/revert/pg.tmpl +etc/sqitch/templates/revert/snowflake.tmpl etc/sqitch/templates/revert/sqlite.tmpl etc/sqitch/templates/revert/vertica.tmpl +etc/sqitch/templates/verify/exasol.tmpl etc/sqitch/templates/verify/firebird.tmpl etc/sqitch/templates/verify/mysql.tmpl etc/sqitch/templates/verify/oracle.tmpl etc/sqitch/templates/verify/pg.tmpl +etc/sqitch/templates/verify/snowflake.tmpl etc/sqitch/templates/verify/sqlite.tmpl etc/sqitch/templates/verify/vertica.tmpl etc/sqitch/tools/upgrade-registry-to-mysql-5.5.0.sql @@ -23,6 +29,7 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%SITE_PERL%%/App/Sqitch/Command.pm %%SITE_PERL%%/App/Sqitch/Command/add.pm %%SITE_PERL%%/App/Sqitch/Command/bundle.pm +%%SITE_PERL%%/App/Sqitch/Command/check.pm %%SITE_PERL%%/App/Sqitch/Command/checkout.pm %%SITE_PERL%%/App/Sqitch/Command/config.pm %%SITE_PERL%%/App/Sqitch/Command/deploy.pm @@ -43,6 +50,8 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%SITE_PERL%%/App/Sqitch/Config.pm %%SITE_PERL%%/App/Sqitch/DateTime.pm %%SITE_PERL%%/App/Sqitch/Engine.pm +%%SITE_PERL%%/App/Sqitch/Engine/Upgrade/exasol-1.0.sql +%%SITE_PERL%%/App/Sqitch/Engine/Upgrade/exasol-1.1.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/firebird-1.0.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/firebird-1.1.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/mysql-1.0.sql @@ -51,10 +60,14 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/oracle-1.1.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/pg-1.0.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/pg-1.1.sql +%%SITE_PERL%%/App/Sqitch/Engine/Upgrade/snowflake-1.0.sql +%%SITE_PERL%%/App/Sqitch/Engine/Upgrade/snowflake-1.1.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/sqlite-1.0.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/sqlite-1.1.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/vertica-1.0.sql %%SITE_PERL%%/App/Sqitch/Engine/Upgrade/vertica-1.1.sql +%%SITE_PERL%%/App/Sqitch/Engine/exasol.pm +%%SITE_PERL%%/App/Sqitch/Engine/exasol.sql %%SITE_PERL%%/App/Sqitch/Engine/firebird.pm %%SITE_PERL%%/App/Sqitch/Engine/firebird.sql %%SITE_PERL%%/App/Sqitch/Engine/mysql.pm @@ -63,6 +76,8 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%SITE_PERL%%/App/Sqitch/Engine/oracle.sql %%SITE_PERL%%/App/Sqitch/Engine/pg.pm %%SITE_PERL%%/App/Sqitch/Engine/pg.sql +%%SITE_PERL%%/App/Sqitch/Engine/snowflake.pm +%%SITE_PERL%%/App/Sqitch/Engine/snowflake.sql %%SITE_PERL%%/App/Sqitch/Engine/sqlite.pm %%SITE_PERL%%/App/Sqitch/Engine/sqlite.sql %%SITE_PERL%%/App/Sqitch/Engine/vertica.pm @@ -77,18 +92,22 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%SITE_PERL%%/App/Sqitch/Plan/LineList.pm %%SITE_PERL%%/App/Sqitch/Plan/Pragma.pm %%SITE_PERL%%/App/Sqitch/Plan/Tag.pm +%%SITE_PERL%%/App/Sqitch/Role/ConnectingCommand.pm +%%SITE_PERL%%/App/Sqitch/Role/ContextCommand.pm %%SITE_PERL%%/App/Sqitch/Role/DBIEngine.pm %%SITE_PERL%%/App/Sqitch/Role/RevertDeployCommand.pm %%SITE_PERL%%/App/Sqitch/Role/TargetConfigCommand.pm %%SITE_PERL%%/App/Sqitch/Target.pm %%SITE_PERL%%/App/Sqitch/Types.pm %%SITE_PERL%%/App/Sqitch/X.pm -%%SITE_PERL%%/LocaleData/de/LC_MESSAGES/App-Sqitch.mo -%%SITE_PERL%%/LocaleData/fr/LC_MESSAGES/App-Sqitch.mo +%%SITE_PERL%%/LocaleData/de_DE/LC_MESSAGES/App-Sqitch.mo +%%SITE_PERL%%/LocaleData/fr_FR/LC_MESSAGES/App-Sqitch.mo +%%SITE_PERL%%/LocaleData/it_IT/LC_MESSAGES/App-Sqitch.mo %%PERL5_MAN3%%/App::Sqitch.3.gz %%PERL5_MAN3%%/App::Sqitch::Command.3.gz %%PERL5_MAN3%%/App::Sqitch::Command::add.3.gz %%PERL5_MAN3%%/App::Sqitch::Command::bundle.3.gz +%%PERL5_MAN3%%/App::Sqitch::Command::check.3.gz %%PERL5_MAN3%%/App::Sqitch::Command::checkout.3.gz %%PERL5_MAN3%%/App::Sqitch::Command::config.3.gz %%PERL5_MAN3%%/App::Sqitch::Command::deploy.3.gz @@ -109,10 +128,12 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%PERL5_MAN3%%/App::Sqitch::Config.3.gz %%PERL5_MAN3%%/App::Sqitch::DateTime.3.gz %%PERL5_MAN3%%/App::Sqitch::Engine.3.gz +%%PERL5_MAN3%%/App::Sqitch::Engine::exasol.3.gz %%PERL5_MAN3%%/App::Sqitch::Engine::firebird.3.gz %%PERL5_MAN3%%/App::Sqitch::Engine::mysql.3.gz %%PERL5_MAN3%%/App::Sqitch::Engine::oracle.3.gz %%PERL5_MAN3%%/App::Sqitch::Engine::pg.3.gz +%%PERL5_MAN3%%/App::Sqitch::Engine::snowflake.3.gz %%PERL5_MAN3%%/App::Sqitch::Engine::sqlite.3.gz %%PERL5_MAN3%%/App::Sqitch::Engine::vertica.3.gz %%PERL5_MAN3%%/App::Sqitch::ItemFormatter.3.gz @@ -125,6 +146,8 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%PERL5_MAN3%%/App::Sqitch::Plan::LineList.3.gz %%PERL5_MAN3%%/App::Sqitch::Plan::Pragma.3.gz %%PERL5_MAN3%%/App::Sqitch::Plan::Tag.3.gz +%%PERL5_MAN3%%/App::Sqitch::Role::ConnectingCommand.3.gz +%%PERL5_MAN3%%/App::Sqitch::Role::ContextCommand.3.gz %%PERL5_MAN3%%/App::Sqitch::Role::DBIEngine.3.gz %%PERL5_MAN3%%/App::Sqitch::Role::RevertDeployCommand.3.gz %%PERL5_MAN3%%/App::Sqitch::Role::TargetConfigCommand.3.gz @@ -133,8 +156,11 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%PERL5_MAN3%%/App::Sqitch::X.3.gz %%PERL5_MAN3%%/sqitch-add-usage.3.gz %%PERL5_MAN3%%/sqitch-add.3.gz +%%PERL5_MAN3%%/sqitch-authentication.3.gz %%PERL5_MAN3%%/sqitch-bundle-usage.3.gz %%PERL5_MAN3%%/sqitch-bundle.3.gz +%%PERL5_MAN3%%/sqitch-check-usage.3.gz +%%PERL5_MAN3%%/sqitch-check.3.gz %%PERL5_MAN3%%/sqitch-checkout-usage.3.gz %%PERL5_MAN3%%/sqitch-checkout.3.gz %%PERL5_MAN3%%/sqitch-config-usage.3.gz @@ -176,17 +202,22 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%PERL5_MAN3%%/sqitchchanges.3.gz %%PERL5_MAN3%%/sqitchcommands.3.gz %%PERL5_MAN3%%/sqitchguides.3.gz +%%PERL5_MAN3%%/sqitchtutorial-exasol.3.gz %%PERL5_MAN3%%/sqitchtutorial-firebird.3.gz %%PERL5_MAN3%%/sqitchtutorial-mysql.3.gz %%PERL5_MAN3%%/sqitchtutorial-oracle.3.gz +%%PERL5_MAN3%%/sqitchtutorial-snowflake.3.gz %%PERL5_MAN3%%/sqitchtutorial-sqlite.3.gz %%PERL5_MAN3%%/sqitchtutorial-vertica.3.gz %%PERL5_MAN3%%/sqitchtutorial.3.gz %%PERL5_MAN3%%/sqitchusage.3.gz %%SITE_PERL%%/sqitch-add-usage.pod %%SITE_PERL%%/sqitch-add.pod +%%SITE_PERL%%/sqitch-authentication.pod %%SITE_PERL%%/sqitch-bundle-usage.pod %%SITE_PERL%%/sqitch-bundle.pod +%%SITE_PERL%%/sqitch-check-usage.pod +%%SITE_PERL%%/sqitch-check.pod %%SITE_PERL%%/sqitch-checkout-usage.pod %%SITE_PERL%%/sqitch-checkout.pod %%SITE_PERL%%/sqitch-config-usage.pod @@ -228,9 +259,11 @@ etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql %%SITE_PERL%%/sqitchchanges.pod %%SITE_PERL%%/sqitchcommands.pod %%SITE_PERL%%/sqitchguides.pod +%%SITE_PERL%%/sqitchtutorial-exasol.pod %%SITE_PERL%%/sqitchtutorial-firebird.pod %%SITE_PERL%%/sqitchtutorial-mysql.pod %%SITE_PERL%%/sqitchtutorial-oracle.pod +%%SITE_PERL%%/sqitchtutorial-snowflake.pod %%SITE_PERL%%/sqitchtutorial-sqlite.pod %%SITE_PERL%%/sqitchtutorial-vertica.pod %%SITE_PERL%%/sqitchtutorial.pod