Port details on branch 2022Q2 |
- 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: 2023-06-27 19:34:34
- Commit Hash: 3d9a815
- Also Listed In: python
- License: MIT
- WWW:
- https://github.com/markdrago/pgsanity
- 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.
- ¦ ¦ ¦ ¦
- Manual pages:
- FreshPorts has no man page information for this port.
- 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 py39-pgsanity
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above. NOTE: This is a Python port. Instead of py39-pgsanity listed in the above command, you can pick from the names under the Packages section.- PKGNAME: py39-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:
-
- py39-setuptools>=63.1.0 : devel/py-setuptools@py39
- python3.9 : lang/python39
- Test dependencies:
-
- python3.9 : lang/python39
- Runtime dependencies:
-
- py39-setuptools>=63.1.0 : devel/py-setuptools@py39
- python3.9 : lang/python39
- Library dependencies:
-
- libpq.so.5 : databases/postgresql13-client
- There are no ports dependent upon this port
Configuration Options:
- ===> The following configuration options are available for py39-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
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|