Add yasql 1.82, yet Another SQL*Plus Replacement.

Successfully used to access Oracle 7 and Oracle 8i databases, but fails
with Oracle 9i (ORA-03113 "end-of-file on communication channel").

4 files changed, 98 insertions, 0 deletions

diff --git a/databases/yasql/Makefile b/databases/yasql/Makefile
new file mode 100644
index 000000000000..4d90c87e6ee4
--- /dev/null
+++ b/databases/yasql/Makefile
@@ -0,0 +1,81 @@
+# New ports collection makefile for:	yasql
+# Date created:				22 February 2005
+# Whom:	      				Thierry Thomas <thierry@pompo.net>
+#
+# $FreeBSD$
+#
+
+PORTNAME=		yasql
+PORTVERSION=		1.82
+CATEGORIES=		databases
+MASTER_SITES=		${MASTER_SITE_SOURCEFORGE}
+MASTER_SITE_SUBDIR=	${PORTNAME}
+
+MAINTAINER=		thierry@FreeBSD.org
+COMMENT=		Yet Another SQL*Plus Replacement
+
+BUILD_DEPENDS=	${SITE_PERL}/${PERL_ARCH}/DBD/Oracle.pm:${PORTSDIR}/databases/p5-DBD-Oracle	\
+		${SITE_PERL}/${PERL_ARCH}/Term/ReadLine/Gnu.pm:${PORTSDIR}/devel/p5-Term-ReadLine-Gnu
+RUN_DEPENDS=	${BUILD_DEPENDS}
+
+# Time::HiRes is used for high resolution benchmarking
+.if !defined(WITHOUT_HIRES)
+BUILD_DEPENDS+=	${SITE_PERL}/${PERL_ARCH}/Time/HiRes.pm:${PORTSDIR}/devel/p5-Time-HiRes
+.endif
+
+# Text::CSV_XS is required to output CSV or input from CSV files
+.if !defined(WITHOUT_CSV)
+BUILD_DEPENDS+=	${SITE_PERL}/${PERL_ARCH}/Text/CSV_XS.pm:${PORTSDIR}/textproc/p5-Text-CSV_XS
+.endif
+
+# Term::ReadKey is used for better input and output control
+.if !defined(WITHOUT_READKEY)
+BUILD_DEPENDS+=	${SITE_PERL}/${PERL_ARCH}/Term/ReadKey.pm:${PORTSDIR}/devel/p5-Term-ReadKey
+.endif
+
+HAS_CONFIGURE=	yes
+CONFIGURE_ARGS=	--prefix=${PREFIX}
+USE_PERL5=	yes
+ALL_TARGET=	default
+
+SUB_FILES=	pkg-message
+PKGMESSAGE=	${WRKDIR}/pkg-message
+
+PLIST_FILES=	bin/yasql etc/yasql.conf.sample
+
+MAN1=		yasql.1
+
+PORTDOCS=	README yasql.html
+
+pre-everything::
+	@${ECHO_MSG}
+	@${ECHO_MSG} "You may use the following build options:"
+	@${ECHO_MSG}
+	@${ECHO_MSG} "WITHOUT_CSV	disable support for in/out CSV files"
+	@${ECHO_MSG} "WITHOUT_HIRES	disable support for high resolution benchmarking"
+	@${ECHO_MSG} "WITHOUT_READKEY	disable a better input and output control"
+	@${ECHO_MSG}
+
+pre-configure:
+	@${PERL} -pi -e 's|/bin/more|/usr/bin/more|' ${WRKSRC}/yasql.conf
+
+pre-install:
+.if exists(${PREFIX}/etc/yasql.conf)
+	${MV} ${PREFIX}/etc/yasql.conf ${PREFIX}/etc/yasql.conf.precious
+.endif
+
+post-install:
+	${MV} ${PREFIX}/etc/yasql.conf ${PREFIX}/etc/yasql.conf.sample
+.if !defined(NOPORTDOCS)
+	${MKDIR} ${DOCSDIR}
+	${INSTALL_DATA} ${PORTDOCS:S|^|${WRKSRC}/|} ${DOCSDIR}
+.endif
+.if exists(${PREFIX}/etc/yasql.conf.precious)
+	${MV} ${PREFIX}/etc/yasql.conf.precious ${PREFIX}/etc/yasql.conf
+.else
+	@${ECHO_MSG}
+	@${CAT} ${PKGMESSAGE}
+	@${ECHO_MSG}
+.endif
+
+.include <bsd.port.mk>
diff --git a/databases/yasql/distinfo b/databases/yasql/distinfo
new file mode 100644
index 000000000000..21d0f92b0f7d
--- /dev/null
+++ b/databases/yasql/distinfo
@@ -0,0 +1,2 @@
+MD5 (yasql-1.82.tar.gz) = 1189d1308d21d42318673d128bf926e3
+SIZE (yasql-1.82.tar.gz) = 109167
diff --git a/databases/yasql/files/pkg-message.in b/databases/yasql/files/pkg-message.in
new file mode 100644
index 000000000000..3ff7f53e508f
--- /dev/null
+++ b/databases/yasql/files/pkg-message.in
@@ -0,0 +1,6 @@
+=========================================================
+Please copy the file %%PREFIX%%/etc/yasql.conf.sample
+to %%PREFIX%%/etc/yasql.conf and edit your configuration.
+
+Export your ORACLE_HOME=%%PREFIX%%/oracle7
+=========================================================
diff --git a/databases/yasql/pkg-descr b/databases/yasql/pkg-descr
new file mode 100644
index 000000000000..3a4c6f92a5e8
--- /dev/null
+++ b/databases/yasql/pkg-descr
@@ -0,0 +1,9 @@
+YASQL is an open source Oracle command line interface.
+
+YASQL features a much kinder alternative to SQL*Plus's user interface.
+This is meant to be a complete replacement for SQL*Plus when dealing with
+ad hoc queries and general database interfacing.
+
+Note: this is not a front-end to sqlplus!
+
+WWW: http://yasql.sourceforge.net/