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

Improve ways to populate publicationPeriod field

    XMLWordPrintable

Details

    • Falcon Sprint 125
    • 3
    • Falcon
    • R3 2021 Bug Fix
    • Cornell

    Description

      Overview:
      publicationPeriod field is a derived field and is populated based on the values of dateOfPublication field as described in MODINVSTOR-723 and MODINVSTOR-724 .

      During the upgrade process the script that populates publicationPeriod is executed and significantly slows down the upgrade (MODINVSTOR-774). To address the issue the existing implementation has been removed in https://github.com/folio-org/mod-inventory-storage/pull/676/files and the field needs to be populated manually (example: https://github.com/folio-org/mod-inventory-storage/blob/master/src/main/resources/templates/db_scripts/populatePublicationPeriod.sql ).

      This story is to cover other possible approach that will continue to populate publicationPeriod automatically without negatively impacting the migration process

      Acceptance criteria

      1. publicationPeriod is populated automatically
      2. Migration process for mod-inventory-storage is below 2hours on the bugfest data set (8M instance records)

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                OleksiiKuzminov Oleksii Kuzminov
                magdaz Magda Zacharska
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases