Add Solr bib tracking table and test data / scripts
authorDan Scott <dan@coffeecode.net>
Sun, 4 Dec 2011 16:40:53 +0000 (11:40 -0500)
committerDan Scott <dscott@laurentian.ca>
Tue, 11 Sep 2012 13:00:22 +0000 (09:00 -0400)
commitd2a02ba389b42b7cbbfa4b5ee5e154cea4dbe745
tree813e4451f51f8df88a6f086b80a52b7e05e79d2a
parent68408e9067f9f66574833bd4c4b61200130f3298
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>
Open-ILS/src/extras/delete_stuff [new file with mode: 0755]
Open-ILS/src/extras/munge_title [new file with mode: 0755]
Open-ILS/src/sql/Pg/solr.sql [new file with mode: 0644]
Open-ILS/tests/datasets/jazz_100.sql [new file with mode: 0644]