LP#1552861: add upgrade script
authorGalen Charlton <gmc@equinoxinitiative.org>
Wed, 10 May 2017 17:00:46 +0000 (10:00 -0700)
committerGalen Charlton <gmc@equinoxinitiative.org>
Mon, 15 May 2017 21:02:09 +0000 (17:02 -0400)
commita4d2abbe480bb86495a52b382f1f587fcf64a060
tree745a7ba9bd4f83dde8a406adc2d5ffaf0c78e0c8
parent3434400baf0a3cca76c5c36ed787bac97dd80ebb
LP#1552861: add upgrade script

Also, a test plan for the fix:

[1] Set the vandelay.default_match_set setting for several
    org units. In at least one case, set it to the ID
    of a valid vandelay.match_set entry; in another case,
    set it to a numeric ID that doesn't match any existing
    vms rows; and finally, in another case set it to the
    name of a match set.
[2] Apply the patch and run the database update. Verify that
    the update script will indicate that there are invalid
    settings, then delete.
[3] Open the library settings editor and verify that in the
    case where a valid match set was used, the editor provides
    a drop-down with possible vms values with the correct
    one selected.

Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Signed-off-by: Jeff Davis <jdavis@sitka.bclibraries.ca>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Open-ILS/src/sql/Pg/upgrade/XXXX.data.change_default_match_set_ous_type.sql [new file with mode: 0644]