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

Add query support to ODA

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

Details

    • Obs Mgt & Controls
    • Hide

      The ability to query the ODA allows users to easily find and retrieve existing SBs which meet their observational needs without having to either inspect all existing SBs or create new/duplicate ones. This increases productivity.

      Show
      The ability to query the ODA allows users to easily find and retrieve existing SBs which meet their observational needs without having to either inspect all existing SBs or create new/duplicate ones. This increases productivity.
    • Hide
      • It is possible to query the ODA for Scheduling blocks based on an SB ID/name.
      • It is possible to query the ODA for 'typical' SB parameters e.g. target/source name, observing band. and return all matching SBs
      • A command line tool is available to query the ODA.
      Show
      It is possible to query the ODA for Scheduling blocks based on an SB ID/name. It is possible to query the ODA for 'typical' SB parameters e.g. target/source name, observing band. and return all matching SBs A command line tool is available to query the ODA.
    • 3
    • 3
    • 20
    • 6.667
    • Team_BUTTONS
    • Sprint 5
    • Hide
      • Query end-points have been added to the ODA's API which allow the various defined entities (SBDs, SBIs, EBs and Projects) to be queried
      • Various query methods have been defined: user name (also partial matches), as well as creation and last-modified dates. The last both come in 'before' and 'after' varieties
      • A command-line interface has been added to the ODA which allows a user to query the ODA.
      Show
      Query end-points have been added to the ODA's API which allow the various defined entities (SBDs, SBIs, EBs and Projects) to be queried Various query methods have been defined: user name (also partial matches), as well as creation and last-modified dates. The last both come in 'before' and 'after' varieties A command-line interface has been added to the ODA which allows a user to query the ODA.
    • 16.6
    • Stories Completed, Integrated, Outcomes Reviewed, NFRS met, Demonstrated, Satisfies Acceptance Criteria, Accepted by FO

    Description

      As a user I want to search the ODA for matching data so that I can easily view it, edit it, or send it to the telescope for observing.

      Users need to search for the OSO database for data (projects, SBs, etc.) they want to view, edit, or send to the telescope for observing. Add search functionality to the ODA so that users can perform some standard queries (find my SBs, find SBs created between these times, etc.). Add a way for users to exercise these queries, preferably from the command line. For instance, a user at a terminal could run oda query sbd author="foo" --all-versions and see a list of all the SBDs and versions matching the query.

      The ODA has Postgres, filesystem, and memory backends. Adding query functionality to the Postgres backend has highest priority. Adding equivalent query functionality to the non-Postgres backends is desirable but not mandatory; having these backends return NotImplemented or similar would be acceptable for more complex queries. 

      The current PDM may need extending with attributes that a user would commonly want to search on, for example, an SB author or SB title.

      Remember that the ODA database technology may change, so any implementation should be easily modifiable.

      Some queries such as 'find SBs that observe around position X' might need geospatial support to be done properly. This more advanced queries are lower priority, but could be worth researching.

      Attachments

        Issue Links

          Structure

            Activity

              People

                Adam.Avison Avison, Adam
                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
                  Complete621.0
                  Total621.0

                  Dates

                    Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel