Initial commit of ksql-1.0 interactive SQL query tool for postgreSQL

7 files changed, 269 insertions, 0 deletions

diff --git a/databases/kpsql/Makefile b/databases/kpsql/Makefile
new file mode 100644
index 00000000000..83b36ed6af5
--- /dev/null
+++ b/databases/kpsql/Makefile
@@ -0,0 +1,26 @@
+# $NetBSD: Makefile,v 1.1.1.1 2000/10/15 14:17:39 wulf Exp $
+#
+
+DISTNAME=	kpsql-1.0
+CATEGORIES=	databases
+MASTER_SITES=	http://www.mutinybaysoftware.com/downloads/
+EXTRACT_SUFX=	.tgz
+
+MAINTAINER=	wulf@netbsd.org
+HOMEPAGE=	http://www.mutinybaysoftware.com/kpsql.html
+
+DEPENDS+=	kdebase>=1.1:../../x11/kdebase
+DEPENDS+=	postgresql>=6.4:../../databases/postgresql
+
+USE_X11BASE=	yes
+USE_GMAKE=	yes
+USE_LIBTOOL=	yes
+GNU_CONFIGURE=	yes
+
+CONFIGURE_ARGS+=--with-qt-dir=${X11BASE}/qt1 \
+		--with-pgsqldir=${LOCALBASE}
+
+CONFIGURE_ENV+=	KDEDIR=${X11BASE} \
+		MOC="${X11BASE}/qt1/bin/moc"
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/kpsql/files/md5 b/databases/kpsql/files/md5
new file mode 100644
index 00000000000..1565835053b
--- /dev/null
+++ b/databases/kpsql/files/md5
@@ -0,0 +1,3 @@
+$NetBSD: md5,v 1.1.1.1 2000/10/15 14:17:39 wulf Exp $
+
+MD5 (kpsql-1.0.tgz) = 6f88e353c7147d54ebadae1cd4578b85
diff --git a/databases/kpsql/files/patch-sum b/databases/kpsql/files/patch-sum
new file mode 100644
index 00000000000..dde59da2d66
--- /dev/null
+++ b/databases/kpsql/files/patch-sum
@@ -0,0 +1,3 @@
+$NetBSD: patch-sum,v 1.1.1.1 2000/10/15 14:17:39 wulf Exp $
+
+MD5 (patch-aa) = b96f09c1dcb77fb2786e21c1e9a0ec4d
diff --git a/databases/kpsql/patches/patch-aa b/databases/kpsql/patches/patch-aa
new file mode 100644
index 00000000000..f5c8d8fa812
--- /dev/null
+++ b/databases/kpsql/patches/patch-aa
@@ -0,0 +1,31 @@
+$NetBSD: patch-aa,v 1.1.1.1 2000/10/15 14:17:41 wulf Exp $
+
+--- configure.orig	Tue Sep 21 00:09:43 1999
++++ configure	Sun Oct 15 21:50:47 2000
+@@ -3041,7 +3041,7 @@
+ CC=$CXX
+ CFLAGS="$CXXFLAGS"
+ # Always use our own libtool.
+-LIBTOOL='$(SHELL) $(top_builddir)/libtool --silent'
++#LIBTOOL='$(SHELL) $(top_builddir)/libtool --silent'
+ 
+ # Check for any special flags to pass to ltconfig.
+ libtool_flags=
+@@ -3743,7 +3743,7 @@
+ fi
+ 
+ 
+-pgsql_incdirs="$ac_pgsql_dir/pgsql/include /usr/include/pgsql /usr/include /usr/local/include"
++pgsql_incdirs="$ac_pgsql_dir/pgsql/include /usr/include/pgsql /usr/include /usr/local/include $ac_pgsql_dir/include/pgsql"
+ 
+ pgsql_incdir=NO
+ for i in $pgsql_incdirs;
+@@ -3763,7 +3763,7 @@
+ 
+ PGSQLINC=-I$pgsql_incdir
+ 
+-pgsql_libdirs="$ac_pgsql_dir/pgsql/lib /usr/lib /usr/local/lib"
++pgsql_libdirs="$ac_pgsql_dir/pgsql/lib /usr/lib /usr/local/lib $ac_pgsql_dir/lib"
+ 
+ pgsql_libdir=NO
+ for i in $pgsql_libdirs;
diff --git a/databases/kpsql/pkg/COMMENT b/databases/kpsql/pkg/COMMENT
new file mode 100644
index 00000000000..bfca4538fb1
--- /dev/null
+++ b/databases/kpsql/pkg/COMMENT
@@ -0,0 +1 @@
+Interactive Query Tool for PostgreSQL
diff --git a/databases/kpsql/pkg/DESCR b/databases/kpsql/pkg/DESCR
new file mode 100644
index 00000000000..358970056ef
--- /dev/null
+++ b/databases/kpsql/pkg/DESCR
@@ -0,0 +1,17 @@
+KPSQL is a tool similar to Oracle's Server Manager motif worksheet and
+Microsoft's Windows based SQL Server iSQL query tool featuring:
+
+	Color syntax highlighting for the editor 
+	HTML table output for query results 
+	PostgreSQL and SQL references through online help 
+	Execute multiple SQL statements or one of many by highlighting
+	Cut/copy/paste
+	Search and replace
+	Bookmarks
+	Drag and drop support
+	Ability to cancel executing queries
+	Complete control over fonts and colors
+	Spool query output to a file
+	Spool data in fixed length, comma, tab or custom delimited format 
+	Printing
+	KDE desktop integration
diff --git a/databases/kpsql/pkg/PLIST b/databases/kpsql/pkg/PLIST
new file mode 100644
index 00000000000..14d8d11c60f
--- /dev/null
+++ b/databases/kpsql/pkg/PLIST
@@ -0,0 +1,188 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2000/10/15 14:17:41 wulf Exp $
+
+bin/kpsql
+share/doc/kde/HTML/en/kpsql/pgsql/about.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-createdb.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-createuser.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-destroydb.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-destroyuser.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-initdb.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-initlocation.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-pg-dump.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-pg-dumpall.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-pgaccess.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-pgadmin.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-postgres.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-postmaster.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-psql.htm
+share/doc/kde/HTML/en/kpsql/pgsql/app-vacuumdb.htm
+share/doc/kde/HTML/en/kpsql/pgsql/arrays.htm
+share/doc/kde/HTML/en/kpsql/pgsql/biblio.htm
+share/doc/kde/HTML/en/kpsql/pgsql/copyright.htm
+share/doc/kde/HTML/en/kpsql/pgsql/createtableas.htm
+share/doc/kde/HTML/en/kpsql/pgsql/datatype.htm
+share/doc/kde/HTML/en/kpsql/pgsql/datetime-appendix.htm
+share/doc/kde/HTML/en/kpsql/pgsql/environ.htm
+share/doc/kde/HTML/en/kpsql/pgsql/functions.htm
+share/doc/kde/HTML/en/kpsql/pgsql/index.html
+share/doc/kde/HTML/en/kpsql/pgsql/inherit.htm
+share/doc/kde/HTML/en/kpsql/pgsql/intro.htm
+share/doc/kde/HTML/en/kpsql/pgsql/keys.htm
+share/doc/kde/HTML/en/kpsql/pgsql/manage.htm
+share/doc/kde/HTML/en/kpsql/pgsql/mvcc.htm
+share/doc/kde/HTML/en/kpsql/pgsql/notation.htm
+share/doc/kde/HTML/en/kpsql/pgsql/operators.htm
+share/doc/kde/HTML/en/kpsql/pgsql/preface.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-abort.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-altertable.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-alteruser.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-beginwork.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-close.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-cluster.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-commands.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-commit.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-copy.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createaggregate.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createdatabase.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createfunction.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createindex.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createlanguage.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createoperator.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createrule.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createsequence.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createtable.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createtrigger.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createtype.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createuser.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-createview.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-declare.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-delete.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-dropaggregate.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-dropdatabase.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-dropfunction.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-dropindex.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-droplanguage.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-dropoperator.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-droprule.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-dropsequence.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-droptable.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-droptrigger.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-droptype.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-dropuser.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-dropview.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-explain.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-fetch.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-grant.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-insert.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-listen.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-load.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-lock.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-move.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-notify.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-reset.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-revoke.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-rollback.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-select.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-selectinto.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-set.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-show.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-unlisten.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-update.htm
+share/doc/kde/HTML/en/kpsql/pgsql/sql-vacuum-1.htm
+share/doc/kde/HTML/en/kpsql/pgsql/storage.htm
+share/doc/kde/HTML/en/kpsql/pgsql/syntax.htm
+share/doc/kde/HTML/en/kpsql/pgsql/terminology.htm
+share/doc/kde/HTML/en/kpsql/pgsql/typeconv.htm
+share/doc/kde/HTML/en/kpsql/pgsql/user.htm
+share/doc/kde/HTML/en/kpsql/pgsql/user.html
+share/doc/kde/HTML/en/kpsql/pgsql/utilities.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x12564.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x1361.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x1393.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x1492.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x159.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x1697.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x1768.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x1838.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x1948.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2007.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2061.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2164.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2202.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2345.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2430.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2648.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2766.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2829.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2882.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x2902.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x3039.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x3091.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x3103.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x3116.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x3193.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x3214.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x3286.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x3310.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x3351.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x420.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x56.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x684.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x710.htm
+share/doc/kde/HTML/en/kpsql/pgsql/x774.htm
+share/doc/kde/HTML/en/kpsql/pgsql/y2k.htm
+share/doc/kde/HTML/en/kpsql/images/connect.jpg
+share/doc/kde/HTML/en/kpsql/images/editorcolor.jpg
+share/doc/kde/HTML/en/kpsql/images/editorfont.jpg
+share/doc/kde/HTML/en/kpsql/images/editoropt.jpg
+share/doc/kde/HTML/en/kpsql/images/find.jpg
+share/doc/kde/HTML/en/kpsql/images/goto.jpg
+share/doc/kde/HTML/en/kpsql/images/main.jpg
+share/doc/kde/HTML/en/kpsql/images/print.jpg
+share/doc/kde/HTML/en/kpsql/images/replace.jpg
+share/doc/kde/HTML/en/kpsql/images/resultcolor.jpg
+share/doc/kde/HTML/en/kpsql/images/resultfont.jpg
+share/doc/kde/HTML/en/kpsql/images/resultopt.jpg
+share/doc/kde/HTML/en/kpsql/images/syntax.jpg
+share/doc/kde/HTML/en/kpsql/index-1.html
+share/doc/kde/HTML/en/kpsql/index-2.html
+share/doc/kde/HTML/en/kpsql/index-3.html
+share/doc/kde/HTML/en/kpsql/index-4.html
+share/doc/kde/HTML/en/kpsql/index-5.html
+share/doc/kde/HTML/en/kpsql/index-6.html
+share/doc/kde/HTML/en/kpsql/index.html
+share/doc/kde/HTML/en/kpsql/menu_edit.html
+share/doc/kde/HTML/en/kpsql/menu_file.html
+share/doc/kde/HTML/en/kpsql/menu_help.html
+share/doc/kde/HTML/en/kpsql/menu_options.html
+share/doc/kde/HTML/en/kpsql/menu_query.html
+share/doc/kde/HTML/en/kpsql/menu_view.html
+share/kde/apps/kpsql/toolbar/clear.xpm
+share/kde/apps/kpsql/toolbar/connect.xpm
+share/kde/apps/kpsql/toolbar/copy.xpm
+share/kde/apps/kpsql/toolbar/cut.xpm
+share/kde/apps/kpsql/toolbar/find.xpm
+share/kde/apps/kpsql/toolbar/go.xpm
+share/kde/apps/kpsql/toolbar/new.xpm
+share/kde/apps/kpsql/toolbar/open.xpm
+share/kde/apps/kpsql/toolbar/paste.xpm
+share/kde/apps/kpsql/toolbar/print.xpm
+share/kde/apps/kpsql/toolbar/redo.xpm
+share/kde/apps/kpsql/toolbar/save.xpm
+share/kde/apps/kpsql/toolbar/stop.xpm
+share/kde/apps/kpsql/toolbar/undo.xpm
+share/kde/apps/kpsql/toolbar/results.xpm
+share/kde/apps/kpsql/toolbar/spool.xpm
+share/kde/apps/kpsql/toolbar/bookmark.xpm
+share/kde/apps/kpsql/toolbar/indent.xpm
+share/kde/apps/kpsql/toolbar/unindent.xpm
+share/kde/applnk/Applications/kpsql.kdelnk
+share/kde/icons/kpsql.xpm
+share/kde/icons/sql.xpm
+share/kde/icons/mini/kpsql.xpm
+share/kde/mimelnk/text/x-sql.kdelnk
+@dirrm share/doc/kde/HTML/en/kpsql/pgsql
+@dirrm share/doc/kde/HTML/en/kpsql/images
+@dirrm share/doc/kde/HTML/en/kpsql
+@dirrm share/kde/apps/kpsql/toolbar
+@dirrm share/kde/apps/kpsql