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

Write migration scripts for adding obscore to USDF repos

    XMLWordPrintable

    Details

      Description

      Once pg_sphere is installed and we agreed on obscore configurations (DM-36701) we need to run migrations to add everyhting to each of the repos.

      My initial idea is that migration script would just add obscore config to butler_attributes and create the obscore teable with a correct schema (which is based on config). For actual filling of the table from pre-existing data I want to implement a separate script which will run later, that way the migration can be short and we don't need a downtime for it. The population script can run concurrently with other users, so we should not need any disruption.

      Just like for dimensions manager we'll have two separate migrations branches, one for the manager class itself, and another for configuration. It is also likely that we'll need separate migration branch for each repo, as each of them will heave an independent configuration. IT makes sense to start with a single repo as a demonstrator to show people how it's going to look like. It is also less critical for obscore to do everything right on the first iteration, we can always delete and re-create obscore table again.

        Attachments

          Activity

          salnikov Andy Salnikov created issue -
          salnikov Andy Salnikov made changes -
          Field Original Value New Value
          Epic Link DM-30629 [ 513192 ] PREOPS-1593 [ 2393150 ]
          salnikov Andy Salnikov made changes -
          Status To Do [ 10001 ] In Progress [ 3 ]
          salnikov Andy Salnikov made changes -
          Reviewers Tim Jenness [ tjenness ]
          Status In Progress [ 3 ] In Review [ 10004 ]
          tjenness Tim Jenness made changes -
          Status In Review [ 10004 ] Reviewed [ 10101 ]
          salnikov Andy Salnikov made changes -
          Resolution Done [ 10000 ]
          Status Reviewed [ 10101 ] Done [ 10002 ]

            People

            Assignee:
            salnikov Andy Salnikov
            Reporter:
            salnikov Andy Salnikov
            Reviewers:
            Tim Jenness
            Watchers:
            Andy Salnikov, Tim Jenness
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Jenkins

                No builds found.