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

Spike : Investigate approach for the ability to monitor rollover progress from PostgreSQL function

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P3
    • Resolution: Won't Do
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Template:
      Thunderjet/Firebird Back-end Story Template
    • Development Team:
      Thunderjet

      Description

      Purpose/Overview:
      Investigate approach for the ability to monitor rollover progress from PostgreSQL function

      Requirements/Scope:

      1. It should be possible retrieve rollover progress information from UI

      Approach:
      Looks like there is only one possibility retrieve progress of the function progress in the PostgreSQL and this is “autonomous transaction”
      The idea is to store information about the progress of operations inside a function in the separate table

      Examples : https://www.cybertec-postgresql.com/en/implementing-autonomous-transactions-in-postgres/?gclid=CjwKCAjwnef6BRAgEiwAgv8mQQ-F9pNxOljBRgerYb5pyEm_CKfxSIZR9JOPPjYVR8saCgnQsNXR-RoCPiwQAvD_BwE

      Acceptance criteria:

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases