Uploaded image for project: 'Qt Quality Assurance Infrastructure'
  1. Qt Quality Assurance Infrastructure
  2. QTQAINFRA-5106

Store all data that the Coin API returns into an SQL database

    XMLWordPrintable

Details

    • Task
    • Resolution: Fixed
    • P2: Important
    • None
    • None
    • Metrics / Test Results
    • None

    Description

      This is not about storing test results (described in QTQAINFRA-4566), but about storing coin info about tasks and workitems, so that we can query them afterwards.

      Steps

      1. Design database schema
      2. Setup PostgreSQL server, create database with tables
      3. Write tool that polls Coin API and populates the database
      4. Run it forever!
      5. Add nice SQL views to the database so that the data is easy to query despite the normalized schema.

      Attachments

        1. coin_db.png
          262 kB
          Dimitrios Apostolou

        Issue Links

          blocks

          Task - A task that needs to be done. QTQAINFRA-4566 Implement test result parser & db importer

          • P2: Important - Urgent, should be fixed, but will not stop the release.
          • Closed
          relates to

          Task - A task that needs to be done. QTQAINFRA-4563 Create optimized datamodel (schema) for storing/viewing passed/failed data per testcase

          • P2: Important - Urgent, should be fixed, but will not stop the release.
          • Closed

          Activity

            People

              jimis Dimitrios Apostolou
              jimis Dimitrios Apostolou
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: