ports/137295: [NEW PORT] databases/sqlite-ext-inet: Library will provide the ipv4 functions in SQL queries

[Pavel I Volkov]

>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 at 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 at 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: