Date: Fri, 31 Jul 2009 12:53:51 +0400 (MSD) From: Pavel I Volkov <pol@iib.ru> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/137295: [NEW PORT] databases/sqlite-ext-inet: Library will provide the ipv4 functions in SQL queries Message-ID: <200907310853.n6V8rprk072323@pol.iib.ru> Resent-Message-ID: <200907310910.n6V9A1Pj009749@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 137295 >Category: ports >Synopsis: [NEW PORT] databases/sqlite-ext-inet: Library will provide the ipv4 functions in SQL queries >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Fri Jul 31 09:10:01 UTC 2009 >Closed-Date: >Last-Modified: >Originator: Pavel I Volkov >Release: FreeBSD 7.2-STABLE i386 >Organization: >Environment: System: FreeBSD pol.iib.ru 7.2-STABLE FreeBSD 7.2-STABLE #364: Mon Jul 20 13:50:36 MSD 2009 >Description: This library will provide the ipv4 ISINNET, IP2INT, INT2IP, NETFROM, NETLENGTH, NETMASKLENGTH functions in SQL queries. WWW: http://mobigroup.ru/files/sqlite-ext/inet/ Generated with FreeBSD Port Tools 0.77 >How-To-Repeat: >Fix: --- sqlite-ext-inet-1.0.shar begins here --- # 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: # # sqlite-ext-inet # sqlite-ext-inet/files # sqlite-ext-inet/files/patch-ipv4-ext.c # sqlite-ext-inet/Makefile # sqlite-ext-inet/pkg-descr # sqlite-ext-inet/distinfo # echo c - sqlite-ext-inet mkdir -p sqlite-ext-inet > /dev/null 2>&1 echo c - sqlite-ext-inet/files mkdir -p sqlite-ext-inet/files > /dev/null 2>&1 echo x - sqlite-ext-inet/files/patch-ipv4-ext.c sed 's/^X//' >sqlite-ext-inet/files/patch-ipv4-ext.c << '672d03e037a93b806f61c49d940e6bdb' X--- ipv4-ext.c.orig 2009-07-30 17:21:45.000000000 +0400 X+++ ipv4-ext.c 2009-07-30 17:22:19.000000000 +0400 X@@ -355,6 +355,7 @@ X X #include <stdlib.h> X #include <sys/types.h> X+#include <sys/socket.h> X #include <string.h> X #include <arpa/inet.h> X #include <stdio.h> 672d03e037a93b806f61c49d940e6bdb echo x - sqlite-ext-inet/Makefile sed 's/^X//' >sqlite-ext-inet/Makefile << 'a907cf69ad56b50d8fa35254544efa3a' X# New ports collection makefile for: sqlite-ext/inet X# Date created: 30 Jul 2009 X# Whom: "Pavel Volkov" <pol@iib.ru> X# X# $FreeBSD$ X# X XPORTNAME= sqlite-ext-inet XPORTVERSION= 1.0 XCATEGORIES= databases XMASTER_SITES= http://mobigroup.ru/files/sqlite-ext/inet/ XDISTFILES= ipv4-ext.c ipv4-ext.sql X XMAINTAINER= pol@iib.ru XCOMMENT= Library will provide the ipv4 functions in SQL queries X XUSE_SQLITE= yes X XDIST_SUBDIR= sqlite-ext XNO_WRKSUBDIR= yes X XEXTRACT_CMD= ${CP} XEXTRACT_BEFORE_ARGS= XEXTRACT_AFTER_ARGS= ${WRKSRC}/ X XPLIST_FILES= libexec/${DIST_SUBDIR}/libsqliteipv4.so XPLIST_DIRS= libexec/${DIST_SUBDIR} X.if !defined(NOPORTDOCS) XPLIST_FILES+= %%DATADIR%%/ipv4-ext.sql %%DATADIR%%/README.txt XPLIST_DIRS+= %%DATADIR%% X.endif X XCFLAGS+= -I${PREFIX}/include -fPIC -lm -shared X Xdo-build: X cd ${WRKSRC} && \ X ${CC} ${CFLAGS} ipv4-ext.c -o libsqliteipv4.so X Xdo-install: X ${MKDIR} ${PREFIX}/libexec/${DIST_SUBDIR} X ${INSTALL_PROGRAM} ${WRKSRC}/libsqliteipv4.so ${PREFIX}/libexec/${DIST_SUBDIR} X.if !defined(NOPORTDOCS) X ${MKDIR} ${DATADIR} X ${INSTALL_DATA} ${WRKSRC}/ipv4-ext.sql ${DATADIR} X ${SED} '/\/\*/d;/\*\//,$$d' ${WRKSRC}/ipv4-ext.c > ${WRKSRC}/README.txt X ${INSTALL_DATA} ${WRKSRC}/README.txt ${DATADIR} X.endif X X.include <bsd.port.mk> a907cf69ad56b50d8fa35254544efa3a echo x - sqlite-ext-inet/pkg-descr sed 's/^X//' >sqlite-ext-inet/pkg-descr << 'eac9edd8c70b91fd5fa523fe4b082694' XThis library will provide the ipv4 ISINNET, IP2INT, INT2IP, XNETFROM, NETLENGTH, NETMASKLENGTH functions in SQL queries. X XWWW: http://mobigroup.ru/files/sqlite-ext/inet/ eac9edd8c70b91fd5fa523fe4b082694 echo x - sqlite-ext-inet/distinfo sed 's/^X//' >sqlite-ext-inet/distinfo << 'b51fbead654d19ba16243845ba93c426' XMD5 (sqlite-ext/ipv4-ext.c) = 245c1631d97cb4269b2b29a98ee7cb07 XSHA256 (sqlite-ext/ipv4-ext.c) = 0047e3bd133bfa9d26b96f0e923831e7515c650e9cef02b01a243c97d0dd9a24 XSIZE (sqlite-ext/ipv4-ext.c) = 32211 XMD5 (sqlite-ext/ipv4-ext.sql) = ef158590886064a18f008c6ff8988237 XSHA256 (sqlite-ext/ipv4-ext.sql) = 0bbd2c08e26f7712decd598d51f2a2daa8ad36cb969ca310a50f3ebc1564e8b1 XSIZE (sqlite-ext/ipv4-ext.sql) = 6844 b51fbead654d19ba16243845ba93c426 exit --- sqlite-ext-inet-1.0.shar ends here --- >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200907310853.n6V8rprk072323>