PgWorksheet is an simple GUI frontend to Postgresql for executing SQL query and

psql commands without using the psql command line tool.

PR:		ports/78404
Submitted by:	Henri Michelon <hmichelon@e-cml.org>

5 files changed, 78 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index 2ce283f737dc..c680c1de724d 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -223,6 +223,7 @@
     SUBDIR += pgadmin3
     SUBDIR += pgbash
     SUBDIR += pgcluster
+    SUBDIR += pgworksheet
     SUBDIR += php-sqlrelay
     SUBDIR += php4-dba
     SUBDIR += php4-dbase
diff --git a/databases/pgworksheet/Makefile b/databases/pgworksheet/Makefile
new file mode 100644
index 000000000000..a0413f90c2cc
--- /dev/null
+++ b/databases/pgworksheet/Makefile
@@ -0,0 +1,35 @@
+# New ports collection makefile for:	pgworksheet
+# Date created:				03 Mar. 2005
+# Whom:					Henri Michelon
+#
+# $FreeBSD$
+#
+
+PORTNAME=	pgworksheet
+PORTVERSION=	1.7
+CATEGORIES=	databases
+MASTER_SITES=	${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	${PORTNAME}
+
+MAINTAINER=	hmichelon@e-cml.org
+COMMENT=	Simple PostreSQL GUI front end
+
+RUN_DEPENDS=	${PYTHON_SITELIBDIR}/pyPgSQL/libpq/__init__.py:${PORTSDIR}/databases/py-pyPgSQL
+
+USE_X_PREFIX=	yes
+USE_PGSQL=	yes
+USE_BZIP2=	yes
+USE_GNOME=	pygtk2
+USE_PYTHON=	yes
+USE_PYDISTUTILS=yes
+USE_REINPLACE=	yes
+
+post-patch:
+	${REINPLACE_CMD} -e \
+		's|@PIXMAP_PATH@|${PREFIX}/share/pixmaps/pgworksheet|' \
+		${WRKSRC}/pgworksheet
+	${REINPLACE_CMD} -e \
+		's|@LOCALE_PATH@|${PREFIX}/share/locale|' \
+		${WRKSRC}/pgworksheet
+
+.include <bsd.port.mk>
diff --git a/databases/pgworksheet/distinfo b/databases/pgworksheet/distinfo
new file mode 100644
index 000000000000..108fdd171827
--- /dev/null
+++ b/databases/pgworksheet/distinfo
@@ -0,0 +1,2 @@
+MD5 (pgworksheet-1.7.tar.bz2) = 54f1166887fcaca649a6509d23b1b2d7
+SIZE (pgworksheet-1.7.tar.bz2) = 82330
diff --git a/databases/pgworksheet/pkg-descr b/databases/pgworksheet/pkg-descr
new file mode 100644
index 000000000000..2208abadc204
--- /dev/null
+++ b/databases/pgworksheet/pkg-descr
@@ -0,0 +1,7 @@
+PgWorksheet is a simple GUI frontend to PostgreSQL for executing 
+SQL queries and psql commands without using the psql command line tool.
+
+WWW: http://pgworksheet.projects.postgresql.org/
+developed by Henri Michelon
+
+- Henri Michelon <hmichelon at e-cml.org>
diff --git a/databases/pgworksheet/pkg-plist b/databases/pgworksheet/pkg-plist
new file mode 100644
index 000000000000..e429d4c26cea
--- /dev/null
+++ b/databases/pgworksheet/pkg-plist
@@ -0,0 +1,33 @@
+bin/pgworksheet
+%%PYTHON_SITELIBDIR%%/pgw/__init__.py
+%%PYTHON_SITELIBDIR%%/pgw/__init__.pyc
+%%PYTHON_SITELIBDIR%%/pgw/__init__.pyo
+%%PYTHON_SITELIBDIR%%/pgw/DBConnection.py
+%%PYTHON_SITELIBDIR%%/pgw/DBConnection.pyc
+%%PYTHON_SITELIBDIR%%/pgw/DBConnection.pyo
+%%PYTHON_SITELIBDIR%%/pgw/Execute.py
+%%PYTHON_SITELIBDIR%%/pgw/Execute.pyc
+%%PYTHON_SITELIBDIR%%/pgw/Execute.pyo
+%%PYTHON_SITELIBDIR%%/pgw/RunSQL.py
+%%PYTHON_SITELIBDIR%%/pgw/RunSQL.pyc
+%%PYTHON_SITELIBDIR%%/pgw/RunSQL.pyo
+%%PYTHON_SITELIBDIR%%/pgw/UI.py
+%%PYTHON_SITELIBDIR%%/pgw/UI.pyc
+%%PYTHON_SITELIBDIR%%/pgw/UI.pyo
+%%PYTHON_SITELIBDIR%%/pgw/MyPgSQL.py
+%%PYTHON_SITELIBDIR%%/pgw/MyPgSQL.pyc
+%%PYTHON_SITELIBDIR%%/pgw/MyPgSQL.pyo
+share/pixmaps/pgworksheet/connect.png
+share/pixmaps/pgworksheet/disconnect.png
+share/pixmaps/pgworksheet/about.png
+share/pixmaps/pgworksheet/pgworksheet.png
+share/pixmaps/pgworksheet/pgworksheet-32.png
+share/locale/fr/LC_MESSAGES/pgworksheet.mo
+@dirrm %%PYTHON_SITELIBDIR%%/pgw
+@unexec rmdir %D/%%PYTHON_SITELIBDIR%% 2> /dev/null || true
+@unexec rmdir %D/%%PYTHON_LIBDIR%% 2> /dev/null || true
+@dirrm share/pixmaps/pgworksheet
+@unexec rmdir %D/share/pixmaps 2>/dev/null || true
+@unexec rmdir %D/share/locale/fr/LC_MESSAGES 2>/dev/null || true
+@unexec rmdir %D/share/locale/fr 2>/dev/null || true
+@unexec rmdir %D/share/locale 2>/dev/null || true