Uploaded image for project: 'SAFe Program'
  1. SAFe Program
  2. SP-2531

Extend the ODA to connect to a real database

Change Owns to Parent OfsSet start and due date...
    XporterXMLWordPrintable

Details

    • Obs Mgt & Controls
    • Inter Program
    • 3
    • 3
    • 40
    • 13.333
    • Team_BUTTONS
    • Sprint 5
    • Hide
      • System Team have deployed an instance of a PostgreSQL DB into the STFC cluster
      • The ODA was updated to be able to work with a PostgreSQL DB
      • Storage into a PostgreSQL database via the ODA was demo'd by Thad on Thursday 18 August
      Show
      System Team have deployed an instance of a PostgreSQL DB into the STFC cluster The ODA was updated to be able to work with a PostgreSQL DB Storage into a PostgreSQL database via the ODA was demo'd by Thad on Thursday 18 August
    • 16.6
    • Stories Completed, Integrated, Solution Intent Updated, BDD Testing Passes (no errors), Outcomes Reviewed, NFRS met, Demonstrated, Satisfies Acceptance Criteria, Accepted by FO
    • PI23 - UNCOVERED

    • Team_BUTTONS

    Description

      1) Database Instance Creation and Deployment of PostgreSQL. This task includes following things: -
      a. System team to create an initial instance of PostgreSQL DB within Kubernetes
      b. Team Buttons to provide more information about the lifespan of persistent data for ODA
      c. Database replication, synchronization won’t be a priority for PI15
      d. DB provisioning (user creation, security) would be a shared task between the two teams. A defined number of
      users, roles( with given privileges) would be created by Team Buttons and seek for support from System team if
      needed.
      e. A plan for Database backup/restoration is in place

      2) A basic data model with limited entities, for eg. SB Definitions, SB Instances, Proposals, ExecBlocks, Observing Projects + Observing Blocks is in place. This won't be the final data model but at least the basic to define relations and cardinality between the above entities.

      3) We are able to load above entities with defined model using Psycopg adapter onto the ODA Database created by system team.

      4) Need to connect a rest service (the ODA) to that database deployment

      5) All the above points should be updated in the ODA lightweight documentation on confluence.

      Attachments

        Issue Links

          Structure

            Activity

              People

                a.bridger Bridger, Alan
                p.klaassen Klaassen, Pamela
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Feature Progress

                  Story Point Burn-up: (100.00%)

                  Feature Estimate: 3.0

                  IssuesStory Points
                  To Do00.0
                  In Progress   00.0
                  Complete932.0
                  Total932.0

                  Dates

                    Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel