From owner-freebsd-ports Sun Sep 1 18:50:55 2002 Delivered-To: freebsd-ports@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.FreeBSD.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6651437B401 for ; Sun, 1 Sep 2002 18:50:05 -0700 (PDT) Received: from freefall.freebsd.org (freefall.FreeBSD.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id EC4B943E65 for ; Sun, 1 Sep 2002 18:50:04 -0700 (PDT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.12.4/8.12.4) with ESMTP id g821o4JU097194 for ; Sun, 1 Sep 2002 18:50:04 -0700 (PDT) (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.12.4/8.12.4/Submit) id g821o4Bd097193; Sun, 1 Sep 2002 18:50:04 -0700 (PDT) Date: Sun, 1 Sep 2002 18:50:04 -0700 (PDT) Message-Id: <200209020150.g821o4Bd097193@freefall.freebsd.org> To: freebsd-ports@FreeBSD.org Cc: From: Gerhard =?iso-8859-1?Q?H=E4ring?= Subject: Re: ports/40816: Port update: databases/sqlite Reply-To: Gerhard =?iso-8859-1?Q?H=E4ring?= Sender: owner-freebsd-ports@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org The following reply was made to PR ports/40816; it has been noted by GNATS. From: Gerhard =?iso-8859-1?Q?H=E4ring?= To: FreeBSD-gnats-submit@FreeBSD.org Cc: "David W. Chapman Jr." 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 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 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