Updated sqsh to 2.1.

pkg related changes: honour PKG_SYSCONFDIR for sqshrc.

Major changes since 1.7:

    * New build system/directory structure. Should build against ASE
      12.0 and FreeTDS now.
    * Added support for varchar2() and varbinary2() for ASE 12.5 (I
      don't have a 12.5 instance to test against yet though).
    * Added \if command to perform conditional execution. Please read
      the manual carefully on how expressions work.
    * Added \while command to perform basic looping conditional
      expressions.
    * Added \break command to break out of current loop
    * Added \for command to perform basic iteration.
    * Added \do command to allow the exection of a sqsh script block
      once per row returned from statement. Also new #[0-9] variables
      may be used to refer to column names in result set. Also note
      that \do allows flags -U, -S, -P for execution of statements on
      other server or as other users.
    * Added \func command to create a sqsh function for later
      execution. Also, now ${[0-9]} now refer to the parameters to
      this function when it is called. Note that by passing -x to
      \func, the function will be exported as a full sqsh command, and
      can be called directly without calling \call.
    * Added \return to return from current function.
    * Obviously, added \call to call sqsh function.
    * New variable $? contains: - Return status of command executed on
      pipe '|' - Return status of expression evaluated for \while or
      \if. - Last server error number of severity > 10 (@@error). This
      is useful for flow-of-control using the new conditional
      statements.
    * Added a directory of handy filter scripts.
    * Fixed \rpc command with @variable names.
    * \exit now exits sqsh, no matter how many \loop nesting levels
      you are in.
    * The user will now be re-prompted to enter a password if a "Login
      failed." message is received from the server. This may be
      disabled using the new $password_retry variable.
    * Got rid of error message about ct_exit() not being called.
    * Created new 'make distrib' option to build a self-contained sqsh
      binary distribution.
    * $rcfile and $SQSHRC may now be colon delimited lists of sqshrc
      files. This allows for system-wide rc files to be loaded first
      before local files. Also, the default $SQSHRC setting is now
      "/usr/local/etc/sqshrc:$HOME/.sqshrc" (the /usr/local will be
      automatically replaced by the contents of --prefix when passed
      to configure).
    * Fixed -C.
    * $SQSHRC no longer needs to be writable.
    * sqsh no longer pays attention to quotes inside of comments
      during variable expansion.
    * Fixed bcp'ing of results from stored procedures.
    * libsybtcl will now be chosen if available.
    * 'exact' mode keyword expansion should now work better (thanks to
      Sean Woolcock.
    * Added $bcp_colsep and $bcp_rowsep configuration variables to
      control the separators used during "go -m bcp".
    * Added $bcp_trim to configure whether or not trailing spaces are
      trimmed in the bcp output.
    * Fixed segfault in "pretty" display mode.

1 files changed, 59 insertions, 0 deletions

diff --git a/databases/sqsh/Makefile.common b/databases/sqsh/Makefile.common
new file mode 100644
index 00000000000..25a2c2b3689
--- /dev/null
+++ b/databases/sqsh/Makefile.common
@@ -0,0 +1,59 @@
+# $NetBSD: Makefile.common,v 1.1 2004/03/29 03:11:03 grant Exp $
+
+DISTNAME=	sqsh-2.1-src
+CATEGORIES=	databases
+MASTER_SITES=	${HOMEPAGE}
+
+MAINTAINER=	tsarna@NetBSD.org
+HOMEPAGE=	http://www.sqsh.org/
+COMMENT=	Sybase SQL shell
+
+ALL_TARGET=		build
+
+WRKSRC=			${WRKDIR}/${DISTNAME:C|-src||}
+USE_BUILDLINK2=		yes
+USE_PKGINSTALL=		yes
+GNU_CONFIGURE=		yes
+CONFIGURE_ARGS+=	--with-readline
+
+CONF_FILES+=		${PREFIX}/share/examples/sqsh/sample.sqshrc ${PKG_SYSCONFDIR}/sqshrc
+
+# support for the native Sybase Open Client
+BUILD_DEFS+=		USE_SYBASE_OPENCLIENT
+BUILD_DEFS+=		SYBASE
+.if defined(USE_SYBASE_OPENCLIENT) && empty(USE_SYBASE_OPENCLIENT:M[Nn][Oo])
+.  if defined(SYBASE) && exists(${SYBASE}/lib/libct.so)
+BUILDLINK_PASSTHRU_DIRS=${SYBASE}
+_SYBASE=		${SYBASE}
+.  else
+PKG_FAIL_REASON+=	"You must define SYBASE to the base directory of Open Client."
+.  endif
+.else
+_SYBASE=		${BUILDLINK_PREFIX.freetds}/freetds
+CONFIGURE_ENV+=		SYBASE_LIBS=-lct
+MAKE_FLAGS+=		SYBASE_LIBS=-lct
+.endif
+
+LDFLAGS+=		-Wl,${RPATH_FLAG}${_SYBASE}/lib
+CONFIGURE_ENV+=		SYBASE="${_SYBASE}"
+CONFIGURE_ENV+=		INCDIRS="${BUILDLINK_PREFIX.readline}/include"
+CONFIGURE_ENV+=		LIBDIRS="${BUILDLINK_PREFIX.readline}/lib"
+
+do-install:
+	${INSTALL_PROGRAM} ${WRKSRC}/src/sqsh ${PREFIX}/bin
+	${INSTALL_MAN} ${WRKSRC}/doc/sqsh.1 ${PREFIX}/man/man1/sqsh.1
+	${INSTALL_DATA_DIR} ${PREFIX}/share/examples/sqsh
+	${INSTALL_DATA} ${WRKSRC}/doc/sample.sqshrc ${PREFIX}/share/examples/sqsh
+
+.include "../../mk/bsd.prefs.mk"
+
+.if ${OPSYS} == "Darwin"
+.  include "../../devel/dlcompat/buildlink2.mk"
+.endif
+
+.if !defined(USE_SYBASE_OPENCLIENT)
+.  include "../../databases/freetds/buildlink2.mk"
+.endif
+
+.include "../../devel/readline/buildlink2.mk"
+.include "../../mk/bsd.pkg.mk"