Xapian discuss - Jun 2009 - Deleting documents with scriptindex

Hey everone,

I can't seem to find an answer for this, or I'm going about it wrong. 
The situation is this, I use scriptindex on a dump of MySQL product data 
to update the Xapian database. The product catalog updates about once a 
month, wherein existing products can be updated or deleted and new 
products added. When I run scriptindex on the new catalog of product 
data, it reports how many where added/replaced/deleted. The deleted 
value is always 0, so products that have been removed from the catalog 
still remain in the database.

How can I delete these? It would be too tedious to find and specify each 
docID to delete. Would it be best to just delete the database and 
rebuild it for each product update?

Thanks for your help,
Jason

-- 
////////////////////////////////////
Jason Chapin
jason at roasted.org
508.654.8478 {mobile}

On Thu, Jun 18, 2009 at 11:24:14AM -0400, Jason Chapin
wrote:
> I can't seem to find an answer for this, or I'm going about it
wrong.
> The situation is this, I use scriptindex on a dump of MySQL product data 
> to update the Xapian database. The product catalog updates about once a 
> month, wherein existing products can be updated or deleted and new 
> products added.
If you feed scriptindex a record which only specifies a unique id then
it will remove any record with that unique id (documented in
scriptindex.html under the unique action).
> Would it be best to just delete the database and rebuild it for each
> product update?
That would work too.  If most products change then it's probably quicker
to just rebuild from scratch.

Cheers,
    Olly