LP#1552861: add upgrade script user/jeffdavis/lp1552861_signoff
authorGalen Charlton <gmc@equinoxinitiative.org>
Wed, 10 May 2017 17:00:46 +0000 (10:00 -0700)
committerJeff Davis <jdavis@sitka.bclibraries.ca>
Wed, 10 May 2017 18:05:47 +0000 (11:05 -0700)
commit2a5b1becaa3c0a18fa4fedfa228fe9f331ae1306
tree503f01563f6465d3004dfb4ca5e8341570953c0d
parent885306532c3a49b3f24d2112780239459f46450e
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>
Open-ILS/src/sql/Pg/upgrade/XXXX.data.change_default_match_set_ous_type.sql [new file with mode: 0644]