From owner-svn-ports-head@freebsd.org Thu Apr 18 17:59:45 2019 Return-Path: Delivered-To: svn-ports-head@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 1EFA61577C71; Thu, 18 Apr 2019 17:59:45 +0000 (UTC) (envelope-from sunpoet@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) server-signature RSA-PSS (4096 bits) client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id A92EE711C8; Thu, 18 Apr 2019 17:59:44 +0000 (UTC) (envelope-from sunpoet@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 41B8422788; Thu, 18 Apr 2019 17:59:44 +0000 (UTC) (envelope-from sunpoet@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id x3IHxikS080653; Thu, 18 Apr 2019 17:59:44 GMT (envelope-from sunpoet@FreeBSD.org) Received: (from sunpoet@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id x3IHxhd3080649; Thu, 18 Apr 2019 17:59:43 GMT (envelope-from sunpoet@FreeBSD.org) Message-Id: <201904181759.x3IHxhd3080649@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: sunpoet set sender to sunpoet@FreeBSD.org using -f From: Sunpoet Po-Chuan Hsieh Date: Thu, 18 Apr 2019 17:59:43 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r499285 - head/databases/plpgsql_check X-SVN-Group: ports-head X-SVN-Commit-Author: sunpoet X-SVN-Commit-Paths: head/databases/plpgsql_check X-SVN-Commit-Revision: 499285 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Rspamd-Queue-Id: A92EE711C8 X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org X-Spamd-Result: default: False [-2.98 / 15.00]; local_wl_from(0.00)[FreeBSD.org]; NEURAL_HAM_MEDIUM(-1.00)[-0.999,0]; NEURAL_HAM_SHORT(-0.98)[-0.978,0]; ASN(0.00)[asn:11403, ipnet:2610:1c1:1::/48, country:US]; NEURAL_HAM_LONG(-1.00)[-1.000,0] X-BeenThere: svn-ports-head@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: SVN commit messages for the ports tree for head List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 18 Apr 2019 17:59:45 -0000 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