From owner-freebsd-ports-bugs@FreeBSD.ORG Thu May 22 19:30:00 2014 Return-Path: Delivered-To: freebsd-ports-bugs@smarthost.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id E7158A05 for ; Thu, 22 May 2014 19:30:00 +0000 (UTC) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:1900:2254:206c::16:87]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id C2B5322DF for ; Thu, 22 May 2014 19:30:00 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.8/8.14.8) with ESMTP id s4MJU0jG023639 for ; Thu, 22 May 2014 19:30:00 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.8/8.14.8/Submit) id s4MJU0Y8023624; Thu, 22 May 2014 19:30:00 GMT (envelope-from gnats) Resent-Date: Thu, 22 May 2014 19:30:00 GMT Resent-Message-Id: <201405221930.s4MJU0Y8023624@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Vivek Khera Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 1C1B8514 for ; Thu, 22 May 2014 19:21:22 +0000 (UTC) Received: from yertle.kcilink.com (yertle-comcast.kcilink.com [74.92.149.58]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id DF5D021FB for ; Thu, 22 May 2014 19:21:20 +0000 (UTC) Received: from sandbox.int.kcilink.com (sandbox.int.kcilink.com [192.168.7.23]) by yertle.kcilink.com (Postfix) with SMTP id 6E01A8A036 for ; Thu, 22 May 2014 15:21:18 -0400 (EDT) Received: (nullmailer pid 37440 invoked by uid 120); Thu, 22 May 2014 19:21:18 -0000 Message-Id: <1400786478.377269.35267.nullmailer@sandbox.int.kcilink.com> Date: Thu, 22 May 2014 15:21:18 -0400 From: Vivek Khera Reply-To: Vivek Khera To: FreeBSD-gnats-submit@freebsd.org X-Send-Pr-Version: 3.113 Subject: ports/190121: new port databases/sqlite-ext-pcre X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 22 May 2014 19:30:01 -0000 >Number: 190121 >Category: ports >Synopsis: new port databases/sqlite-ext-pcre >Confidential: no >Severity: non-critical >Priority: medium >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Thu May 22 19:30:00 UTC 2014 >Closed-Date: >Last-Modified: >Originator: Vivek Khera >Release: FreeBSD 9.1-RELEASE amd64 >Organization: >Environment: System: FreeBSD sandbox.int.kcilink.com 9.1-RELEASE FreeBSD 9.1-RELEASE #0 r243864: Tue Dec 4 12:09:48 EST 2012 khera@yertle.int.kcilink.com:/usr/obj/u/yertle1/sources/usr9/src/sys/KCI64 amd64 >Description: New port to install an SQLite extension that provides a regexp() function based on the PCRE library. This is installed from the github repo. As there are no tags, I set the version to be the date of the most recent commit. I do not know if this is the best way to number it. I based this on the sqlite-ext-miscfuncs port. >How-To-Repeat: n/a >Fix: # 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: # # . # ./pkg-message # ./pkg-descr # ./files # ./files/README.in # ./distinfo # ./Makefile # echo c - . mkdir -p . > /dev/null 2>&1 echo x - ./pkg-message sed 's/^X//' >./pkg-message << '9f51c313804c544b8024c5640d645b0a' X********************************************************************* XLoading extensions is by default prohibited as a security measure; Xsee "Security Considerations" in Xhttp://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions. X XIf the sqlite3 program and library are built this way, you cannot Xuse these functions from the program, you must write your own program Xusing the sqlite3 API, and call sqlite3_enable_load_extension as Xdescribed above, or else rebuild the sqlite3 program to allow Xloadable extensions. X********************************************************************* 9f51c313804c544b8024c5640d645b0a echo x - ./pkg-descr sed 's/^X//' >./pkg-descr << '0e313719ff012ceaf97a028d51caa8f5' XThis is sqlite3-pcre, an extension for sqlite3 that uses libpcre to provide Xa regexp() function to use with the REGEXP operator. X XWWW: https://github.com/ralight/sqlite3-pcre 0e313719ff012ceaf97a028d51caa8f5 echo c - ./files mkdir -p ./files > /dev/null 2>&1 echo x - ./files/README.in sed 's/^X//' >./files/README.in << 'be9a6b44f25606e098c892d386c18209' XUsage instructions for applications calling the sqlite3 API functions: X X In your application, call sqlite3_enable_load_extension(db,1) to X allow loading external libraries. Then load the library X %%LIBFILE%% using sqlite3_load_extension; the third argument X should be 0. See http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions. X Select statements may now use the regexp function, as in: X X SELECT 'foo-bar' REGEXP 'foo-\w+$'; X X XUsage instructions for the sqlite3 program: X X If the program is built so that loading extensions is permitted, X the following will work: X X sqlite> .load %%LIBFILE%% X sqlite> select 'foo-bar' regexp 'foo-\w+$'; X 1 X X Note: Loading extensions is by default prohibited as a X security measure; see "Security Considerations" in X http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions. X X If the sqlite3 program and library are built this X way, you cannot use these functions from the program, you X must write your own program using the sqlite3 API, and call X sqlite3_enable_load_extension as described above, or else X rebuild the sqlite3 program to allow loadable extensions. be9a6b44f25606e098c892d386c18209 echo x - ./distinfo sed 's/^X//' >./distinfo << 'aec8793adfd5b7c3f00e62ae41a09ac2' XSHA256 (sqlite-ext/sqlite-ext-pcre-20100208.tar.gz) = 16faf92d820b29791347332537e7e7dfef59fcd884081cb54482242533982183 XSIZE (sqlite-ext/sqlite-ext-pcre-20100208.tar.gz) = 2423 aec8793adfd5b7c3f00e62ae41a09ac2 echo x - ./Makefile sed 's/^X//' >./Makefile << '464ef7c6571951809b23e262cbe26e19' X# Created by: Vick Khera X# $FreeBSD: $ X XPORTNAME= sqlite-ext-pcre XPORTVERSION= 20100208 XCATEGORIES= databases X XMAINTAINER= vivek@khera.org XCOMMENT= regexp function for SQLite based on PCRE library X XLIB_DEPENDS= libpcre.so:${PORTSDIR}/devel/pcre X XUSE_SQLITE= yes XDIST_SUBDIR= sqlite-ext X XLIBFILE= pcre.so XINST_DIR= ${PREFIX}/libexec/${DIST_SUBDIR} XUSE_LDCONFIG= ${INST_DIR} X XSUB_FILES= ${PORTDOCS} XSUB_LIST+= LIBFILE=${LIBFILE} X XPLIST_DIRS= libexec/${DIST_SUBDIR} XPLIST_FILES= ${PLIST_DIRS}/${LIBFILE} X XPORTDOCS= README X XUSES= gmake X XUSE_GITHUB= yes XGH_ACCOUNT= ralight XGH_PROJECT= sqlite3-pcre XGH_COMMIT= c98da41 XGH_TAGNAME= ${GH_COMMIT} X X Xdo-build: X @cd ${WRKSRC} && ${GMAKE} X Xdo-install: X @${MKDIR} ${STAGEDIR}${PREFIX}/libexec/${DIST_SUBDIR} X @${INSTALL_PROGRAM} ${WRKSRC}/${LIBFILE} ${STAGEDIR}${PREFIX}/libexec/${DIST_SUBDIR} X Xpost-install: X.if !defined(NOPORTDOCS) X @${INSTALL} -d ${STAGEDIR}${DOCSDIR} X @${CP} ${WRKDIR}/${PORTDOCS} ${STAGEDIR}${DOCSDIR} X.endif X X.include 464ef7c6571951809b23e262cbe26e19 exit >Release-Note: >Audit-Trail: >Unformatted: