Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Migrate survey/attestation involvement_kind_ids and owner_inv_kind_ids to involvement_group #6637

Closed
5 tasks done
jessica-woodland-scott-db opened this issue Jun 1, 2023 · 0 comments
Closed
5 tasks done

Migrate survey/attestation involvement_kind_ids and owner_inv_kind_ids to involvement_group #6637

jessica-woodland-scott-db opened this issue Jun 1, 2023 · 0 comments
Assignees
@jessica-woodland-scott-db
Labels
DDL change Indicates the resolution of this issue will require a DDL change to the Waltz database fixed (test & close) An issue has been fixed, merged into master and is ready for further testing
Milestone
1.51

Comments

@jessica-woodland-scott-db
Copy link
Contributor

jessica-woodland-scott-db commented Jun 1, 2023 •
edited
Loading

Description

To support addition of a subject_kind column on involvement_kind:

  • create new columns on survey_run and attestation_run, 'involvement_group_id' and 'owner_involvement_group_id'
  • migrate data from each column to a new group with the run name and the involvement_group_entry records populated
  • drop the owner_inv_kind_ids and involvement_kind_ids columns
  • migrate survey_run creation and attestation_Run creation and views to use the new link to involvement_group
  • update any jobs (notably the ScheduledJobService reassignOwners and reassignRecipients)

Resourcing

We intend to contribute this feature
@jessica-woodland-scott-db jessica-woodland-scott-db added the DDL change Indicates the resolution of this issue will require a DDL change to the Waltz database label Jun 1, 2023
@jessica-woodland-scott-db jessica-woodland-scott-db added this to the todo : 1.51 milestone Jun 1, 2023
@davidwatkins73 davidwatkins73 modified the milestones: todo : 1.51, wip : 1.51 Jun 1, 2023
@davidwatkins73 davidwatkins73 changed the title Migrate survevy/attestation involvement_kind_ids and owner_inv_kind_ids to involvement_group Migrate survey/attestation involvement_kind_ids and owner_inv_kind_ids to involvement_group Jun 1, 2023
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Jun 7, 2023
@jessica-woodland-scott-db
DDL for migrating survey run columns
35c0753 
#CTCTOWALTZ-270
finos#6637
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Jun 7, 2023
@jessica-woodland-scott-db
DDL for migrating survey run columns
de29612 
#CTCTOWALTZ-270
finos#6637
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Jun 7, 2023
@jessica-woodland-scott-db
Migrate survey runs to use the involvement group table
a45c261 
#CTCTOWALTZ-2760
finos#6637
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Jun 7, 2023
@jessica-woodland-scott-db
Migrate survey runs to use the involvement group table
17891dc 
#CTCTOWALTZ-2760
finos#6637
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Jun 7, 2023
@jessica-woodland-scott-db
Migrate survey runs to use the involvement group table
7293a5c 
#CTCTOWALTZ-2760
finos#6637
Merged
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Jun 8, 2023
@jessica-woodland-scott-db
Migrate attestation runs to use the involvement group table
74907ca 
#CTCTOWALTZ-2760
finos#6637
deutschebank-sync pushed a commit to deutschebank/waltz that referenced this issue Jun 8, 2023
@jessica-woodland-scott-db
Migrate attestation runs to use the involvement group table
1bcdbca 
#CTCTOWALTZ-2760
finos#6637
Merged
@jessica-woodland-scott-db jessica-woodland-scott-db added the fixed (test & close) An issue has been fixed, merged into master and is ready for further testing label Jun 9, 2023
@davidwatkins73 davidwatkins73 modified the milestones: done : 1.51, 1.51 Jun 29, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jessica-woodland-scott-db jessica-woodland-scott-db

Labels
DDL change Indicates the resolution of this issue will require a DDL change to the Waltz database fixed (test & close) An issue has been fixed, merged into master and is ready for further testing
Projects
None yet
Milestone
1.51
Development

No branches or pull requests
2 participants
@davidwatkins73 @jessica-woodland-scott-db