Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-21893

Stand up system for running CI tests against PostgreSQL-backed Gen3 Registries

    Details

    • Team:
      Data Facility

      Description

      My idea scenario for continued testing of PostgresRegistry would be to have some kind of system that allows a few priveleged accounts (MW devs + jenkins) to request a temporary empty schema.  This would involve some kind of API that allows the requestor to indicate when they're done with the schema, allowing it to be deleted (or cleared and reused, if, say, this is implemented as a fixed-size pool of persistent schemas).  I could imagine in some cases the same requestor might want multiple schemas simultaneously to be used in concert (for tests on a multi-user Registry, for example).  Most often, a suite of tests that could be run in parallel would ideally want to grab one schema for each (usually short-lived) test.

      All of this is negotiable, of course, and there are other approaches that would let us add at least some test coverage for Postgres that would require less effort on the service side.  I'm assigning this ticket to Christopher Stephens in the hopes he'll push us to at least keep discussing this and looking for a solution, and I figure we'll create different tickets if we decide to take a substantially different approach.

       

        Attachments

          Activity

          Hide
          mgower Michelle Gower added a comment -

          It would be ideal if the solution could also work for a developer without having to submit a Jenkins job.

          Show
          mgower Michelle Gower added a comment - It would be ideal if the solution could also work for a developer without having to submit a Jenkins job.
          Hide
          jbosch Jim Bosch added a comment -

          Relevant discussion on the PR for DM-22508.

          Show
          jbosch Jim Bosch added a comment - Relevant discussion on the PR for DM-22508 .
          Hide
          tjenness Tim Jenness added a comment -

          Should we change all mentions of Oracle here to something closer to reality?

          Show
          tjenness Tim Jenness added a comment - Should we change all mentions of Oracle here to something closer to reality?
          Hide
          jbosch Jim Bosch added a comment -

          Yes, this should be PostgreSQL now.

          Show
          jbosch Jim Bosch added a comment - Yes, this should be PostgreSQL now.

            People

            • Assignee:
              cs2018 Christopher Stephens
              Reporter:
              jbosch Jim Bosch
              Watchers:
              Andy Salnikov, Christopher Stephens, Fritz Mueller, Jim Bosch, Michelle Gower, Tim Jenness
            • Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:

                Summary Panel