Date: Thu, 18 Apr 2019 17:59:43 +0000 (UTC) From: Sunpoet Po-Chuan Hsieh <sunpoet@FreeBSD.org> To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r499285 - head/databases/plpgsql_check Message-ID: <201904181759.x3IHxhd3080649@repo.freebsd.org>
next in thread | raw e-mail | index | archive | help
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@FreeBSD.org +MAINTAINER= sunpoet@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201904181759.x3IHxhd3080649>