| Port details |
- pgsanity Check syntax of PostgreSQL SQL files
- 0.2.9_3 databases
 =0      0.2.9_3Version of this port present on the latest quarterly branch. - Maintainer: 0mp@FreeBSD.org
- 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:
- 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 : 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>)
- distinfo:
- TIMESTAMP = 1521583107
SHA256 (markdrago-pgsanity-v0.2.9_GH0.tar.gz) = 486c7289dc4b361c0cd87a428abdce31d8bc6342891282c8c8dd73e917464b2c
SIZE (markdrago-pgsanity-v0.2.9_GH0.tar.gz) = 7786
- Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- py38-setuptools>0 : devel/py-setuptools@py38
- python3.8 : lang/python38
- Runtime dependencies:
-
- py38-setuptools>0 : devel/py-setuptools@py38
- python3.8 : lang/python38
- Library dependencies:
-
- libpq.so.5 : databases/postgresql12-client
- There are no ports dependent upon this port
- Configuration Options:
- ===> The following configuration options are available for py38-pgsanity-0.2.9_3:
DOCS=on: Build and/or install documentation
===> Use 'make config' to modify these settings
- Options name:
- databases_pgsanity
- USES:
- pgsql python:3.6+
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
Number of commits found: 8
| Commit History - (may be incomplete: see SVNWeb link above for full details) |
| Date | By | Description |
|---|
07 Apr 2021 08:09:01
  0.2.9_3
|
Mathieu Arnold (mat) |
One more small cleanup, forgotten yesterday.
Reported by: lwhsu |
06 Apr 2021 14:31:07
0.2.9_3
|
Mathieu Arnold (mat) |
Remove # $FreeBSD$ from Makefiles. |
28 Dec 2020 23:02:15
  0.2.9_3
|
antoine |
Drop python 2.7 support from a few ports
With hat: portmgr |
26 Jul 2019 20:46:57
0.2.9_3
|
gerald |
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
0.2.9_2
|
antoine |
Bump a few PORTREVISIONs after r498529
With hat: portmgr |
12 Dec 2018 01:35:36
0.2.9_1
|
gerald |
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
0.2.9
|
dbaio |
databases/pgsanity: Update to 0.2.9
PR: 226730
Submitted by: Mateusz Piotrowski <0mp@FreeBSD.org> (maintainer) |
18 Mar 2018 12:31:13
0.2.8.16
|
tobik |
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
|
As an Amazon Associate I earn from qualifying purchases.