Skip to content

OBPIH-6327 Data model should support "to pick" and "picked" stages#4607

Merged
awalkowiak merged 2 commits intofeature/upgrade-to-grails-3.3.10from
OBPIH-6327-2
May 7, 2024
Merged

OBPIH-6327 Data model should support "to pick" and "picked" stages#4607
awalkowiak merged 2 commits intofeature/upgrade-to-grails-3.3.10from
OBPIH-6327-2

Conversation

@alannadolny
Copy link
Collaborator

No description provided.

addForeignKeyConstraint(
baseColumnNames: "picker_id",
baseTableName: "picklist_item",
constraintName: "fk_picker_person",
Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

One thing that caught my eye before merging it. Could you change the name of this constraint to match a convention of having names of base table name and referenced table name -> fk_picklist_item_person

Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Actually, your version makes more sense, let me think shortly about this one

Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Yeah I was partially right. We usually do fk + base table name + base column name (without _id) for these constraint names, so I think this could be the way for this one, but your version fk + base column name + reference table name is ok too I guess

Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

As discussed internally on slack we are going to use a convention of fk_baseTable_baseColumn_referenceTable if the changelogs are not generated.

@awalkowiak awalkowiak merged commit 4d6107f into feature/upgrade-to-grails-3.3.10 May 7, 2024
@awalkowiak awalkowiak deleted the OBPIH-6327-2 branch May 7, 2024 10:33
Copy link
Member

@jmiranda jmiranda left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Sorry, just got to this now. LGTM.

Copy link
Member

@jmiranda jmiranda left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

... although I'm starting to second guess myself on the naming of the picker property. Should have probably been pickedBy to stay consistent with other fields.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants