MFH: r469614 databases/py-pyPgSQL: Unmark BROKEN, Update MAINTAINER

This port was marked BROKEN/DEPRECATED due to a corrupt patch file. Update the
patch source to fix the issue.  Update MAINTAINER at submitters request.

While here, level up ports / python port compliance:

- Strip shared libraries
- Use option helpers
- Use python autoplist
- Match upstream setup.py metadata (COMMENT)
- Use explicit/canonical python package dependencies
- Unmute INSTALL_* commands

PR:		228119
Submitted by:	Chris Hutchinson <portmaster bsdforge com>
Approved by:	koobs (python, maintainer)

Approved by:	ports-secteam (riggs)

3 files changed, 15 insertions, 29 deletions

diff --git a/databases/py-pyPgSQL/Makefile b/databases/py-pyPgSQL/Makefile
index e9dfdf20ee1c..10680ea58713 100644
--- a/databases/py-pyPgSQL/Makefile
+++ b/databases/py-pyPgSQL/Makefile
@@ -3,48 +3,45 @@
 
 PORTNAME=	pyPgSQL
 PORTVERSION=	2.5.1
-PORTREVISION=	4
+PORTREVISION=	5
 CATEGORIES=	databases python
 MASTER_SITES=	SF
 PKGNAMEPREFIX=	${PYTHON_PKGNAMEPREFIX}
 
-MAINTAINER=	python@FreeBSD.org
-COMMENT=	Python DB-API 2 compliant library for using PostgreSQL databases
+MAINTAINER=	portmaster@BSDforge.com
+COMMENT=	Python DB-API 2.0 compliant interface to PostgreSQL
 
-BROKEN=		Invalid checksum
+LICENSE=	BSD2CLAUSE
 
-RUN_DEPENDS=	${DATETIME_DEP}:lang/py-mx-base
+RUN_DEPENDS=	${PYTHON_PKGNAMEPREFIX}mx-base>0:lang/py-mx-base
 
-USES=	pgsql python:2.7
-USE_PYTHON=	distutils
+USES=		pgsql python:2.7
+USE_PYTHON=	distutils autoplist
 
 DOCS=		Announce ChangeLog README README.html
 EXAMPLES=	examples/*.py
 
-DATETIME_DEP=	${PYTHON_SITELIBDIR}/mx/DateTime/__init__.py
-
-OPTIONS_DEFINE=	BYTEA_CONN EXAMPLES DOCS
+OPTIONS_DEFINE=		BYTEA_CONN EXAMPLES DOCS
 OPTIONS_DEFAULT=	BYTEA_CONN
+
 BYTEA_CONN_DESC=	Apply Bytea connection patch
+BYTEA_CONN_VARS=	PATCH_SITES=	https://sourceforge.net/p/pypgsql/patches/_discuss/thread/c9fcb468/43b1/attachment/ \
+			PATCHFILES=	patch-byteaconn
 
 .include <bsd.port.options.mk>
 
-.if ${PORT_OPTIONS:MBYTEA_CONN}
-PATCH_SITES=	http://sourceforge.net/tracker/download.php?group_id=16528&atid=316528&file_id=273956&aid=1939119/
-PATCHFILES=	pyPgSQL-patch_byteaconn
-.endif
-
 DOCSDIR=	${PREFIX}/share/doc/py-pyPgSQL
 EXAMPLESDIR=	${PREFIX}/share/examples/py-pyPgSQL
 
 post-install:
+	${STRIP_CMD} ${STAGEDIR}${PYTHONPREFIX_SITELIBDIR}/pyPgSQL/libpq/libpqmodule.so
 	@${MKDIR} ${STAGEDIR}${DOCSDIR}
 .for f in ${DOCS}
-	@${INSTALL_DATA} ${WRKSRC}/${f} ${STAGEDIR}${DOCSDIR}
+	${INSTALL_DATA} ${WRKSRC}/${f} ${STAGEDIR}${DOCSDIR}
 .endfor
 	@${MKDIR} ${STAGEDIR}${EXAMPLESDIR}
 .for f in ${EXAMPLES}
-	@${INSTALL_DATA} ${WRKSRC}/${f} ${STAGEDIR}${EXAMPLESDIR}
+	${INSTALL_DATA} ${WRKSRC}/${f} ${STAGEDIR}${EXAMPLESDIR}
 .endfor
 
 .include <bsd.port.mk>
diff --git a/databases/py-pyPgSQL/distinfo b/databases/py-pyPgSQL/distinfo
index 4489dfa17264..9bdaf5d7e208 100644
--- a/databases/py-pyPgSQL/distinfo
+++ b/databases/py-pyPgSQL/distinfo
@@ -1,4 +1,3 @@
+TIMESTAMP = 1526023581
 SHA256 (pyPgSQL-2.5.1.tar.gz) = 498486f066f11a68f5b02a54ba5a008d01d507038c873bfd901c14d3f5ca18af
 SIZE (pyPgSQL-2.5.1.tar.gz) = 152840
-SHA256 (pyPgSQL-patch_byteaconn) = 73a324808aef49382e736245023eb8c468e1ca0803052a2a45162465b0ad28d7
-SIZE (pyPgSQL-patch_byteaconn) = 4718
diff --git a/databases/py-pyPgSQL/pkg-plist b/databases/py-pyPgSQL/pkg-plist
index ac49a0f64bed..b3bfabe7dbd9 100644
--- a/databases/py-pyPgSQL/pkg-plist
+++ b/databases/py-pyPgSQL/pkg-plist
@@ -1,13 +1,3 @@
-%%PYTHON_SITELIBDIR%%/pyPgSQL/__init__.py
-%%PYTHON_SITELIBDIR%%/pyPgSQL/__init__.pyc
-%%PYTHON_SITELIBDIR%%/pyPgSQL/__init__.pyo
-%%PYTHON_SITELIBDIR%%/pyPgSQL/PgSQL.py
-%%PYTHON_SITELIBDIR%%/pyPgSQL/PgSQL.pyc
-%%PYTHON_SITELIBDIR%%/pyPgSQL/PgSQL.pyo
-%%PYTHON_SITELIBDIR%%/pyPgSQL/libpq/__init__.py
-%%PYTHON_SITELIBDIR%%/pyPgSQL/libpq/__init__.pyc
-%%PYTHON_SITELIBDIR%%/pyPgSQL/libpq/__init__.pyo
-%%PYTHON_SITELIBDIR%%/pyPgSQL/libpq/libpqmodule.so
 %%PORTDOCS%%%%DOCSDIR%%/Announce
 %%PORTDOCS%%%%DOCSDIR%%/ChangeLog
 %%PORTDOCS%%%%DOCSDIR%%/README