Date: Mon, 28 Dec 2009 00:47:12 GMT From: Mina R Waheeb <syncer@gmail.com> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/142086: Port of lib_mysqludf_xql Message-ID: <200912280047.nBS0lCqb075393@www.freebsd.org> Resent-Message-ID: <200912280050.nBS0o1Hw078650@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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@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@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@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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200912280047.nBS0lCqb075393>