1{ lib
2, python
3, fetchPypi
4, buildPythonPackage
5, postgresql
6, unittestCheckHook
7}:
8
9buildPythonPackage rec {
10 pname = "pgsanity";
11 version = "0.2.9";
12
13 src = fetchPypi {
14 inherit pname version;
15 sha256 = "de0bbd6fe4f98bf5139cb5f466eac2e2abaf5a7b050b9e4867b87bf360873173";
16 };
17
18 nativeCheckInputs = [ unittestCheckHook postgresql ];
19 propagatedBuildInputs = [ postgresql ];
20
21 meta = with lib; {
22 homepage = "https://github.com/markdrago/pgsanity";
23 description = "Checks the syntax of Postgresql SQL files";
24 longDescription = ''
25 PgSanity checks the syntax of Postgresql SQL files by
26 taking a file that has a list of bare SQL in it,
27 making that file look like a C file with embedded SQL,
28 run it through ecpg and
29 let ecpg report on the syntax errors of the SQL.
30 '';
31 license = licenses.mit;
32 maintainers = with maintainers; [ nalbyuites ];
33 };
34}