LP#1552861: add upgrade script user/gmcharlt/lp1552861_signoff
authorGalen Charlton <gmc@equinoxinitiative.org>
Wed, 10 May 2017 13:33:00 +0000 (09:33 -0400)
committerGalen Charlton <gmc@equinoxinitiative.org>
Wed, 10 May 2017 13:33:00 +0000 (09:33 -0400)
commitc40982ee3a6be27192fef86fa2845d569887f44d
tree6262c3a7eca5b6911f62588ffd9f0faaf9978ae7
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>
Open-ILS/src/sql/Pg/upgrade/XXXX.data.change_default_match_set_ous_type.sql [new file with mode: 0644]