Add Solr bib tracking table and test data / scripts
The solr.sql optional file creates a "solr" schema containing a single
table, solr.bib_updates, that tracks the bib records, the associate
libraries, and the time that INSERT / UPDATE / DELETE events occurred
that affect the visibility of a given bib record / library combination.
In addition, the "solr" role is granted only the privileges required for
selecting from the solr.bib_updates, actor.org_unit, asset.call_number,
and asset.copy tables.
jazz_100.sql is a simple import script for populating
biblio.record_entry, asset.call_number, and asset.copy with 100 records
relating to jazz music.
delete_stuff is a rough script that enables users to trigger DELETE
events by either deleting all of the call numbers attached to a given
record for a given library, or to delete a bib record directly. The goal
is to ensure that DELETE events are tracked appropriately in the
solr.bib_update table.
munge_title is a script that will replace one word with another in the
specified records, then update the record. The goal is to ensure that
UPDATE events that affect the content of the bib record are tracked
appropriate in the solr.bib_update table.
Thanks to Discovery Garden, Inc <http://discoverygarden.ca/> for
sponsoring this enhancement.
Signed-off-by: Dan Scott <dan@coffeecode.net>