[pkgsrc/trunk]: pkgsrc/databases New package, p5-pgFormatter. From Kogule Ryo...

[bsiegert <bsiegert%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/73d30e10c946
branches:  trunk
changeset: 769020:73d30e10c946
user:      bsiegert <bsiegert%pkgsrc.org@localhost>
date:      Sat Nov 06 15:09:26 2021 +0000

description:
New package, p5-pgFormatter. From Kogule Ryo in PR pkg/56444.

A PostgreSQL SQL syntax beautifier that can work as a console program or as a
CGI.

This SQL formatter/beautifier supports keywords from SQL-92, SQL-99, SQL-2003,
SQL-2008, SQL-2011 and PostgreSQL specifics keywords. Works with any other
databases too.

Changes from the submitted version in the PR:

- p5 prefix for the package name
- clean up of github logic
- REPLACE_PERL
- updated distinfo with BLAKE2s

diffstat:

 databases/Makefile                |   3 ++-
 databases/p5-pgFormatter/DESCR    |   6 ++++++
 databases/p5-pgFormatter/Makefile |  37 +++++++++++++++++++++++++++++++++++++
 databases/p5-pgFormatter/PLIST    |  14 ++++++++++++++
 databases/p5-pgFormatter/distinfo |   5 +++++
 5 files changed, 64 insertions(+), 1 deletions(-)

diffs (95 lines):

diff -r c8dc1d51c1cd -r 73d30e10c946 databases/Makefile
--- a/databases/Makefile        Sat Nov 06 13:55:04 2021 +0000
+++ b/databases/Makefile        Sat Nov 06 15:09:26 2021 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.641 2021/10/08 10:23:43 adam Exp $
+# $NetBSD: Makefile,v 1.642 2021/11/06 15:09:26 bsiegert Exp $
 
 COMMENT=       Databases
 
@@ -241,6 +241,7 @@
 SUBDIR+=       p5-YAML-MLDBM
 SUBDIR+=       p5-gdbm
 SUBDIR+=       p5-perl-ldap
+SUBDIR+=       p5-pgFormatter
 SUBDIR+=       p5-postgresql
 SUBDIR+=       p5-qdbm
 SUBDIR+=       p5-sqlrelay
diff -r c8dc1d51c1cd -r 73d30e10c946 databases/p5-pgFormatter/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/p5-pgFormatter/DESCR    Sat Nov 06 15:09:26 2021 +0000
@@ -0,0 +1,6 @@
+A PostgreSQL SQL syntax beautifier that can work as a console program or as a
+CGI.
+
+This SQL formatter/beautifier supports keywords from SQL-92, SQL-99, SQL-2003,
+SQL-2008, SQL-2011 and PostgreSQL specifics keywords. Works with any other
+databases too.
diff -r c8dc1d51c1cd -r 73d30e10c946 databases/p5-pgFormatter/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/p5-pgFormatter/Makefile Sat Nov 06 15:09:26 2021 +0000
@@ -0,0 +1,37 @@
+# $NetBSD: Makefile,v 1.1 2021/11/06 15:09:26 bsiegert Exp $
+
+GITHUB_PROJECT=        pgFormatter
+GITHUB_TAG=    v${PKGVERSION_NOREV}
+DISTNAME=      pgFormatter-5.1
+PKGNAME=       p5-${DISTNAME}
+CATEGORIES=    databases textproc perl5
+MASTER_SITES=  ${MASTER_SITE_GITHUB:=darold/}
+
+MAINTAINER=    pkgsrc-users%NetBSD.org@localhost
+HOMEPAGE=      https://github.com/darold/pgFormatter/
+COMMENT=       PostgreSQL SQL syntax beautifier
+LICENSE=       postgresql-license
+
+PERL5_PACKLIST=        auto/pgFormatter/.packlist
+USE_LANGUAGES= # none
+
+DOCDIR=                ${PREFIX}/share/doc/pgFormatter
+
+INSTALLATION_DIRS+=            ${DOCDIR}
+
+SUBST_CLASSES+=                        fix-paths
+SUBST_STAGE.fix-paths=         pre-configure
+SUBST_MESSAGE.fix-paths=       Fixing absolute paths.
+SUBST_FILES.fix-paths=         doc/pg_format.pod
+SUBST_SED.fix-paths=           -e 's,doc/pg_format.conf.sample,${DOCDIR}/pg_format.conf.sample,g'
+
+REPLACE_PERL=  pg_format
+
+post-install:
+.for doc in ChangeLog LICENSE README doc/pg_format.conf.sample
+       ${INSTALL_DATA} ${WRKSRC}/${doc} ${DESTDIR}${DOCDIR}
+.endfor
+
+
+.include "../../lang/perl5/module.mk"
+.include "../../mk/bsd.pkg.mk"
diff -r c8dc1d51c1cd -r 73d30e10c946 databases/p5-pgFormatter/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/p5-pgFormatter/PLIST    Sat Nov 06 15:09:26 2021 +0000
@@ -0,0 +1,14 @@
+@comment $NetBSD: PLIST,v 1.1 2021/11/06 15:09:26 bsiegert Exp $
+${PERL5_SUB_INSTALLVENDORARCH}/auto/pgFormatter/.packlist
+${PERL5_SUB_INSTALLVENDORLIB}/pgFormatter/Beautify.pm
+${PERL5_SUB_INSTALLVENDORLIB}/pgFormatter/CGI.pm
+${PERL5_SUB_INSTALLVENDORLIB}/pgFormatter/CLI.pm
+${PERL5_SUB_INSTALLVENDORBIN}/pg_format
+${PERL5_SUB_INSTALLVENDORMAN1DIR}/pg_format.1
+${PERL5_SUB_INSTALLVENDORMAN3DIR}/pgFormatter::Beautify.3
+${PERL5_SUB_INSTALLVENDORMAN3DIR}/pgFormatter::CGI.3
+${PERL5_SUB_INSTALLVENDORMAN3DIR}/pgFormatter::CLI.3
+share/doc/pgFormatter/ChangeLog
+share/doc/pgFormatter/LICENSE
+share/doc/pgFormatter/README
+share/doc/pgFormatter/pg_format.conf.sample
diff -r c8dc1d51c1cd -r 73d30e10c946 databases/p5-pgFormatter/distinfo
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/p5-pgFormatter/distinfo Sat Nov 06 15:09:26 2021 +0000
@@ -0,0 +1,5 @@
+$NetBSD: distinfo,v 1.1 2021/11/06 15:09:26 bsiegert Exp $
+
+BLAKE2s (pgFormatter-5.1.tar.gz) = 525812b0d47b1127c67fd377dba7bafe8f30455e443487e8b2985228fa53253a
+SHA512 (pgFormatter-5.1.tar.gz) = 86afb0e77a000145bdcfbd3d5f91c59dc8de3676b4e764a4b86147a52fd7787681b33f4e23a4e0eb9b15e9a24d5b60eb01c90574f59ff5cab2f33489c5f2e91b
+Size (pgFormatter-5.1.tar.gz) = 1314702 bytes