svn commit: r366009 - in head/databases: . sqlite-ext-pcre

[Kurt Jaeger]

Author: pi
Date: Sun Aug 24 20:00:56 2014
New Revision: 366009
URL: http://svnweb.freebsd.org/changeset/ports/366009
QAT: https://qat.redports.org/buildarchive/r366009/

Log:
  New port: databases/sqlite-ext-pcre
  
  This is sqlite3-pcre, an extension for sqlite3 that uses libpcre to
  provide a regexp() function to use with the REGEXP operator.
  
  PR:		190121
  Submitted by:	Vick Khera <vivek at khera.org>

Added:
  head/databases/sqlite-ext-pcre/
  head/databases/sqlite-ext-pcre/Makefile   (contents, props changed)
  head/databases/sqlite-ext-pcre/distinfo   (contents, props changed)
  head/databases/sqlite-ext-pcre/pkg-descr   (contents, props changed)
  head/databases/sqlite-ext-pcre/pkg-message   (contents, props changed)
Modified:
  head/databases/Makefile

Modified: head/databases/Makefile
==============================================================================
--- head/databases/Makefile	Sun Aug 24 19:43:33 2014	(r366008)
+++ head/databases/Makefile	Sun Aug 24 20:00:56 2014	(r366009)
@@ -890,6 +890,7 @@
     SUBDIR += sqldeveloper
     SUBDIR += sqlite-ext-miscfuncs
     SUBDIR += sqlite-ext-mobigroup
+    SUBDIR += sqlite-ext-pcre
     SUBDIR += sqlite2
     SUBDIR += sqlite3
     SUBDIR += sqliteman

Added: head/databases/sqlite-ext-pcre/Makefile
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/sqlite-ext-pcre/Makefile	Sun Aug 24 20:00:56 2014	(r366009)
@@ -0,0 +1,39 @@
+# $FreeBSD$
+
+PORTNAME=	sqlite-ext-pcre
+PORTVERSION=	20100208
+CATEGORIES=	databases
+
+MAINTAINER=	vivek at khera.org
+COMMENT=	Regexp function for SQLite based on PCRE library
+
+LIB_DEPENDS+=	libpcre.so:${PORTSDIR}/devel/pcre
+
+USE_SQLITE=	yes
+DIST_SUBDIR=	sqlite-ext
+
+LIBFILE=	pcre.so
+INST_DIR=	${PREFIX}/libexec/${DIST_SUBDIR}
+USE_LDCONFIG=	${INST_DIR}
+
+SUB_LIST+=	LIBFILE=${LIBFILE}
+
+PLIST_DIRS=	libexec/${DIST_SUBDIR}
+PLIST_FILES=	${PLIST_DIRS}/${LIBFILE}
+
+USES=		gmake pkgconfig
+
+USE_GITHUB=	yes
+GH_ACCOUNT=	ralight
+GH_PROJECT=	sqlite3-pcre
+GH_COMMIT=	c98da41
+GH_TAGNAME=	${GH_COMMIT}
+
+do-build:
+	@cd ${WRKSRC} && ${GMAKE}
+
+do-install:
+	@${MKDIR} ${STAGEDIR}${PREFIX}/libexec/${DIST_SUBDIR}
+	@${INSTALL_PROGRAM} ${WRKSRC}/${LIBFILE} ${STAGEDIR}${PREFIX}/libexec/${DIST_SUBDIR}
+
+.include <bsd.port.mk>

Added: head/databases/sqlite-ext-pcre/distinfo
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/sqlite-ext-pcre/distinfo	Sun Aug 24 20:00:56 2014	(r366009)
@@ -0,0 +1,2 @@
+SHA256 (sqlite-ext/sqlite-ext-pcre-20100208.tar.gz) = 16faf92d820b29791347332537e7e7dfef59fcd884081cb54482242533982183
+SIZE (sqlite-ext/sqlite-ext-pcre-20100208.tar.gz) = 2423

Added: head/databases/sqlite-ext-pcre/pkg-descr
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/sqlite-ext-pcre/pkg-descr	Sun Aug 24 20:00:56 2014	(r366009)
@@ -0,0 +1,4 @@
+This is sqlite3-pcre, an extension for sqlite3 that uses libpcre to provide
+a regexp() function to use with the REGEXP operator.
+
+WWW: https://github.com/ralight/sqlite3-pcre

Added: head/databases/sqlite-ext-pcre/pkg-message
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/sqlite-ext-pcre/pkg-message	Sun Aug 24 20:00:56 2014	(r366009)
@@ -0,0 +1,11 @@
+*********************************************************************
+Loading extensions is by default prohibited as a security measure;
+see "Security Considerations" in
+http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions.
+
+If the sqlite3 program and library are built this way, you cannot
+use these functions from the program, you must write your own program
+using the sqlite3 API, and call sqlite3_enable_load_extension as
+described above, or else rebuild the sqlite3 program to allow
+loadable extensions.
+*********************************************************************