svn commit: r499285 - head/databases/plpgsql_check

[Sunpoet Po-Chuan Hsieh]

Author: sunpoet
Date: Thu Apr 18 17:59:43 2019
New Revision: 499285
URL: https://svnweb.freebsd.org/changeset/ports/499285

Log:
  Update to 1.7.0
  
  - Use PGSQL_VER_NODOT
  - Add LICENSE_FILE
  - Update pkg-descr
  - Take maintainership
  
  Changes:	https://github.com/okbob/plpgsql_check/releases

Modified:
  head/databases/plpgsql_check/Makefile
  head/databases/plpgsql_check/distinfo   (contents, props changed)
  head/databases/plpgsql_check/pkg-descr   (contents, props changed)
  head/databases/plpgsql_check/pkg-plist   (contents, props changed)

Modified: head/databases/plpgsql_check/Makefile
==============================================================================
--- head/databases/plpgsql_check/Makefile	Thu Apr 18 17:59:37 2019	(r499284)
+++ head/databases/plpgsql_check/Makefile	Thu Apr 18 17:59:43 2019	(r499285)
@@ -2,32 +2,26 @@
 # $FreeBSD$
 
 PORTNAME=	plpgsql_check
-PORTVERSION=	1.2.0
+PORTVERSION=	1.7.0
 DISTVERSIONPREFIX=	v
-PORTREVISION=	2
 CATEGORIES=	databases
-PKGNAMEPREFIX=	postgresql${PGSQL_VER:S/.//}-
+PKGNAMEPREFIX=	postgresql${PGSQL_VER_NODOT}-
 
-MAINTAINER=	ports at FreeBSD.org
+MAINTAINER=	sunpoet at FreeBSD.org
 COMMENT=	PostgreSQL extension to check PL/pgSQL code
 
 LICENSE=	UNKNOWN
 LICENSE_NAME=	postcardware
-LICENSE_TEXT=	If you like it - send a postcard to address: \
-			Pavel Stehule \
-			Skalice 12 \
-			Benesov u Prahy \
-			256 01 \
-			Czech Republic \
-		Use this code freely on own risk
+LICENSE_FILE=	${WRKSRC}/LICENSE
 LICENSE_PERMS=	dist-mirror pkg-mirror dist-sell pkg-sell auto-accept
 
-USES=		gmake pgsql:9.2+
+USES=		gmake pgsql
+
 LLD_UNSAFE=	yes
+WANT_PGSQL=	server
+
 USE_GITHUB=	yes
 GH_ACCOUNT=	okbob
-
-WANT_PGSQL=	server
 
 post-install:
 	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/plpgsql_check.so

Modified: head/databases/plpgsql_check/distinfo
==============================================================================
--- head/databases/plpgsql_check/distinfo	Thu Apr 18 17:59:37 2019	(r499284)
+++ head/databases/plpgsql_check/distinfo	Thu Apr 18 17:59:43 2019	(r499285)
@@ -1,3 +1,3 @@
-TIMESTAMP = 1496223426
-SHA256 (okbob-plpgsql_check-v1.2.0_GH0.tar.gz) = 370be67e557e91936f05c3697629ce45f1a7855d668359dc147d7fbf125dfcf5
-SIZE (okbob-plpgsql_check-v1.2.0_GH0.tar.gz) = 62269
+TIMESTAMP = 1555592218
+SHA256 (okbob-plpgsql_check-v1.7.0_GH0.tar.gz) = 191004174ec25dc06937fa1c92f4bd8762fe9a3e96ef7acfabd169482d36b4ab
+SIZE (okbob-plpgsql_check-v1.7.0_GH0.tar.gz) = 154818

Modified: head/databases/plpgsql_check/pkg-descr
==============================================================================
--- head/databases/plpgsql_check/pkg-descr	Thu Apr 18 17:59:37 2019	(r499284)
+++ head/databases/plpgsql_check/pkg-descr	Thu Apr 18 17:59:43 2019	(r499285)
@@ -1,7 +1,18 @@
-Plpgsql_check is next generation of plpgsql_lint. It allows to check source
-code by explicit call plpgsql_check_function. The SQL statements inside
-PL/pgSQL functions are checked by validator for semantic errors. These errors
-can be found by plpgsql_check_function. PostgreSQL 9.2 is required, PostgreSQL
-9.3, 9.4, 9.5, 9.6 and 10 are supported.
+plpgsql_check is next generation of plpgsql_lint. It allows to check source code
+by explicit call plpgsql_check_function. PostgreSQL 9.4, 9.5, 9.6, 10, 11 are
+supported (Develop 12 is supported too). The SQL statements inside PL/pgSQL
+functions are checked by validator for semantic errors. These errors can be
+found by plpgsql_check_function.
+
+Features:
+- check fields of referenced database objects and types inside embedded SQL
+- using correct types of function parameters
+- unused variables and function argumens, unmodified OUT argumens
+- partially detection of dead code (due RETURN command)
+- detection of missing RETURN command in function
+- try to identify unwanted hidden casts, that can be performance issue like
+  unused indexes
+- possibility to collect relations and functions used by function
+- possibility to check EXECUTE stmt agaist SQL injection vulnerability
 
 WWW: https://github.com/okbob/plpgsql_check

Modified: head/databases/plpgsql_check/pkg-plist
==============================================================================
--- head/databases/plpgsql_check/pkg-plist	Thu Apr 18 17:59:37 2019	(r499284)
+++ head/databases/plpgsql_check/pkg-plist	Thu Apr 18 17:59:43 2019	(r499285)
@@ -1,7 +1,3 @@
 lib/postgresql/plpgsql_check.so
-share/postgresql/extension/plpgsql_check--1.0--1.1.sql
-share/postgresql/extension/plpgsql_check--1.0.sql
-share/postgresql/extension/plpgsql_check--1.1--1.2.sql
-share/postgresql/extension/plpgsql_check--1.1.sql
-share/postgresql/extension/plpgsql_check--1.2.sql
+share/postgresql/extension/plpgsql_check--1.7.sql
 share/postgresql/extension/plpgsql_check.control