[78620] users/pixilla/databases
pixilla at macports.org
pixilla at macports.org
Sat May 14 08:12:30 PDT 2011
Revision: 78620
http://trac.macports.org/changeset/78620
Author: pixilla at macports.org
Date: 2011-05-14 08:12:30 -0700 (Sat, 14 May 2011)
Log Message:
-----------
databases/mysql5-lib_mysqludf_preg: Tidy
Modified Paths:
--------------
users/pixilla/databases/mysql5-lib_mysqludf_fproj4/Portfile
users/pixilla/databases/mysql5-lib_mysqludf_preg/Portfile
Added Paths:
-----------
users/pixilla/databases/mysql5-lib_mysqludf_json/
users/pixilla/databases/mysql5-lib_mysqludf_json/Portfile
users/pixilla/databases/mysql5-lib_mysqludf_xql/
users/pixilla/databases/mysql5-lib_mysqludf_xql/Portfile
Removed Paths:
-------------
users/pixilla/databases/mysql5-lib_mysqludf_json/Portfile
users/pixilla/databases/mysql5-lib_mysqludf_xql/Portfile
Modified: users/pixilla/databases/mysql5-lib_mysqludf_fproj4/Portfile
===================================================================
--- users/pixilla/databases/mysql5-lib_mysqludf_fproj4/Portfile 2011-05-14 15:00:29 UTC (rev 78619)
+++ users/pixilla/databases/mysql5-lib_mysqludf_fproj4/Portfile 2011-05-14 15:12:30 UTC (rev 78620)
@@ -41,16 +41,18 @@
build {
set cmd "${configure.cc} ${configure.ldflags} ${configure.cflags} ${configure.cppflags}"
system "cd ${worksrcpath} && ${cmd} ${name_package}.c -o ${name_package}.so"
- reinplace "s/\.dll//g" $worksrcpath/lib_mysqludf_fPROJ4.sql
- reinplace "s/'lib_mysqludf_fPROJ4'/'lib_mysqludf_fPROJ4.so'/g" $worksrcpath/lib_mysqludf_fPROJ4.sql
xinstall -d ${worksrcpath}/macports
set fp [open ${worksrcpath}/macports/installdb.sql w]
puts $fp "USE mysql;"
- puts $fp "CREATE FUNCTION lib_mysqludf_fPROJ4_info RETURNS STRING SONAME 'lib_mysqludf_fPROJ4.so';"
- puts $fp "CREATE FUNCTION fPROJ4_transform RETURNS REAL SONAME 'lib_mysqludf_fPROJ4.so';"
- puts $fp "CREATE FUNCTION fPROJ4_Geo2UTM RETURNS REAL SONAME 'lib_mysqludf_fPROJ4.so';"
- puts $fp "CREATE FUNCTION fPROJ4_UTM2Geo RETURNS REAL SONAME 'lib_mysqludf_fPROJ4.so';"
+ puts $fp "DROP FUNCTION IF EXISTS lib_mysqludf_fPROJ4_info;"
+ puts $fp "DROP FUNCTION IF EXISTS fPROJ4_transform;"
+ puts $fp "DROP FUNCTION IF EXISTS fPROJ4_Geo2UTM;"
+ puts $fp "DROP FUNCTION IF EXISTS fPROJ4_UTM2Geo;"
+ puts $fp "CREATE FUNCTION lib_mysqludf_fPROJ4_info RETURNS STRING SONAME '${name_package}.so';"
+ puts $fp "CREATE FUNCTION fPROJ4_transform RETURNS REAL SONAME '${name_package}.so';"
+ puts $fp "CREATE FUNCTION fPROJ4_Geo2UTM RETURNS REAL SONAME '${name_package}.so';"
+ puts $fp "CREATE FUNCTION fPROJ4_UTM2Geo RETURNS REAL SONAME '${name_package}.so';"
close $fp
set fp [open ${worksrcpath}/macports/uninstalldb.sql w]
@@ -60,14 +62,12 @@
puts $fp "DROP FUNCTION IF EXISTS fPROJ4_Geo2UTM;"
puts $fp "DROP FUNCTION IF EXISTS fPROJ4_UTM2Geo;"
close $fp
-
-
}
destroot {
xinstall -m 755 -d ${destroot}${prefix}/lib/mysql${version_mysql}/mysql/plugin
xinstall -m 644 -W ${worksrcpath} \
- lib_mysqludf_fPROJ4.so \
+ ${name_package}.so \
${destroot}${prefix}/lib/mysql${version_mysql}/mysql/plugin
xinstall -m 755 -d ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}
xinstall -m 644 -W ${worksrcpath}/macports \
Deleted: users/pixilla/databases/mysql5-lib_mysqludf_json/Portfile
===================================================================
--- users/pixilla/databases/mysql5-lib_mysqludf_preg/Portfile 2011-05-13 18:58:16 UTC (rev 78598)
+++ users/pixilla/databases/mysql5-lib_mysqludf_json/Portfile 2011-05-14 15:12:30 UTC (rev 78620)
@@ -1,37 +0,0 @@
-# -*- coding: utf-8; mode: tcl; tab-width: 4; truncate-lines: t; indent-tabs-mode: nil; c-basic-offset: 4 -*- vim:fenc=utf-8:et:sw=4:ts=4:sts=4
-# $Id$
-
-PortSystem 1.0
-
-set name_group mysql5
-name ${name_group}-lib_mysqludf_preg
-set name_package [string map {"${name_group}-" ""} ${name}]
-version 1.0.1
-distname ${name_package}-${version}
-categories databases lang
-maintainers pixilla
-platforms darwin
-
-description lib_mysqludf_preg is a library of mysql UDFs (user-defined-functions) that \
- provide access to the PCRE (perl compatible-regular-expressions) library for \
- pattern matching.
-long_description {$description} The PCRE library is a set of functions that implement regular \
- expression pattern matching using the same syntax and semantics as Perl 5. \
- This syntax can often handle more complex expressions and capturing than \
- standard regular expression implementations.
-
-homepage http://www.mysqludf.org/lib_mysqludf_preg/
-master_sites ${homepage}
-
-checksums sha1 a92a58a5c20b71723624da28ed3ee5670fe25405 \
- rmd160 21dfbebe4b421da8acf4e14892fb272bee804f58
-
-depends_lib-append path:${prefix}/lib/mysql5/bin/mysql_config:mysql5
-
-configure.args-append \
- --with-pcre=${prefix} \
- --with-mysql=${prefix}/lib/${name_group}/bin/mysql_config
-
-livecheck.url ${master_sites}
-livecheck.type regex
-livecheck.regex "${name}-(\\d+\\.\\d+(\[0-9rc.\]+)?)${extract.suffix}"
Copied: users/pixilla/databases/mysql5-lib_mysqludf_json/Portfile (from rev 78603, users/pixilla/databases/mysql5-lib_mysqludf_preg/Portfile)
===================================================================
--- users/pixilla/databases/mysql5-lib_mysqludf_json/Portfile (rev 0)
+++ users/pixilla/databases/mysql5-lib_mysqludf_json/Portfile 2011-05-14 15:12:30 UTC (rev 78620)
@@ -0,0 +1,100 @@
+# -*- coding: utf-8; mode: tcl; tab-width: 4; truncate-lines: t; indent-tabs-mode: nil; c-basic-offset: 4 -*- vim:fenc=utf-8:et:sw=4:ts=4:sts=4
+# $Id$
+
+PortSystem 1.0
+
+set version_mysql 5
+set name_package lib_mysqludf_json
+name mysql${version_mysql}-${name_package}
+version 0.0.2
+distname ${name_package}_${version}
+categories databases lang
+maintainers pixilla
+platforms darwin
+license LGPL
+
+description Map database data to the JSON.
+long_description ${description}
+
+homepage http://www.mysqludf.org/${name_package}/
+master_sites ${homepage}
+
+checksums sha1 e839c563449d1c1b54ddfc05277500824f287d0c \
+ rmd160 4c98739ed2753580195e11e602777188bc9a20ff
+
+depends_lib-append path:${prefix}/lib/mysql${version_mysql}/bin/mysql_config:mysql${version_mysql}
+
+extract.mkdir yes
+
+use_configure no
+
+configure.cppflags-append \
+ -I/opt/local/include/mysql5/mysql \
+ -dynamiclib \
+ -fno-common \
+ -undefined dynamic_lookup
+post-extract {
+ move ${worksrcpath}/${name_package}.so \
+ ${worksrcpath}/${name_package}.so.orig
+}
+
+build {
+ set cmd "${configure.cc} ${configure.ldflags} ${configure.cflags} ${configure.cppflags}"
+ system "cd ${worksrcpath} && ${cmd} ${name_package}.c -o ${name_package}.so"
+
+ xinstall -d ${worksrcpath}/macports
+ set fp [open ${worksrcpath}/macports/installdb.sql w]
+ puts $fp "USE mysql;"
+ puts $fp "DROP FUNCTION IF EXISTS lib_mysqludf_json_info;"
+ puts $fp "DROP FUNCTION IF EXISTS json_array;"
+ puts $fp "DROP FUNCTION IF EXISTS json_members;"
+ puts $fp "DROP FUNCTION IF EXISTS json_object;"
+ puts $fp "DROP FUNCTION IF EXISTS json_values;"
+ puts $fp "CREATE FUNCTION lib_mysqludf_json_info RETURNS STRING SONAME '${name_package}.so';"
+ puts $fp "CREATE FUNCTION json_array RETURNS REAL SONAME '${name_package}.so';"
+ puts $fp "CREATE FUNCTION json_members RETURNS REAL SONAME '${name_package}.so';"
+ puts $fp "CREATE FUNCTION json_object RETURNS REAL SONAME '${name_package}.so';"
+ puts $fp "CREATE FUNCTION json_values RETURNS REAL SONAME '${name_package}.so';"
+ close $fp
+
+ set fp [open ${worksrcpath}/macports/uninstalldb.sql w]
+ puts $fp "USE mysql;"
+ puts $fp "DROP FUNCTION IF EXISTS lib_mysqludf_json_info;"
+ puts $fp "DROP FUNCTION IF EXISTS json_array;"
+ puts $fp "DROP FUNCTION IF EXISTS json_members;"
+ puts $fp "DROP FUNCTION IF EXISTS json_object;"
+ puts $fp "DROP FUNCTION IF EXISTS json_values;"
+ close $fp
+}
+
+destroot {
+ xinstall -m 755 -d ${destroot}${prefix}/lib/mysql5/mysql/plugin
+ xinstall -m 644 -W ${worksrcpath} ${name_package}.so \
+ ${destroot}${prefix}/lib/mysql5/mysql/plugin
+ xinstall -m 755 -d ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}
+ xinstall -m 644 -W ${worksrcpath}/macports installdb.sql uninstalldb.sql \
+ ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}
+ xinstall -m 755 -d ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}/doc/html
+ xinstall -m 644 ${worksrcpath}/${name_package}.html \
+ ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}/doc/html/index.html
+}
+
+livecheck.url ${master_sites}
+livecheck.type regex
+livecheck.regex "${name_package}-(\\d+\\.\\d+(\[\\drc.\]+)?)${extract.suffix}"
+
+notes "
+
+ This port installs two mysql scripts to simplify the install/uninstall of the ${name_package}
+ UDFs (user-defined-functions) along with html documentation describing the functions syntax.
+
+ Install:
+ \$ ${prefix}/bin/mysql${version_mysql} -uroot -p < ${prefix}/share/mysql${version_mysql}/${name_package}/installdb.sql
+
+ Uninstall:
+ \$ ${prefix}/bin/mysql${version_mysql} -uroot -p < ${prefix}/share/mysql${version_mysql}/${name_package}/uninstalldb.sql
+
+ HTML Documentation:
+ $ open ${prefix}/share/mysql${version_mysql}/${name_package}/doc/html/index.html
+ "
+
Modified: users/pixilla/databases/mysql5-lib_mysqludf_preg/Portfile
===================================================================
--- users/pixilla/databases/mysql5-lib_mysqludf_preg/Portfile 2011-05-14 15:00:29 UTC (rev 78619)
+++ users/pixilla/databases/mysql5-lib_mysqludf_preg/Portfile 2011-05-14 15:12:30 UTC (rev 78620)
@@ -37,10 +37,10 @@
post-destroot {
xinstall -m 755 -d ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}
- xinstall -m 755 -d ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}/doc
xinstall -m 644 -W ${worksrcpath} \
AUTHORS COPYING ChangeLog INSTALL NEWS README installdb.sql uninstalldb.sql \
${destroot}${prefix}/share/mysql${version_mysql}/${name_package}
+ xinstall -m 755 -d ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}/doc
copy ${worksrcpath}/doc/html \
${destroot}${prefix}/share/mysql${version_mysql}/${name_package}/doc
copy ${worksrcpath}/test \
Deleted: users/pixilla/databases/mysql5-lib_mysqludf_xql/Portfile
===================================================================
--- users/pixilla/databases/mysql5-lib_mysqludf_preg/Portfile 2011-05-13 18:58:16 UTC (rev 78598)
+++ users/pixilla/databases/mysql5-lib_mysqludf_xql/Portfile 2011-05-14 15:12:30 UTC (rev 78620)
@@ -1,37 +0,0 @@
-# -*- coding: utf-8; mode: tcl; tab-width: 4; truncate-lines: t; indent-tabs-mode: nil; c-basic-offset: 4 -*- vim:fenc=utf-8:et:sw=4:ts=4:sts=4
-# $Id$
-
-PortSystem 1.0
-
-set name_group mysql5
-name ${name_group}-lib_mysqludf_preg
-set name_package [string map {"${name_group}-" ""} ${name}]
-version 1.0.1
-distname ${name_package}-${version}
-categories databases lang
-maintainers pixilla
-platforms darwin
-
-description lib_mysqludf_preg is a library of mysql UDFs (user-defined-functions) that \
- provide access to the PCRE (perl compatible-regular-expressions) library for \
- pattern matching.
-long_description {$description} The PCRE library is a set of functions that implement regular \
- expression pattern matching using the same syntax and semantics as Perl 5. \
- This syntax can often handle more complex expressions and capturing than \
- standard regular expression implementations.
-
-homepage http://www.mysqludf.org/lib_mysqludf_preg/
-master_sites ${homepage}
-
-checksums sha1 a92a58a5c20b71723624da28ed3ee5670fe25405 \
- rmd160 21dfbebe4b421da8acf4e14892fb272bee804f58
-
-depends_lib-append path:${prefix}/lib/mysql5/bin/mysql_config:mysql5
-
-configure.args-append \
- --with-pcre=${prefix} \
- --with-mysql=${prefix}/lib/${name_group}/bin/mysql_config
-
-livecheck.url ${master_sites}
-livecheck.type regex
-livecheck.regex "${name}-(\\d+\\.\\d+(\[0-9rc.\]+)?)${extract.suffix}"
Copied: users/pixilla/databases/mysql5-lib_mysqludf_xql/Portfile (from rev 78605, users/pixilla/databases/mysql5-lib_mysqludf_preg/Portfile)
===================================================================
--- users/pixilla/databases/mysql5-lib_mysqludf_xql/Portfile (rev 0)
+++ users/pixilla/databases/mysql5-lib_mysqludf_xql/Portfile 2011-05-14 15:12:30 UTC (rev 78620)
@@ -0,0 +1,67 @@
+# -*- coding: utf-8; mode: tcl; tab-width: 4; truncate-lines: t; indent-tabs-mode: nil; c-basic-offset: 4 -*- vim:fenc=utf-8:et:sw=4:ts=4:sts=4
+# $Id$
+
+PortSystem 1.0
+
+set version_mysql 5
+set name_package lib_mysqludf_xql
+name mysql${version_mysql}-${name_package}
+version 1.0.0
+distname ${name_package}-${version}
+categories databases lang
+maintainers pixilla
+platforms darwin
+
+description The lib_mysqludf_xql library provides an array of functions, which can be used \
+ to create XML output directly from MySQL using a single SQL query.
+long_description ${description} This prevents having to convert a MySQL result to XML in a PHP \
+ script, Ruby script, etc. This improves performance and simplifies your code. \
+ \
+ The library provides the same functionality as SQL/XML, seen in MS SQL server \
+ and Oracle. However it uses normal functions. By using subqueries the same \
+ results as SQL/XML can be generated.
+
+homepage http://www.mysqludf.org/${name_package}/
+master_sites ${homepage}
+
+checksums sha1 5650c5daa67b80f90ba8d5a978c3f0baff470243 \
+ rmd160 6750ca0e97ee096194c33703d0b35b645920a0ee
+
+depends_lib-append path:${prefix}/lib/mysql${version_mysql}/bin/mysql_config:mysql${version_mysql} \
+ port:libxml2
+
+configure.args-append \
+ --with-libxml2=${prefix}/lib/xml2Conf.sh \
+ --with-mysql=${prefix}/lib/mysql${version_mysql}/bin/mysql_config \
+ --with-mysqlbin=${prefix}/bin/mysql${version_mysql} \
+ --with-mysqladmin=${prefix}/bin/mysqladmin${version_mysql} \
+ --with-mysqltest=${prefix}/bin/mysqltestc${version_mysql}
+
+post-destroot {
+ xinstall -m 755 -d ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}
+ xinstall -m 644 -W ${worksrcpath} \
+ API AUTHORS COPYING ChangeLog INSTALL NEWS README installdb.sql uninstalldb.sql \
+ ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}
+ copy ${worksrcpath}/test \
+ ${destroot}${prefix}/share/mysql${version_mysql}/${name_package}
+}
+
+livecheck.url ${master_sites}
+livecheck.type regex
+livecheck.regex "${name_package}-(\\d+\\.\\d+(\[\\drc.\]+)?)${extract.suffix}"
+
+notes "
+
+ This port installs two mysql scripts to simplify the install/uninstall of the ${name_package}
+ UDFs (user-defined-functions).
+
+ Install:
+ \$ ${prefix}/bin/mysql${version_mysql} -uroot -p < ${prefix}/share/mysql${version_mysql}/${name_package}/installdb.sql
+
+ Uninstall:
+ \$ ${prefix}/bin/mysql${version_mysql} -uroot -p < ${prefix}/share/mysql${version_mysql}/${name_package}/uninstalldb.sql
+
+ API:
+ $ cat ${prefix}/share/mysql${version_mysql}/${name_package}/API
+ "
+
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-changes/attachments/20110514/86353ec6/attachment-0001.html>
More information about the macports-changes
mailing list