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