Data migration scripts for schema changes

Description

Overview

MODFISTO-90 renames invoice_transaction_summary.numEncumbrances to invoice_transaction_summary.numPendingPayments. We would have to write scripts to migrate the data:

  • rename numEncumbrances to numPendingPayments in every invoice_transaction_summary record

  • numPendingPayments value must be equal to numPaymentsCredits

Acceptance Criteria

  • Migration scripts are written and tested

Environment

None

Potential Workaround

None

Attachments

2

Checklist

hide

TestRail: Results

Activity

Show:

Andrei MakarankaJune 8, 2020 at 8:02 AM
Edited

Verified using postman collection

and release-core vagrant box
Logs :

Aliaksandr PautauJune 5, 2020 at 1:43 PM

Verified using postman collection on release-core vagrant box:

Done

Details

Assignee

Reporter

Tester Assignee

Priority

Story Points

Sprint

Development Team

Thunderjet

Fix versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created May 8, 2020 at 7:28 AM
Updated July 31, 2020 at 11:52 AM
Resolved June 8, 2020 at 8:02 AM
TestRail: Cases
TestRail: Runs