ports/142086: Port of lib_mysqludf_xql

Mon Dec 28 00:50:02 UTC 2009

>Number:         142086
>Category:       ports
>Synopsis:       Port of lib_mysqludf_xql
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          update
>Submitter-Id:   current-users
>Arrival-Date:   Mon Dec 28 00:50:01 UTC 2009
>Closed-Date:
>Last-Modified:
>Originator:     Mina R Waheeb
>Release:        9.0-CURRENT
>Organization:
Kemetex
>Environment:
FreeBSD localhost 9.0-CURRENT FreeBSD 9.0-CURRENT #0: Sun Dec 27 17:42:47 UTC 2009     root at localhost:/usr/obj/usr/src/sys/MINA  i386
>Description:
Hi, 
  MySQL only support a few XML functions, lib_mysqludf_xql [1] provides SQLXML user defined set of functions. very small and very useful.

The port attached.

Cheers and happy new year,
Mina R Waheeb

[1] http://www.mysqludf.org/lib_mysqludf_xql/index.php
>How-To-Repeat:

>Fix:

Patch attached with submission follows:

# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
#	mysql-xql
#	mysql-xql/Makefile
#	mysql-xql/distinfo
#	mysql-xql/pkg-descr
#	mysql-xql/pkg-plist
#	mysql-xql/pkg-message
#	mysql-xql/files
#	mysql-xql/files/patch-Makefile.in
#	mysql-xql/files/patch-configure
#
echo c - mysql-xql
mkdir -p mysql-xql > /dev/null 2>&1
echo x - mysql-xql/Makefile
sed 's/^X//' >mysql-xql/Makefile << '83bbacdac2200a12a74c2412059fe164'
X# New ports collection makefile for:	mysql-xql
X# Date created:		Mon Dec 28 2009	
X# Whom:			Mina R Waheeb <syncer at gmail.com>
X#
X#
X
XPORTNAME=	mysql-xql
XPORTVERSION=	1.0.0
XCATEGORIES=	databases
XDISTNAME=	lib_mysqludf_xql-${PORTVERSION}
XMASTER_SITES=	http://www.mysqludf.org/lib_mysqludf_xql/
X
XMAINTAINER=	syncer at gmail.com	
XCOMMENT=	Library provides XML output functions to MySQL server
X
XUSE_GNOME=	libxml2
XGNU_CONFIGURE=	yes
XUSE_GMAKE=	yes
XUSE_MYSQL=	yes
X
Xpost-install:
X	${CAT} ${PKGMESSAGE}
X
X.include <bsd.port.mk>
83bbacdac2200a12a74c2412059fe164
echo x - mysql-xql/distinfo
sed 's/^X//' >mysql-xql/distinfo << 'e5dd10d10418c949c899963c69d0eb77'
XMD5 (lib_mysqludf_xql-1.0.0.tar.gz) = ba03762316df04bcf894486ce603e428
XSHA256 (lib_mysqludf_xql-1.0.0.tar.gz) = f992fcd77f7596aee32ddeccbd9b31aa67c9cf2cd04f84959db63f87e1ca0321
XSIZE (lib_mysqludf_xql-1.0.0.tar.gz) = 328273
e5dd10d10418c949c899963c69d0eb77
echo x - mysql-xql/pkg-descr
sed 's/^X//' >mysql-xql/pkg-descr << 'bf19e21254405a7d9e01d5a82d72b477'
XThe lib_mysqludf_xql library provides an array of functions, 
Xwhich can be used to create XML output directly from MySQL 
Xusing a single SQL query. This prevents having to convert a 
XMySQL result to XML in a PHP script, Ruby script, etc. 
X
XThe library provides the same functionality as SQL/XML, seen 
Xin MS SQL server and Oracle. However it uses normal functions. 
XBy using subqueries the same results as SQL/XML can be generated. 
X
XWWW: http://www.mysqludf.org/lib_mysqludf_xql/index.php
bf19e21254405a7d9e01d5a82d72b477
echo x - mysql-xql/pkg-plist
sed 's/^X//' >mysql-xql/pkg-plist << '2be94e947ea4ec204ca76fe6501783af'
Xlib/mysql/plugin/lib_mysqludf_xql.a
Xlib/mysql/plugin/lib_mysqludf_xql.la
Xlib/mysql/plugin/lib_mysqludf_xql.so
2be94e947ea4ec204ca76fe6501783af
echo x - mysql-xql/pkg-message
sed 's/^X//' >mysql-xql/pkg-message << 'e27ad892626451faeeb45af4174abcd1'
XTo add the custom functions to your MySQL server use the following syntax:
X(you may install only the functions you need):
X
XUSE mysql;
X
XDROP FUNCTION IF EXISTS lib_mysqludf_xql_info;
XDROP FUNCTION IF EXISTS xql_textdecl;
XDROP FUNCTION IF EXISTS xql_pi;
XDROP FUNCTION IF EXISTS xql_dtd;
XDROP FUNCTION IF EXISTS xql_element;
XDROP FUNCTION IF EXISTS xql_forest;
XDROP FUNCTION IF EXISTS xql_concat;
XDROP FUNCTION IF EXISTS xql_agg;
XDROP FUNCTION IF EXISTS xql_comment;
XDROP FUNCTION IF EXISTS xql_cdata;
XDROP FUNCTION IF EXISTS xql_encode;
X
XCREATE FUNCTION lib_mysqludf_xql_info RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE FUNCTION xql_textdecl RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE FUNCTION xql_pi RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE FUNCTION xql_dtd RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE FUNCTION xql_element RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE FUNCTION xql_forest RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE FUNCTION xql_concat RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE AGGREGATE FUNCTION xql_agg RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE FUNCTION xql_comment RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE FUNCTION xql_cdata RETURNS STRING SONAME 'lib_mysqludf_xql.so';
XCREATE FUNCTION xql_encode RETURNS STRING SONAME 'lib_mysqludf_xql.so';
X
XExample for deinstalling a function:
XDROP FUNCTION xql_encode;
X
XFor function descriptions, see the following webpage:
Xhttp://http://www.mysqludf.org/lib_mysqludf_xql/index.php
X
X
e27ad892626451faeeb45af4174abcd1
echo c - mysql-xql/files
mkdir -p mysql-xql/files > /dev/null 2>&1
echo x - mysql-xql/files/patch-Makefile.in
sed 's/^X//' >mysql-xql/files/patch-Makefile.in << '09f1dda2ed93be8663a5f0863ce7dd37'
X--- Makefile.in.org	2009-11-20 13:25:51.000000000 +0000
X+++ Makefile.in		2009-12-28 02:12:35.000000000 +0000
X@@ -226,7 +226,7 @@
X includedir = @includedir@
X infodir = @infodir@
X install_sh = @install_sh@
X-libdir = @libdir@
X+libdir = @MYSQL_PLUGINDIR@
X libexecdir = @libexecdir@
X localedir = @localedir@
X localstatedir = @localstatedir@
09f1dda2ed93be8663a5f0863ce7dd37
echo x - mysql-xql/files/patch-configure
sed 's/^X//' >mysql-xql/files/patch-configure << 'ba0f07eb32f1e5fe4d1ab04a78e00a0a'
X--- configure.org	2009-11-19 14:51:20.000000000 +0000
X+++ configure		2009-12-28 00:24:17.000000000 +0000
X@@ -14555,7 +14555,7 @@
X 
X 
X 
X-if test -n "$MYSQL_PLUGINDIR" && test "$libdir" == '${exec_prefix}/lib' ; then
X+if test -n "$MYSQL_PLUGINDIR" ; then
X   { $as_echo "$as_me:${as_lineno-$LINENO}: setting libdir to mysql plugin dir $MYSQL_PLUGINDIR" >&5
X $as_echo "$as_me: setting libdir to mysql plugin dir $MYSQL_PLUGINDIR" >&6;}
X   libdir=$MYSQL_PLUGINDIR
X@@ -14599,6 +14599,8 @@
X     for i in /usr /usr/local ; do
X       if test -f "$i/lib/xml2Conf.sh" ; then
X         XML2_CONFIG="$i/lib/xml2Conf.sh"
X+      elif test -f "$i/etc/xml2Conf.sh" ; then
X+        XML2_CONFIG="$i/etc/xml2Conf.sh"
X       elif test -f "$i/lib/libxml2.so"; then
X         XML2_DIR="$i"
X       fi
ba0f07eb32f1e5fe4d1ab04a78e00a0a
exit

>Release-Note:
>Audit-Trail:
>Unformatted: