Uploaded image for project: 'mod-finance-storage'
  1. mod-finance-storage
  2. MODFISTO-41

Data migration scripts for recent schema changes

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P3
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 4.0.0
    • Labels:
      None
    • Template:
    • Sprint:
      ACQ Sprint 73, ACQ Sprint 74, ACQ Sprint 75, ACQ Sprint 76
    • Story Points:
      5
    • Development Team:
      Thunderjet

      Description

      Overview

      As previously agreed, we will be providing data migration scripts for all breaking schema changes starting after the Q3.2 release. Since mod-finance-storage was not released in Q3.2 we need to provide these scripts.

      Once we "catch up" creation of these scripts will be part of the acceptance criteria of individual stories.

      Scope

      Approach

      See https://github.com/folio-org/raml-module-builder/blob/master/DB-schema-migration.md
      and
      https://wiki.folio.org/display/FOLIJET/Spike%3A+Investigate+data+migration+strategies

      NOTE: For now, testing locally (e.g. vagrant) is find for now since there isn't a long-lived hosted environment available for this type of testing.

      Acceptance Criteria

      • Data migration scripts exist for any/all breaking schema changes
      • Manual testing is done locally to verify that data is migrated to new schema(s) as expected

        TestRail: Results

          Attachments

          1. Migration Testing.postman_collection.json
            58 kB
          2. screenshot-1.png
            screenshot-1.png
            97 kB
          3. screenshot-2.png
            screenshot-2.png
            51 kB
          4. screenshot-4.png
            screenshot-4.png
            87 kB
          5. screenshot-5.png
            screenshot-5.png
            55 kB

            Issue Links

              Activity

                People

                Assignee:
                siarhei_hrabko Siarhei Hrabko
                Reporter:
                cmcnally Craig McNally
                Tester Assignee:
                Siarhei Hrabko Siarhei Hrabko
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases