notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Ukraine
Port details
pgsanity Check syntax of PostgreSQL SQL files
0.2.9_3 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 0.2.9_3Version of this port present on the latest quarterly branch.
Maintainer: 0mp@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2018-03-18 12:31:40
Last Update: 2021-04-07 08:09:01
Commit Hash: cf118cc
Also Listed In: python
License: MIT
Description:
SVNWeb : git : Homepage
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}pgsanity>0:databases/pgsanity@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/pgsanity/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pgsanity
  • pkg install py38-pgsanity
NOTE: This is a Python port. Instead of py38-pgsanity listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py38-pgsanity
Package flavors (<flavor>: <package>)
  • py38: py38-pgsanity
distinfo:
Packages (timestamps in pop-ups are UTC):
py27-pgsanity
ABIlatestquarterly
FreeBSD:11:aarch640.2.90.2.9_3
FreeBSD:11:amd64--
FreeBSD:11:armv6-0.2.9_3
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64-0.2.9_3
FreeBSD:12:aarch640.2.9-
FreeBSD:12:amd64--
FreeBSD:12:armv60.2.90.2.9_3
FreeBSD:12:armv70.2.90.2.9_3
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips640.2.90.2.9_3
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
py36-pgsanity
ABIlatestquarterly
FreeBSD:11:aarch640.2.9-
FreeBSD:11:amd64--
FreeBSD:11:armv6--
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch640.2.9-
FreeBSD:12:amd64--
FreeBSD:12:armv60.2.9-
FreeBSD:12:armv70.2.9-
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips640.2.9-
FreeBSD:12:powerpc64--
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv6--
FreeBSD:13:armv7--
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64--
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 
py37-pgsanity
ABIlatestquarterly
FreeBSD:11:aarch64-0.2.9_3
FreeBSD:11:amd64--
FreeBSD:11:armv6-0.2.9_3
FreeBSD:11:i386--
FreeBSD:11:mips--
FreeBSD:11:mips64-0.2.9_3
FreeBSD:12:aarch64--
FreeBSD:12:amd64--
FreeBSD:12:armv6-0.2.9_3
FreeBSD:12:armv7-0.2.9_3
FreeBSD:12:i386--
FreeBSD:12:mips--
FreeBSD:12:mips64-0.2.9_3
FreeBSD:12:powerpc64-0.2.9_3
FreeBSD:13:aarch64--
FreeBSD:13:amd64--
FreeBSD:13:armv60.2.9_3-
FreeBSD:13:armv70.2.9_3-
FreeBSD:13:i386--
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc640.2.9_3-
FreeBSD:14:aarch64--
FreeBSD:14:amd64--
FreeBSD:14:armv6--
FreeBSD:14:armv7--
FreeBSD:14:i386--
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc640.2.9_3-
 
py38-pgsanity
ABIlatestquarterly
FreeBSD:11:aarch64--
FreeBSD:11:amd640.2.9_30.2.9_3
FreeBSD:11:armv6--
FreeBSD:11:i3860.2.9_30.2.9_3
FreeBSD:11:mips--
FreeBSD:11:mips64--
FreeBSD:12:aarch64-0.2.9_3
FreeBSD:12:amd640.2.9_30.2.9_3
FreeBSD:12:armv6--
FreeBSD:12:armv7--
FreeBSD:12:i3860.2.9_30.2.9_3
FreeBSD:12:mips--
FreeBSD:12:mips64--
FreeBSD:12:powerpc64--
FreeBSD:13:aarch640.2.9_30.2.9_3
FreeBSD:13:amd640.2.9_30.2.9_3
FreeBSD:13:armv6-0.2.9_3
FreeBSD:13:armv7-0.2.9_3
FreeBSD:13:i3860.2.9_30.2.9_3
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc64-0.2.9_3
FreeBSD:14:aarch640.2.9_3-
FreeBSD:14:amd640.2.9_3-
FreeBSD:14:armv60.2.9_3-
FreeBSD:14:armv70.2.9_3-
FreeBSD:14:i3860.2.9_3-
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc64--
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py38-setuptools>0 : devel/py-setuptools@py38
  2. python3.8 : lang/python38
Runtime dependencies:
  1. py38-setuptools>0 : devel/py-setuptools@py38
  2. python3.8 : lang/python38
Library dependencies:
  1. libpq.so.5 : databases/postgresql12-client
There are no ports dependent upon this port

Configuration Options:
Options name:

USES:

FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/markdrago/pgsanity/tar.gz/v0.2.9?dummy=/
Collapse this list.

Number of commits found: 8

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
07 Apr 2021 08:09:01
 files touched by this commit commit hash:cf118ccf875508b9a1c570044c93cfcc82bd455c  0.2.9_3
Mathieu Arnold (mat) search for other commits by this committer
One more small cleanup, forgotten yesterday.
Reported by:	lwhsu
06 Apr 2021 14:31:07
 files touched by this commit commit hash:305f148f482daf30dcf728039d03d019f88344eb  0.2.9_3
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
28 Dec 2020 23:02:15
Original commit files touched by this commit Revision:559531  0.2.9_3
antoine search for other commits by this committer
Drop python 2.7 support from a few ports

With hat:	portmgr
26 Jul 2019 20:46:57
Original commit files touched by this commit Revision:507372  0.2.9_3
gerald search for other commits by this committer
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
10 Apr 2019 06:18:32
Original commit files touched by this commit Revision:498530  0.2.9_2
antoine search for other commits by this committer
Bump a few PORTREVISIONs after r498529

With hat:	portmgr
12 Dec 2018 01:35:36
Original commit files touched by this commit Revision:487272  0.2.9_1
gerald search for other commits by this committer
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
20 Mar 2018 23:22:30
Original commit files touched by this commit Revision:465138  0.2.9
dbaio search for other commits by this committer
databases/pgsanity: Update to 0.2.9

PR:		226730
Submitted by:	Mateusz Piotrowski <0mp@FreeBSD.org> (maintainer)
18 Mar 2018 12:31:13
Original commit files touched by this commit Revision:464904  0.2.8.16
tobik search for other commits by this committer
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

Number of commits found: 8