Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 6 May 2016 14:59:36 +0000 (UTC)
From:      Kurt Jaeger <pi@FreeBSD.org>
To:        ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org
Subject:   svn commit: r414708 - in head/databases: . sqlite-ext-spellfix
Message-ID:  <201605061459.u46Exa7P095489@repo.freebsd.org>

next in thread | raw e-mail | index | archive | help
Author: pi
Date: Fri May  6 14:59:36 2016
New Revision: 414708
URL: https://svnweb.freebsd.org/changeset/ports/414708

Log:
  New port: databases/sqlite-ext-spellfix
  
  This module implements the spellfix1 VIRTUAL TABLE that can be used
  to search a large vocabulary for close matches using Levenshtein distance.
  
  Virtual table:
  
    spellfix1
  
  Functions:
  
    editdist, editdist3, spellfix1_translit, spellfix1_phonehash,
    spellfix1_scriptcode
  
  WWW: http://www.sqlite.org/spellfix1.html
  
  PR:		203217
  Submitted by:	Yuri <yuri@rawbw.com>

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

Modified: head/databases/Makefile
==============================================================================
--- head/databases/Makefile	Fri May  6 14:39:59 2016	(r414707)
+++ head/databases/Makefile	Fri May  6 14:59:36 2016	(r414708)
@@ -937,6 +937,7 @@
     SUBDIR += sqldeveloper
     SUBDIR += sqlite-ext-miscfuncs
     SUBDIR += sqlite-ext-pcre
+    SUBDIR += sqlite-ext-spellfix
     SUBDIR += sqlite2
     SUBDIR += sqlite3
     SUBDIR += sqlitebrowser

Added: head/databases/sqlite-ext-spellfix/Makefile
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/sqlite-ext-spellfix/Makefile	Fri May  6 14:59:36 2016	(r414708)
@@ -0,0 +1,40 @@
+# Created by: Yuri Victorovich <yuri@rawbw.com>
+# $FreeBSD$
+
+PORTNAME=	sqlite-ext-spellfix
+PORTVERSION=	3.8.11.1
+CATEGORIES=	databases
+MASTER_SITES=	https://www.sqlite.org/2015/ http://www2.sqlite.org/2015/ http://www3.sqlite.org/2015/
+DISTNAME=	sqlite-src-${PORTVERSION:S|8.|8|:S|.|0|g}
+DIST_SUBDIR=	sqlite-ext
+
+MAINTAINER=	yuri@rawbw.com
+COMMENT=	Search large vocabulary for close matches for SQLite
+
+LICENSE=	public
+LICENSE_NAME=	Public Domain
+LICENSE_TEXT=	Description of the license can be obtained from the following URL: http://www.sqlite.org/copyright.html
+LICENSE_PERMS=	dist-mirror dist-sell pkg-mirror pkg-sell auto-accept
+
+USES=		sqlite:3 zip
+NO_WRKSUBDIR=	yes
+
+SRCFILE=	${DISTNAME}/ext/misc/spellfix.c
+LIBFILE=	libspellfix.so
+INST_DIR=	${PREFIX}/libexec/${DIST_SUBDIR}
+USE_LDCONFIG=	${INST_DIR}
+
+EXTRACT_AFTER_ARGS=	${SRCFILE}
+
+PLIST_FILES=	libexec/${DIST_SUBDIR}/${LIBFILE}
+
+CFLAGS+=	-I${PREFIX}/include -fPIC -shared
+
+do-build:
+	@cd ${WRKSRC} && ${CC} ${CFLAGS} ${SRCFILE} -o ${LIBFILE}
+
+do-install:
+	${INSTALL} -d ${STAGEDIR}${PREFIX}/libexec/${DIST_SUBDIR}
+	${INSTALL_PROGRAM} ${WRKSRC}/${LIBFILE} ${STAGEDIR}${INST_DIR}
+
+.include <bsd.port.mk>

Added: head/databases/sqlite-ext-spellfix/distinfo
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/sqlite-ext-spellfix/distinfo	Fri May  6 14:59:36 2016	(r414708)
@@ -0,0 +1,2 @@
+SHA256 (sqlite-ext/sqlite-src-3081101.zip) = 261ad454663f66fda6101b278bb7b3931cf01884deefbf4ea6b152f83a624662
+SIZE (sqlite-ext/sqlite-src-3081101.zip) = 9057103

Added: head/databases/sqlite-ext-spellfix/pkg-descr
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/sqlite-ext-spellfix/pkg-descr	Fri May  6 14:59:36 2016	(r414708)
@@ -0,0 +1,13 @@
+This module implements the spellfix1 VIRTUAL TABLE that can be used
+to search a large vocabulary for close matches using Levenshtein distance.
+
+Virtual table:
+
+  spellfix1
+
+Functions:
+
+  editdist, editdist3, spellfix1_translit, spellfix1_phonehash,
+  spellfix1_scriptcode
+
+WWW: http://www.sqlite.org/spellfix1.html

Added: head/databases/sqlite-ext-spellfix/pkg-message
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/sqlite-ext-spellfix/pkg-message	Fri May  6 14:59:36 2016	(r414708)
@@ -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 rebuilt the sqlite3 program to allow
+loadable extensions.
+*********************************************************************



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201605061459.u46Exa7P095489>