Date: Sun, 1 Sep 2002 18:50:04 -0700 (PDT) From: Gerhard =?iso-8859-1?Q?H=E4ring?= <gerhard.haering@gmx.de> To: freebsd-ports@FreeBSD.org Subject: Re: ports/40816: Port update: databases/sqlite Message-ID: <200209020150.g821o4Bd097193@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
The following reply was made to PR ports/40816; it has been noted by GNATS.
From: Gerhard =?iso-8859-1?Q?H=E4ring?= <gerhard.haering@gmx.de>
To: FreeBSD-gnats-submit@FreeBSD.org
Cc: "David W. Chapman Jr." <dwcjr@inethouston.net>
Subject: Re: ports/40816: Port update: databases/sqlite
Date: Mon, 2 Sep 2002 03:47:13 +0200
David, you were right that the port still had much room for improvement.
Here's a much improved version (updated, bugfixes, newer sqlite, Tcl
support). There's no overlap with the existing port, so I'm sending it
as a shell archive.
As for the naming, I named it sqlite2 this time, and not only so cvsup
won't overwrite it again ;-)
Seriously, I don't think anybody will want to use the 1.x version of
SQLite, so I'd recommend you change the port name back to "sqlite" and
replace the existing port with it.
If you want to keep the 1.x port, then I have no idea wether both can be
used in parallel. There doesn't seem to be a "conflicts" rule to add in
the Makefile that forbids installing both, is there? I just assume that
nobody installs both ports and still put the docs in .../sqlite.
Again, IMO the best solution is to just replace the existing port.
-- Gerhard
# 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:
#
# databases/sqlite2
# databases/sqlite2/files
# databases/sqlite2/files/example.tcl
# databases/sqlite2/files/patch-makefile
# databases/sqlite2/files/pkgIndex.tcl
# databases/sqlite2/Makefile
# databases/sqlite2/distinfo
# databases/sqlite2/pkg-comment
# databases/sqlite2/pkg-descr
# databases/sqlite2/pkg-plist
#
echo c - databases/sqlite2
mkdir -p databases/sqlite2 > /dev/null 2>&1
echo c - databases/sqlite2/files
mkdir -p databases/sqlite2/files > /dev/null 2>&1
echo x - databases/sqlite2/files/example.tcl
sed 's/^X//' >databases/sqlite2/files/example.tcl << 'END-of-databases/sqlite2/files/example.tcl'
Xpackage require sqlite
X
Xif {$argc!=2} {
X puts stderr "Usage: %s DATABASE SQL-STATEMENT"
X exit 1
X}
Xsqlite db [lindex $argv 0]
Xdb eval [lindex $argv 1] x {
X foreach v $x(*) {
X puts "$v = $x($v)"
X }
X puts ""
X}
Xdb close
END-of-databases/sqlite2/files/example.tcl
echo x - databases/sqlite2/files/patch-makefile
sed 's/^X//' >databases/sqlite2/files/patch-makefile << 'END-of-databases/sqlite2/files/patch-makefile'
Xdiff -r -C 3 ../sqlite.orig/Makefile.in ./Makefile.in
X*** ../sqlite.orig/Makefile.in Sat Aug 31 18:29:58 2002
X--- ./Makefile.in Mon Sep 2 00:51:27 2002
X***************
X*** 310,322 ****
X mkdir -p doc
X mv $(DOC) doc
X
X! install: sqlite libsqlite.la sqlite.h
X $(INSTALL) -d $(exec_prefix)/lib
X $(LIBTOOL) $(INSTALL) libsqlite.la $(exec_prefix)/lib
X $(INSTALL) -d $(exec_prefix)/bin
X $(LIBTOOL) $(INSTALL) sqlite $(exec_prefix)/bin
X $(INSTALL) -d $(prefix)/include
X $(INSTALL) -m 0644 sqlite.h $(prefix)/include
X
X clean:
X rm -f *.lo *.la *.o sqlite libsqlite.la sqlite.h
X--- 310,324 ----
X mkdir -p doc
X mv $(DOC) doc
X
X! install: sqlite libsqlite.la sqlite.h libtclsqlite.la
X $(INSTALL) -d $(exec_prefix)/lib
X $(LIBTOOL) $(INSTALL) libsqlite.la $(exec_prefix)/lib
X $(INSTALL) -d $(exec_prefix)/bin
X $(LIBTOOL) $(INSTALL) sqlite $(exec_prefix)/bin
X $(INSTALL) -d $(prefix)/include
X $(INSTALL) -m 0644 sqlite.h $(prefix)/include
X+ mkdir -p $(prefix)/lib/sqlite
X+ $(LIBTOOL) $(INSTALL) libtclsqlite.la $(prefix)/lib/sqlite
X
X clean:
X rm -f *.lo *.la *.o sqlite libsqlite.la sqlite.h
END-of-databases/sqlite2/files/patch-makefile
echo x - databases/sqlite2/files/pkgIndex.tcl
sed 's/^X//' >databases/sqlite2/files/pkgIndex.tcl << 'END-of-databases/sqlite2/files/pkgIndex.tcl'
Xpackage ifneeded sqlite 0.0 [list load [file join $dir libtclsqlite.so.0] sqlite]
END-of-databases/sqlite2/files/pkgIndex.tcl
echo x - databases/sqlite2/Makefile
sed 's/^X//' >databases/sqlite2/Makefile << 'END-of-databases/sqlite2/Makefile'
X# ex:ts=8
X# New ports collection makefile for: sqlite
X# Date created: Feb 21, 2001
X# Whom: Ying-Chieh Liao <ijliao@FreeBSD.org>
X#
X# $FreeBSD: ports/databases/sqlite/Makefile,v 1.7 2001/12/02 18:19:09 steve Exp $
X#
X
XPORTNAME= sqlite2
XPORTVERSION= 2.7.1
XCATEGORIES= databases
XMASTER_SITES= http://www.hwaci.com/sw/sqlite/
XDISTNAME= sqlite-${PORTVERSION}
X
XMAINTAINER= gerhard.haering@gmx.de
X
XLIB_DEPENDS= tcl${TCL_VER:S/.//}:${PORTSDIR}/lang/tcl${TCL_VER:S/.//}
XBUILD_DEPENDS=
X
XUSE_GMAKE= YES
XGNU_CONFIGURE= YES
XUSE_REINPLACE= YES
XCONFIGURE_ARGS= --prefix=${PREFIX} --with-hints=freebsd.hints
X
XWRKSRC= ${WRKDIR}/sqlite
XMAKE_ARGS+= TCLSH=tclsh${TCL_VER}
XMAKE_ENV+= TCL_VER=${TCL_VER}
XTCL_VER?= 8.3
X
XDOCFILES= arch.html arch.png c_interface.html changes.html \
X crosscompile.html download.html faq.html index.html \
X lang.html lemon.html mingw.html opcode.html report1.txt \
X speed.html sqlite.html tclsqlite.html vdbe.html
X
XDOCSDIR= ${PREFIX}/share/doc/sqlite
X
Xpost-patch:
X ${REINPLACE_CMD} -e "s/tclsh \$$(TOP)/\$$(TCLSH) \$$(TOP)/g" ${WRKSRC}/Makefile.in
X ${ECHO} "config_TARGET_TCL_INC=\"-I${PREFIX}/include/tcl${TCL_VER}\"" >${WRKSRC}/freebsd.hints
X ${ECHO} "config_TARGET_TCL_LIBS=\"-L${PREFIX}/lib -ltcl${TCL_VER:S/.//}\"" >>${WRKSRC}/freebsd.hints
X #${ECHO} "config_TARGET_CFLAGS=\"-DTHREADSAFE=1 -pthread\"" >>${WRKSRC}/freebsd.hints
X
Xpost-build:
X # Build the docs
X cd ${WRKSRC} && ${MAKE} ${MAKE_ARGS} doc
X
Xpost-install:
X ${INSTALL_DATA} ${FILESDIR}/pkgIndex.tcl ${PREFIX}/lib/sqlite/
X.if !defined(NOPORTDOCS)
X @${MKDIR} ${DOCSDIR}
X @${INSTALL_DATA} ${FILESDIR}/example.tcl ${DOCSDIR}
X.for file in ${DOCFILES}
X @${INSTALL_DATA} ${WRKSRC}/doc//${file} ${DOCSDIR}
X.endfor
X.endif
X
X.include <bsd.port.mk>
END-of-databases/sqlite2/Makefile
echo x - databases/sqlite2/distinfo
sed 's/^X//' >databases/sqlite2/distinfo << 'END-of-databases/sqlite2/distinfo'
XMD5 (sqlite-2.7.1.tar.gz) = 4910d3603365ab042cf78a1ec6304bb6
END-of-databases/sqlite2/distinfo
echo x - databases/sqlite2/pkg-comment
sed 's/^X//' >databases/sqlite2/pkg-comment << 'END-of-databases/sqlite2/pkg-comment'
XAn SQL database engine in a C library, including a Tcl wrapper
END-of-databases/sqlite2/pkg-comment
echo x - databases/sqlite2/pkg-descr
sed 's/^X//' >databases/sqlite2/pkg-descr << 'END-of-databases/sqlite2/pkg-descr'
XSQLite is an SQL database engine in a C library. Programs that link the SQLite
Xlibrary can have SQL database access without running a separate RDBMS process.
XThe distribution comes with a standalone command-line access program (sqlite)
Xthat can be used to administer an SQLite database and which serves as an
Xexample of how to use the SQLite library.
X
XWWW: http://www.hwaci.com/sw/sqlite/
END-of-databases/sqlite2/pkg-descr
echo x - databases/sqlite2/pkg-plist
sed 's/^X//' >databases/sqlite2/pkg-plist << 'END-of-databases/sqlite2/pkg-plist'
Xbin/sqlite
Xinclude/sqlite.h
Xlib/libsqlite.a
Xlib/libsqlite.la
Xlib/libsqlite.so
Xlib/libsqlite.so.0
Xlib/sqlite/libtclsqlite.so.0
Xlib/sqlite/libtclsqlite.so
Xlib/sqlite/libtclsqlite.la
Xlib/sqlite/libtclsqlite.a
Xlib/sqlite/pkgIndex.tcl
X@dirrm lib/sqlite
X%%PORTDOCS%%share/doc/sqlite/arch.html
X%%PORTDOCS%%share/doc/sqlite/arch.png
X%%PORTDOCS%%share/doc/sqlite/c_interface.html
X%%PORTDOCS%%share/doc/sqlite/changes.html
X%%PORTDOCS%%share/doc/sqlite/crosscompile.html
X%%PORTDOCS%%share/doc/sqlite/download.html
X%%PORTDOCS%%share/doc/sqlite/faq.html
X%%PORTDOCS%%share/doc/sqlite/index.html
X%%PORTDOCS%%share/doc/sqlite/lang.html
X%%PORTDOCS%%share/doc/sqlite/lemon.html
X%%PORTDOCS%%share/doc/sqlite/mingw.html
X%%PORTDOCS%%share/doc/sqlite/opcode.html
X%%PORTDOCS%%share/doc/sqlite/report1.txt
X%%PORTDOCS%%share/doc/sqlite/speed.html
X%%PORTDOCS%%share/doc/sqlite/sqlite.html
X%%PORTDOCS%%share/doc/sqlite/tclsqlite.html
X%%PORTDOCS%%share/doc/sqlite/vdbe.html
X%%PORTDOCS%%share/doc/sqlite/example.tcl
X%%PORTDOCS%%@dirrm share/doc/sqlite
END-of-databases/sqlite2/pkg-plist
exit
To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-ports" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200209020150.g821o4Bd097193>