5 files changed, 333 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index a4b1c157ef11..332d39e1375e 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -249,6 +249,7 @@
     SUBDIR += p5-AnyEvent-DBD-Pg
     SUBDIR += p5-AnyEvent-Memcached
     SUBDIR += p5-AnyEvent-Redis
+    SUBDIR += p5-App-Sqitch
     SUBDIR += p5-AsciiDB-TagFile
     SUBDIR += p5-BDB
     SUBDIR += p5-BSON
diff --git a/databases/p5-App-Sqitch/Makefile b/databases/p5-App-Sqitch/Makefile
new file mode 100644
index 000000000000..e8aaf29df518
--- /dev/null
+++ b/databases/p5-App-Sqitch/Makefile
@@ -0,0 +1,55 @@
+# Created by: Henrik Hodne <henrik@hodne.io>
+# $FreeBSD$
+
+PORTNAME=	App-Sqitch
+PORTVERSION=	0.9994
+CATEGORIES=	databases perl5
+MASTER_SITES=	CPAN
+MASTER_SITE_SUBDIR=	CPAN:MIYAGAWA
+PKGNAMEPREFIX=	p5-
+
+MAINTAINER=	henrik@hodne.io
+COMMENT=	Sane database change management
+
+LICENSE=	MIT
+
+TEST_DEPENDS=	p5-Capture-Tiny>=0:devel/p5-Capture-Tiny \
+		p5-Test-Dir>=0:misc/p5-Test-Dir \
+		p5-Test-File-Contents>=0:devel/p5-Test-File-Contents \
+		p5-Test-MockModule>=0:devel/p5-Test-MockModule
+BUILD_DEPENDS=	p5-Clone>=0:devel/p5-Clone \
+		p5-Config-GitLike>=1.11:devel/p5-Config-GitLike \
+		p5-DBI>=0:databases/p5-DBI \
+		p5-DateTime>=0: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-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 \
+		p5-Locale-libintl>=1.20:devel/p5-Locale-libintl \
+		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-Template-Tiny>=0.11:textproc/p5-Template-Tiny \
+		p5-String-Formatter>=0:devel/p5-String-Formatter \
+		p5-String-ShellQuote>=0:textproc/p5-String-ShellQuote \
+		p5-Sub-Exporter>=0:devel/p5-Sub-Exporter \
+		p5-Template-Tiny>=0.11:textproc/p5-Template-Tiny \
+		p5-Throwable>=0.200009:devel/p5-Throwable \
+		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-namespace-autoclean>=0.16:devel/p5-namespace-autoclean
+
+RUN_DEPENDS:=	${BUILD_DEPENDS}
+
+USES=		gettext perl5
+USE_PERL5=	modbuild
+NO_ARCH=	YES
+
+.include <bsd.port.mk>
diff --git a/databases/p5-App-Sqitch/distinfo b/databases/p5-App-Sqitch/distinfo
new file mode 100644
index 000000000000..68ab2d52a9ce
--- /dev/null
+++ b/databases/p5-App-Sqitch/distinfo
@@ -0,0 +1,2 @@
+SHA256 (App-Sqitch-0.9994.tar.gz) = 24de7770884419f199d24fa2ce81f5e7a27583028f685e6973a06840be00c646
+SIZE (App-Sqitch-0.9994.tar.gz) = 490681
diff --git a/databases/p5-App-Sqitch/pkg-descr b/databases/p5-App-Sqitch/pkg-descr
new file mode 100644
index 000000000000..d94d7435a06d
--- /dev/null
+++ b/databases/p5-App-Sqitch/pkg-descr
@@ -0,0 +1,38 @@
+Sqitch is a database change management application. What makes it
+different from your typical migration-style approaches? A few things:
+
+## No opinions
+
+Sqitch is not integrated with 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.
+
+## Native scripting
+
+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.
+
+## Dependency resolution
+
+Database changes may declare dependencies on other changes -- even
+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
+
+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.
+
+## 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.
+
+WWW: http://search.cpan.org/dist/App-Sqitch/
diff --git a/databases/p5-App-Sqitch/pkg-plist b/databases/p5-App-Sqitch/pkg-plist
new file mode 100644
index 000000000000..fc7ce79e17c9
--- /dev/null
+++ b/databases/p5-App-Sqitch/pkg-plist
@@ -0,0 +1,237 @@
+bin/sqitch
+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/sqlite.tmpl
+etc/sqitch/templates/deploy/vertica.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/sqlite.tmpl
+etc/sqitch/templates/revert/vertica.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/sqlite.tmpl
+etc/sqitch/templates/verify/vertica.tmpl
+etc/sqitch/tools/upgrade-registry-to-mysql-5.5.0.sql
+etc/sqitch/tools/upgrade-registry-to-mysql-5.6.4.sql
+%%SITE_PERL%%/App/Sqitch.pm
+%%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/checkout.pm
+%%SITE_PERL%%/App/Sqitch/Command/config.pm
+%%SITE_PERL%%/App/Sqitch/Command/deploy.pm
+%%SITE_PERL%%/App/Sqitch/Command/engine.pm
+%%SITE_PERL%%/App/Sqitch/Command/help.pm
+%%SITE_PERL%%/App/Sqitch/Command/init.pm
+%%SITE_PERL%%/App/Sqitch/Command/log.pm
+%%SITE_PERL%%/App/Sqitch/Command/plan.pm
+%%SITE_PERL%%/App/Sqitch/Command/rebase.pm
+%%SITE_PERL%%/App/Sqitch/Command/revert.pm
+%%SITE_PERL%%/App/Sqitch/Command/rework.pm
+%%SITE_PERL%%/App/Sqitch/Command/show.pm
+%%SITE_PERL%%/App/Sqitch/Command/status.pm
+%%SITE_PERL%%/App/Sqitch/Command/tag.pm
+%%SITE_PERL%%/App/Sqitch/Command/target.pm
+%%SITE_PERL%%/App/Sqitch/Command/upgrade.pm
+%%SITE_PERL%%/App/Sqitch/Command/verify.pm
+%%SITE_PERL%%/App/Sqitch/Config.pm
+%%SITE_PERL%%/App/Sqitch/DateTime.pm
+%%SITE_PERL%%/App/Sqitch/Engine.pm
+%%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
+%%SITE_PERL%%/App/Sqitch/Engine/Upgrade/mysql-1.1.sql
+%%SITE_PERL%%/App/Sqitch/Engine/Upgrade/oracle-1.0.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/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/firebird.pm
+%%SITE_PERL%%/App/Sqitch/Engine/firebird.sql
+%%SITE_PERL%%/App/Sqitch/Engine/mysql.pm
+%%SITE_PERL%%/App/Sqitch/Engine/mysql.sql
+%%SITE_PERL%%/App/Sqitch/Engine/oracle.pm
+%%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/sqlite.pm
+%%SITE_PERL%%/App/Sqitch/Engine/sqlite.sql
+%%SITE_PERL%%/App/Sqitch/Engine/vertica.pm
+%%SITE_PERL%%/App/Sqitch/Engine/vertica.sql
+%%SITE_PERL%%/App/Sqitch/ItemFormatter.pm
+%%SITE_PERL%%/App/Sqitch/Plan.pm
+%%SITE_PERL%%/App/Sqitch/Plan/Blank.pm
+%%SITE_PERL%%/App/Sqitch/Plan/Change.pm
+%%SITE_PERL%%/App/Sqitch/Plan/ChangeList.pm
+%%SITE_PERL%%/App/Sqitch/Plan/Depend.pm
+%%SITE_PERL%%/App/Sqitch/Plan/Line.pm
+%%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/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
+%%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::checkout.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::config.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::deploy.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::engine.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::help.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::init.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::log.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::plan.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::rebase.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::revert.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::rework.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::show.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::status.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::tag.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::target.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::upgrade.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Command::verify.3.gz
+%%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::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::sqlite.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Engine::vertica.3.gz
+%%PERL5_MAN3%%/App::Sqitch::ItemFormatter.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Plan.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Plan::Blank.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Plan::Change.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Plan::ChangeList.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Plan::Depend.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Plan::Line.3.gz
+%%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::DBIEngine.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Role::RevertDeployCommand.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Role::TargetConfigCommand.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Target.3.gz
+%%PERL5_MAN3%%/App::Sqitch::Types.3.gz
+%%PERL5_MAN3%%/App::Sqitch::X.3.gz
+%%PERL5_MAN3%%/sqitch-add-usage.3.gz
+%%PERL5_MAN3%%/sqitch-add.3.gz
+%%PERL5_MAN3%%/sqitch-bundle-usage.3.gz
+%%PERL5_MAN3%%/sqitch-bundle.3.gz
+%%PERL5_MAN3%%/sqitch-checkout-usage.3.gz
+%%PERL5_MAN3%%/sqitch-checkout.3.gz
+%%PERL5_MAN3%%/sqitch-config-usage.3.gz
+%%PERL5_MAN3%%/sqitch-config.3.gz
+%%PERL5_MAN3%%/sqitch-configuration.3.gz
+%%PERL5_MAN3%%/sqitch-deploy-usage.3.gz
+%%PERL5_MAN3%%/sqitch-deploy.3.gz
+%%PERL5_MAN3%%/sqitch-engine-usage.3.gz
+%%PERL5_MAN3%%/sqitch-engine.3.gz
+%%PERL5_MAN3%%/sqitch-environment.3.gz
+%%PERL5_MAN3%%/sqitch-help-usage.3.gz
+%%PERL5_MAN3%%/sqitch-help.3.gz
+%%PERL5_MAN3%%/sqitch-init-usage.3.gz
+%%PERL5_MAN3%%/sqitch-init.3.gz
+%%PERL5_MAN3%%/sqitch-log-usage.3.gz
+%%PERL5_MAN3%%/sqitch-log.3.gz
+%%PERL5_MAN3%%/sqitch-passwords.3.gz
+%%PERL5_MAN3%%/sqitch-plan-usage.3.gz
+%%PERL5_MAN3%%/sqitch-plan.3.gz
+%%PERL5_MAN3%%/sqitch-rebase-usage.3.gz
+%%PERL5_MAN3%%/sqitch-rebase.3.gz
+%%PERL5_MAN3%%/sqitch-revert-usage.3.gz
+%%PERL5_MAN3%%/sqitch-revert.3.gz
+%%PERL5_MAN3%%/sqitch-rework-usage.3.gz
+%%PERL5_MAN3%%/sqitch-rework.3.gz
+%%PERL5_MAN3%%/sqitch-show-usage.3.gz
+%%PERL5_MAN3%%/sqitch-show.3.gz
+%%PERL5_MAN3%%/sqitch-status-usage.3.gz
+%%PERL5_MAN3%%/sqitch-status.3.gz
+%%PERL5_MAN3%%/sqitch-tag-usage.3.gz
+%%PERL5_MAN3%%/sqitch-tag.3.gz
+%%PERL5_MAN3%%/sqitch-target-usage.3.gz
+%%PERL5_MAN3%%/sqitch-target.3.gz
+%%PERL5_MAN3%%/sqitch-upgrade-usage.3.gz
+%%PERL5_MAN3%%/sqitch-upgrade.3.gz
+%%PERL5_MAN3%%/sqitch-verify-usage.3.gz
+%%PERL5_MAN3%%/sqitch-verify.3.gz
+%%PERL5_MAN3%%/sqitch.3.gz
+%%PERL5_MAN3%%/sqitchchanges.3.gz
+%%PERL5_MAN3%%/sqitchcommands.3.gz
+%%PERL5_MAN3%%/sqitchguides.3.gz
+%%PERL5_MAN3%%/sqitchtutorial-firebird.3.gz
+%%PERL5_MAN3%%/sqitchtutorial-mysql.3.gz
+%%PERL5_MAN3%%/sqitchtutorial-oracle.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-bundle-usage.pod
+%%SITE_PERL%%/sqitch-bundle.pod
+%%SITE_PERL%%/sqitch-checkout-usage.pod
+%%SITE_PERL%%/sqitch-checkout.pod
+%%SITE_PERL%%/sqitch-config-usage.pod
+%%SITE_PERL%%/sqitch-config.pod
+%%SITE_PERL%%/sqitch-configuration.pod
+%%SITE_PERL%%/sqitch-deploy-usage.pod
+%%SITE_PERL%%/sqitch-deploy.pod
+%%SITE_PERL%%/sqitch-engine-usage.pod
+%%SITE_PERL%%/sqitch-engine.pod
+%%SITE_PERL%%/sqitch-environment.pod
+%%SITE_PERL%%/sqitch-help-usage.pod
+%%SITE_PERL%%/sqitch-help.pod
+%%SITE_PERL%%/sqitch-init-usage.pod
+%%SITE_PERL%%/sqitch-init.pod
+%%SITE_PERL%%/sqitch-log-usage.pod
+%%SITE_PERL%%/sqitch-log.pod
+%%SITE_PERL%%/sqitch-passwords.pod
+%%SITE_PERL%%/sqitch-plan-usage.pod
+%%SITE_PERL%%/sqitch-plan.pod
+%%SITE_PERL%%/sqitch-rebase-usage.pod
+%%SITE_PERL%%/sqitch-rebase.pod
+%%SITE_PERL%%/sqitch-revert-usage.pod
+%%SITE_PERL%%/sqitch-revert.pod
+%%SITE_PERL%%/sqitch-rework-usage.pod
+%%SITE_PERL%%/sqitch-rework.pod
+%%SITE_PERL%%/sqitch-show-usage.pod
+%%SITE_PERL%%/sqitch-show.pod
+%%SITE_PERL%%/sqitch-status-usage.pod
+%%SITE_PERL%%/sqitch-status.pod
+%%SITE_PERL%%/sqitch-tag-usage.pod
+%%SITE_PERL%%/sqitch-tag.pod
+%%SITE_PERL%%/sqitch-target-usage.pod
+%%SITE_PERL%%/sqitch-target.pod
+%%SITE_PERL%%/sqitch-upgrade-usage.pod
+%%SITE_PERL%%/sqitch-upgrade.pod
+%%SITE_PERL%%/sqitch-verify-usage.pod
+%%SITE_PERL%%/sqitch-verify.pod
+%%SITE_PERL%%/sqitch.pod
+%%SITE_PERL%%/sqitchchanges.pod
+%%SITE_PERL%%/sqitchcommands.pod
+%%SITE_PERL%%/sqitchguides.pod
+%%SITE_PERL%%/sqitchtutorial-firebird.pod
+%%SITE_PERL%%/sqitchtutorial-mysql.pod
+%%SITE_PERL%%/sqitchtutorial-oracle.pod
+%%SITE_PERL%%/sqitchtutorial-sqlite.pod
+%%SITE_PERL%%/sqitchtutorial-vertica.pod
+%%SITE_PERL%%/sqitchtutorial.pod
+%%SITE_PERL%%/sqitchusage.pod