ports/55649: New port: Replaces NULL MySQL Field with value from top records

[Aftab Jahan Subedar]

>Number:         55649
>Category:       ports
>Synopsis:       New port: Replaces NULL MySQL Field with value from top records
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Sat Aug 16 18:40:15 PDT 2003
>Closed-Date:
>Last-Modified:
>Originator:     Aftab Jahan Subedar
>Release:        FreeBSD 4.7-RELEASE-p10 i386
>Organization:
>Environment:
System: FreeBSD subedartech.sytes.net 4.7-RELEASE-p10 FreeBSD 4.7-RELEASE-p10 #3: Wed Jul 30 17:22:32 GMT 2003 jahan at subedartech.sytes.net:/usr/obj/usr/src/sys/SubedarTech i386


	
>Description:
        Replaces NULL column(s) with value from  last available column value
>How-To-Repeat:
	
>Fix:

	

--- mysql_last_value.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:
#
#	mysql_last_value
#	mysql_last_value/pkg-descr
#	mysql_last_value/pkg-plist
#	mysql_last_value/distinfo
#	mysql_last_value/Makefile
#
echo c - mysql_last_value
mkdir -p mysql_last_value > /dev/null 2>&1
echo x - mysql_last_value/pkg-descr
sed 's/^X//' >mysql_last_value/pkg-descr << 'END-of-mysql_last_value/pkg-descr'
Xmysql_last_value() replace null value of column from row above the current row.
XIts like "same as above".
X
XWWW: http://www.geocities.com/jahan.geo
X
X-Aftab Jahan Subedar
Xjahan at bol-online.com jahan at geocities.com
END-of-mysql_last_value/pkg-descr
echo x - mysql_last_value/pkg-plist
sed 's/^X//' >mysql_last_value/pkg-plist << 'END-of-mysql_last_value/pkg-plist'
Xbin/mysql_last_value
END-of-mysql_last_value/pkg-plist
echo x - mysql_last_value/distinfo
sed 's/^X//' >mysql_last_value/distinfo << 'END-of-mysql_last_value/distinfo'
XMD5 (mysql_last_value-3.2.tar.gz) = 5e079427683e11f3edbde6e02913518e
END-of-mysql_last_value/distinfo
echo x - mysql_last_value/Makefile
sed 's/^X//' >mysql_last_value/Makefile << 'END-of-mysql_last_value/Makefile'
X# New ports collection makefile for:	mysql_last_value
X# Date created:			14th Aug 2003
X# Whom:	                        Aftab Jahan Subedar
X# $FreeBSD$
X
XPORTNAME=       mysql_last_value
XPORTVERSION=    3.2
XCATEGORIES=	databases
XMASTER_SITES=   http://www.geocities.com/jahan.geo/
X
XMAINTAINER=	jahan at bol-online.com
XCOMMENT=Replaces NULL value of current column with value from top row
X
XLIB_DEPENDS=	mysqlclient.14:${PORTSDIR}/databases/mysql41-client
X
Xdo-install:
X	${INSTALL_SCRIPT} ${WRKSRC}/mysql_last_value ${PREFIX}/bin
X
X.include <bsd.port.mk>
END-of-mysql_last_value/Makefile
exit
--- mysql_last_value.shar ends here ---


>Release-Note:
>Audit-Trail:
>Unformatted: