From owner-freebsd-ports@FreeBSD.ORG  Wed Aug 25 20:12:25 2004
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
Delivered-To: freebsd-ports@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP
	id 087D716A4CE; Wed, 25 Aug 2004 20:12:25 +0000 (GMT)
Received: from bast.unixathome.org (bast.unixathome.org [66.11.174.150])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id D25ED43D46; Wed, 25 Aug 2004 20:12:24 +0000 (GMT)
	(envelope-from dan@langille.org)
Received: from wocker (wocker.unixathome.org [192.168.0.99])
	by bast.unixathome.org (Postfix) with ESMTP
	id 445BC3D3D; Wed, 25 Aug 2004 16:12:24 -0400 (EDT)
From: "Dan Langille" <dan@langille.org>
To: Jacques Vidrine <nectar@FreeBSD.org>
Date: Wed, 25 Aug 2004 16:12:24 -0400
MIME-Version: 1.0
Message-ID: <412CBA68.15997.61E6A50@localhost>
Priority: normal
In-reply-to: <CDBB0430-F6C8-11D8-9236-000A95BC6FAE@FreeBSD.org>
References: <412B7D29.31547.1472F80@localhost>
X-mailer: Pegasus Mail for Windows (v4.12a)
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Content-description: Mail message body
cc: ports@freebsd.org
cc: freebsd-vuxml@freebsd.org
Subject: Re: database tables for VuXML
X-BeenThere: freebsd-ports@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 25 Aug 2004 20:12:25 -0000

On 25 Aug 2004 at 13:58, Jacques Vidrine wrote:

> > FreshPorts stores PORTVERSION and PORTREVISION as separate text
> > fields.  I take it that the ranges equations should compare only
> > PORTVERSION and ignore PORTREVISION.
> 
> One can think a version number as a tuple as follows (most significant 
> first):  (PORTEPOCH, PORTVERSION, PORTREVISION).  Comparisons are done 
> on these tuples.

Oh, PORTEPOCH is first?  Why?  Shouldn't it be last?  Here is the 
value forumula from bsd.port.mk

PKGNAME=        ${PKGNAMEPREFIX}${PORTNAME}${PKGNAMESUFFIX}-
${PORTVERSION:C/[-_,]/./g}${_SUF1}${_SUF2}

where _SUF2=  ,${PORTEPOCH}

> > My plan is to populate empty the vuxml_* tables each time there is a
> > commit to the data file.  This keeps the vuxml system totally
> > separate from FreshPorts.
> >
> > Each row under Commit History (e.g.
> > http://beta.freshports.org/sysutils/bacula/) relates to a row from
> > the commit_log_ports table.  That looks something like this:
> >
> > create table commit_log_ports
> > (
> >     commit_log_id      integer               not null,
> >     port_id            integer               not null,
> >     needs_refresh      smallint              not null,
> >     port_version       text                          ,
> >     port_revision      text                          ,
> >     primary key (commit_log_id, port_id)
> > );
> 
> You'll need a `port_epoch' here as well.  So these get created as 
> commits "come in"?

Yes, for each commit, a row is added to the commit_log table.  For 
each port in a commit, a row is added to the commit_log_ports table.

In addition to PORTEPOCH, I think I need to add:

   NO_LATEST_LINK
   NO_PACKAGE

I may also want to add PKGNAME
-- 
Dan Langille : http://www.langille.org/