diff options
author | sunpoet <sunpoet@FreeBSD.org> | 2019-04-19 01:59:43 +0800 |
---|---|---|
committer | Koop Mast <koop@beyonit.nl> | 2019-04-23 03:02:14 +0800 |
commit | 0f1a22038c68d0b7227eac13b6ffebbb774d90fd (patch) | |
tree | 9037fce9f8cd4ce583d5f6353ae817e7b064590e /databases | |
parent | 6e14b624bed5ce09bfde83a07c9fbdab173c677f (diff) | |
download | freebsd-ports-gnome-0f1a22038c68d0b7227eac13b6ffebbb774d90fd.tar.gz freebsd-ports-gnome-0f1a22038c68d0b7227eac13b6ffebbb774d90fd.tar.zst freebsd-ports-gnome-0f1a22038c68d0b7227eac13b6ffebbb774d90fd.zip |
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
Diffstat (limited to 'databases')
-rw-r--r-- | databases/plpgsql_check/Makefile | 22 | ||||
-rw-r--r-- | databases/plpgsql_check/distinfo | 6 | ||||
-rw-r--r-- | databases/plpgsql_check/pkg-descr | 21 | ||||
-rw-r--r-- | databases/plpgsql_check/pkg-plist | 6 |
4 files changed, 28 insertions, 27 deletions
diff --git a/databases/plpgsql_check/Makefile b/databases/plpgsql_check/Makefile index 4f5cd307a4a6..dc60b3e0549a 100644 --- a/databases/plpgsql_check/Makefile +++ b/databases/plpgsql_check/Makefile @@ -2,33 +2,27 @@ # $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 diff --git a/databases/plpgsql_check/distinfo b/databases/plpgsql_check/distinfo index 63d64ed1eb27..7619a92a7419 100644 --- a/databases/plpgsql_check/distinfo +++ b/databases/plpgsql_check/distinfo @@ -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 diff --git a/databases/plpgsql_check/pkg-descr b/databases/plpgsql_check/pkg-descr index bd28ddfbee08..52181a5ebc4a 100644 --- a/databases/plpgsql_check/pkg-descr +++ b/databases/plpgsql_check/pkg-descr @@ -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 diff --git a/databases/plpgsql_check/pkg-plist b/databases/plpgsql_check/pkg-plist index 87ecece9a70d..4cb00e864354 100644 --- a/databases/plpgsql_check/pkg-plist +++ b/databases/plpgsql_check/pkg-plist @@ -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 |