[OPEN-ILS-DEV] Authority Record Linking script

[Dan Scott]

On Mon, May 16, 2011 at 04:32:21PM -0400, Mike Rylander wrote:
> On Mon, May 16, 2011 at 4:23 PM, Duimovich, George
> <George.Duimovich at nrcan-rncan.gc.ca> wrote:

<snip>

> > Question: How can I completely refresh / rebuild the "authority.full_rec"
> > table so that we have a clean table for "authority_control_fields.pl" to
> > use?
> >
> 
> You could, but you could instead just:
> 
> DELETE FROM authority.full_rec WHERE NOT EXISTS (SELECT id FROM
> authority.record_entry WHERE NOT DELETED AND authority.record_entry.id
> = authority.full_rec.record);
> 
> or similar.
> 
> However, it would probably be better to teach
> authority_control_fields.pl to ignore deleted authorities instead.

To pass the buck the the right wallet (?), that means we should teach
open-ils.search.authority.validate.tag.id_list to ignore deleted
authorities - which it probably should have done from day one.  Slowly
but surely we'll get there...