Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-722

Remove update effective location database functions

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P3
    • Resolution: Done
    • None
    • 22.0.0
    • None
    • Prokopovych - Sprint 114, Prokopovych - Sprint 115, Prokopovych - Sprint 116, Prokopovych - Sprint 117, Prokopovych - Sprint 118, Prokopovych - Sprint 119, Prokopovych - Sprint 120, Prokopovych - Sprint 121, Prokopovych - Sprint 122
    • 3
    • Prokopovych

    Description

      Overview:
      The following issue is observed in bugfest-iris.folio.ebsco.com environment.

      Functions update_effective_location_on_holding_update () and update_effective_location_on_item_update () are both present in bugfest iris db

      Bugfest-iris was updated from mod-inventory-storage-19.4.4 to mod-inventory-storage-20.2.1

      We compared db schema to a cleanly installed Iris environment db schema (environment was not upgraded)

      These functions do not exist in the cleanly installed environment

      Migration scripts should be put in place for cleanup of no longer needed functions.

      looks like triggers were removed but trigger functions still remain
      https://github.com/folio-org/mod-inventory-storage/blob/v20.2.1/src/main/resources/templates/db_scripts/dropLegacyItemEffectiveLocationTriggers.sql

      Expected Results:
      Functions update_effective_location_on_holding_update () and update_effective_location_on_item_update () are removed as part of module upgrade
      Actual Results:
      Functions are present in upgraded environment
      Additional Information:
      URL:
      Interested parties:

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                felkerk Kyle Felker
                cgodfrey Carole Godfrey
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases