Graphical query tool for PostgreSQL.

PR:		ports/8767
Submitted by:	Andrey Zakhvatov andy@icc.surw.chel.su

6 files changed, 103 insertions, 0 deletions

diff --git a/databases/gtksql/Makefile b/databases/gtksql/Makefile
new file mode 100644
index 000000000000..c48489a0bb92
--- /dev/null
+++ b/databases/gtksql/Makefile
@@ -0,0 +1,29 @@
+# New ports collection makefile for:	gtksql
+# Version required:			0.2
+# Date created:				19 November 1998
+# Whom:					Andrey Zakhvatov
+#
+# $Id$
+#
+
+DISTNAME=	gtksql-0.2
+CATEGORIES=	databases
+MASTER_SITES=	http://www.multimania.com/bbrox/GtkSQL/
+
+MAINTAINER=	andy@icc.surw.chel.su
+
+LIB_DEPENDS=	gtk10.1:${PORTSDIR}/x11-toolkits/gtk10 \
+		pq.2:${PORTSDIR}/databases/postgresql
+
+USE_X_PREFIX=	yes
+
+do-install:
+	@ ${INSTALL_PROGRAM} ${WRKSRC}/gtksql ${PREFIX}/bin
+.if !defined(NOPORTDOCS)
+	@ ${MKDIR} ${PREFIX}/share/doc/gtksql
+.for file in COPYING Changelog README
+	@ ${INSTALL_DATA} ${WRKSRC}/${file} ${PREFIX}/share/doc/gtksql
+.endfor
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/gtksql/distinfo b/databases/gtksql/distinfo
new file mode 100644
index 000000000000..a595d5eb3488
--- /dev/null
+++ b/databases/gtksql/distinfo
@@ -0,0 +1 @@
+MD5 (gtksql-0.2.tar.gz) = 74cdab5745874b5bdcef21398e95c066
diff --git a/databases/gtksql/files/patch-aa b/databases/gtksql/files/patch-aa
new file mode 100644
index 000000000000..766a6b22f479
--- /dev/null
+++ b/databases/gtksql/files/patch-aa
@@ -0,0 +1,53 @@
+--- Makefile.orig	Sat Mar 20 13:36:17 1999
++++ Makefile	Sat Mar 20 13:36:17 1999
+@@ -1,8 +1,23 @@
++#
++# C compiler
++#
++CC?= gcc
++
++#
++# Local packages
++#
++LOCALBASE?= /usr/local
++
++#
++# Installation prefix
++#
++PREFIX?= $(LOCALBASE)
++
+ # Here, what you need for Pgsql
+-PGSQLIBS    = -L/usr/local/pgsql/lib -lpq
+-PGSQLCFLAGS = -I/usr/local/pgsql/include
++PGSQLIBS    = -L$(LOCALBASE)/pgsql/lib -lpq -lcrypt
++PGSQLCFLAGS = -I$(LOCALBASE)/pgsql/include
+ # Your favorite compilation options here :-)
+-MCFLAGS  = -Wall -O -g
++CFLAGS?= -Wall -O -g
+ 
+ # The database modules you want to be built
+ DBOBJS  = postgres.o
+@@ -12,19 +27,19 @@
+ MOBJS   = main.o queries.o dialogs.o tables.o common.o export.o status.o
+ 
+ OBJS    = $(MOBJS) $(DBOBJS)
+-CFLAGS  = $(MCFLAGS) $(DBFLAGS)
++CFLAGS+=  $(DBFLAGS)
+ 
+-GTKLIBS     = `gtk-config --libs`
+-GTKCFLAGS   = `gtk-config --cflags`
++GTKLIBS     = `gtk10-config --libs`
++GTKCFLAGS   = `gtk10-config --cflags`
+ 
+ all: $(OBJS)
+-	gcc -o gtksql $(OBJS) $(PGSQLIBS) $(GTKLIBS) $(CFLAGS)
++	$(CC) -o gtksql $(OBJS) $(PGSQLIBS) $(GTKLIBS) $(CFLAGS)
+ 
+ clean:
+ 	rm *.o gtksql
+ 
+ install: all
+-	cp gtksql $(DESTDIR)usr/bin/
++	cp gtksql $(PREFIX)/bin
+ 
+ .c.o: 
diff --git a/databases/gtksql/pkg-comment b/databases/gtksql/pkg-comment
new file mode 100644
index 000000000000..4a27064b8bfc
--- /dev/null
+++ b/databases/gtksql/pkg-comment
@@ -0,0 +1 @@
+Graphical query tool for PostgreSQL.
diff --git a/databases/gtksql/pkg-descr b/databases/gtksql/pkg-descr
new file mode 100644
index 000000000000..daa42bfa92b2
--- /dev/null
+++ b/databases/gtksql/pkg-descr
@@ -0,0 +1,14 @@
+GtkSQL is a graphical query tool for PostgreSQL.  You can work on
+multiple queries simultaneously:
+
+ * send the current query to the database
+ * add a new query
+ * delete current query
+ * rename current query
+ * export current query
+ * display the table information
+ * move to the next or previous query 
+ * SQL keyword, table name and field name autocompletion
+ * rescan the table database.
+
+http://www.multimania.com/bbrox/GtkSQL/
diff --git a/databases/gtksql/pkg-plist b/databases/gtksql/pkg-plist
new file mode 100644
index 000000000000..d1a8c39e3280
--- /dev/null
+++ b/databases/gtksql/pkg-plist
@@ -0,0 +1,5 @@
+bin/gtksql
+share/doc/gtksql/COPYING
+share/doc/gtksql/Changelog
+share/doc/gtksql/README
+@dirrm share/doc/gtksql