munge schema

munge schema

Start a new utility schema called munge:

  The schema munge contains stored procedures used for maintaining
  an Evergreen database, including migration and data update
  routines.  Routines in munge will not necessarily have a
  user interface exposed in the Evergreen staff client or OPAC,
  and will typically be invoked from the command line.  However,
  other Evergreen application code is free to make use of munge.

First function is a utility to change a copy call number:

  munge.change_copy_call_number(copy_id, new_label);

  Change the call number label associated with the specified item,
  creating, relinking, and deleting volume records as needed.  The
  call number associated with any other items attached to the target
  item's original volume will remain unchanged.

  Accepts the following parameters:

  copy_id   - asset.copy.id of the copy to change
  new_label - new call number string

  The return value is a boolean indicating whether the copy call
  number was changed or not.

  This routine will refuse to touch or create located URIs.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>