Date: Thu, 22 May 2014 15:21:18 -0400 From: Vivek Khera <vivek@khera.org> To: FreeBSD-gnats-submit@freebsd.org Subject: ports/190121: new port databases/sqlite-ext-pcre Message-ID: <1400786478.377269.35267.nullmailer@sandbox.int.kcilink.com> Resent-Message-ID: <201405221930.s4MJU0Y8023624@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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 <vivek@khera.org> 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 <bsd.port.mk> 464ef7c6571951809b23e262cbe26e19 exit >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1400786478.377269.35267.nullmailer>