[OPEN-ILS-DEV] Authority Record Linking script

[Mike Rylander]

On Mon, May 16, 2011 at 5:25 PM, Dan Scott <dan at coffeecode.net> wrote:
> 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...
>

Indeed, sir: e56a34254da634f34b9e43eaf3f80d6d80ef3f9f

-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / Your Library's Guide to Open Source
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com