Date: Fri, 17 Dec 2004 14:01:34 -0500 From: "Dan Langille" <dan@langille.org> To: "Simon L. Nielsen" <simon@FreeBSD.org> Cc: freebsd-vuxml@freebsd.org Subject: Re: Do you respect the date_modified field? Message-ID: <41C2E6BE.14126.77DB8E3@localhost> In-Reply-To: <20041217185000.GB762@zaphod.nitro.dk> References: <41C2D30F.16142.730D56B@localhost>
next in thread | previous in thread | raw e-mail | index | archive | help
On 17 Dec 2004 at 19:50, Simon L. Nielsen wrote: > On 2004.12.17 12:37:35 -0500, Dan Langille wrote: > > At present, FreshPorts deletes all VuXML information each time a > > commit to ~/ports/security/vuxml/vuln.xml occurs. To reduce database > > churn, I'm now looking at optimizing this process. > > > > I expect the answer to my question to be yes, but do not want to rely > > upon only my expectation. Do you respect the date_modified field? > > In general yes, though of course there can be slips sometimes. Of > course, if FreshPorts starts to use the modified date I think it's > even more likely that modified date will be updated correctly since > people will notice if it wasn't bumped. That was my hope too. Sanity Checking(tm). > I almost always check my entries on FreshPorts after commit as an > extra check that I havn't made any mistakes in the committed entry... Is there something I could provide on FreshPorts webpage would make that check easier? I'm thinking of something similar to (for example) http://www.vuxml.org/freebsd/d47e9d19-5016-11d9-9b5f- 0050569f0001.html > > I ask for reasons of keeping things simple. FreshPorts inserts each > > vuln into a table. Is it sufficient for FreshPorts to compare the > > last_modified field as supplied in vuln.xml to determine whether or > > not it should update its information? > > Not quite that simple unfortunatly. Modified date is not updated when > an entry is modified the same day as when it was originally added, or > if the modified date already has been bumped once on the date of the > commit. So you need to update for all entries which has either > modification or entry date today... actually you probably need to take > entries from the date before and after also due to timezone's. But > that should still reduce the number of entries that must bed update > considerably. That's not much more work. -- Dan Langille : http://www.langille.org/ BSDCan - The Technical BSD Conference - http://www.bsdcan.org/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41C2E6BE.14126.77DB8E3>