pgsanity Check syntax of PostgreSQL SQL files

0.2.9_3 databases =0 0.2.9Version of this port present on the latest quarterly branch.

Maintainer: 0mp@FreeBSD.org

Port Added: 2018-03-18 12:31:40

Last Update: 2019-07-26 21:46:57

SVN Revision: 507372

Also Listed In: python

License: MIT

Description:

PgSanity checks the syntax of PostgreSQL SQL files. It does this by leveraging the ecpg command which is traditionally used for preparing C files with embedded SQL for compilation. However, as part of that preparation, ecpg checks the embedded SQL statements for syntax errors using the exact same parser that is in PostgreSQL. So the approach that PgSanity takes is to take a file that has a list of bare SQL in it, make that file look like a C file with embedded SQL, run it through ecpg and let ecpg report on the syntax errors of the SQL. WWW: https://github.com/markdrago/pgsanity

SVNWeb : Homepage

There is no configure plist information for this port.

Dependency lines:

• py36-pgsanity>0:databases/pgsanity

To install the port: cd /usr/ports/databases/pgsanity/ && make install clean

To add the package: pkg install py36-pgsanity

PKGNAME: py36-pgsanity

Package flavors (<flavor>: <package>)

• py36: py36-pgsanity
• py27: py27-pgsanity

distinfo:

TIMESTAMP = 1521583107 SHA256 (markdrago-pgsanity-v0.2.9_GH0.tar.gz) = 486c7289dc4b361c0cd87a428abdce31d8bc6342891282c8c8dd73e917464b2c SIZE (markdrago-pgsanity-v0.2.9_GH0.tar.gz) = 7786

Dependencies

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:

1. py36-setuptools>0 : devel/py-setuptools@py36
2. python3.6 : lang/python36

Runtime dependencies:

1. py36-setuptools>0 : devel/py-setuptools@py36
2. python3.6 : lang/python36

Library dependencies:

1. libpq.so.5 : databases/postgresql95-client

There are no ports dependent upon this port

Configuration Options

===> The following configuration options are available for py36-pgsanity-0.2.9_3: DOCS=on: Build and/or install documentation ===> Use 'make config' to modify these settings

USES:

pgsql python

Master Sites:

1. https://codeload.github.com/markdrago/pgsanity/tar.gz/v0.2.9?dummy=/

Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.

PR:		238330

Bump a few PORTREVISIONs after r498529

With hat:	portmgr

Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.

This includes ports
 - with USE_GCC=yes or USE_GCC=any,
 - with USES=fortran,
 - using Mk/bsd.octave.mk which in turn features USES=fortran, and
 - with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
   c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.

PR:		231590

databases/pgsanity: Update to 0.2.9

PR:		226730
Submitted by:	Mateusz Piotrowski <0mp@FreeBSD.org> (maintainer)

New port: databases/pgsanity

PgSanity checks the syntax of PostgreSQL SQL files.

It does this by leveraging the ecpg command which is traditionally
used for preparing C files with embedded SQL for compilation.
However, as part of that preparation, ecpg checks the embedded SQL
statements for syntax errors using the exact same parser that is in
PostgreSQL.

So the approach that PgSanity takes is to take a file that has a list
of bare SQL in it, make that file look like a C file with embedded
SQL, run it through ecpg and let ecpg report on the syntax errors of
the SQL.

WWW: https://github.com/markdrago/pgsanity

PR:		226689
Submitted by:	0mp

13 vulnerabilities affecting 93 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities

Last updated:
2019-08-17 12:08:00