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}