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

Spike : Check that it is possible to apply business rollover logic to the selected PostgreSQL function-based approach

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P3
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Template:
      Thunderjet/Firebird Back-end Story Template
    • Sprint:
      ACQ Sprint 102
    • Story Points:
      13
    • Development Team:
      Thunderjet

      Description

      Purpose/Overview:

      1. Check that it is possible to apply business rollover logic to the selected PostgreSQL function-based approach.
      2. Created "budget_encumbrances_rollover.sql" will be used to implement the rollover flow.
      3. Created testing data will be used for integration tests.

      Requirements/Scope:

      1. The system after rollover must be in a consistent state. All budgets and encumbrances must be processed and as result rollover end successfully or with errors.

      Approach:
      Create PostgreSQL functions and test functions on different datasets:
      1. Must be done first in parallel

      • Create rollover testing data loading feature (Karate integration test preparation)
      • Create function for budget rollover "budget_encumbrances_rollover.sql"

      2. Must be done secondarily in parallel

      • Update function "budget_encumbrances_rollover.sql" with ongoing encumbrances rollover
      • Update function "budget_encumbrances_rollover.sql" with ongoing-subscription encumbrances rollover
      • Update function "budget_encumbrances_rollover.sql" with one-time encumbrances rollover

      Acceptance criteria:

      • Function created and tested

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Andrei_Makaranka Andrei Makaranka
                Reporter:
                Andrei_Makaranka Andrei Makaranka
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases