Description

BI-2203 Insert sandbox email into bi_user table

Please include a summary of the change that was made.

• Created 2 migrations

1. A java migration to populate the email of the "BI-DEV Admin" user (based on whether it should be authorized with sandbox Orcid or the production Orcid).
2. A migration to add a constraint on the bi_user table (that prevents the orcid id from being non-null if the email is null).

• Added a configuration variable (ORCID_SANDBOX_AUTHENTICATION) that is true if the Oricid Sandbox should be used, and false infthe production Orcid should be used.

Testing

• verify that the migration inserts the address in the table
• sign in to Deltabreed with sys admin permissions and add a new user to the system with bidevteam@mailinator.com as the address and confirm that this is prevented and an error message is returned saying that a user with that address already exists.

Checklist:

• I have performed a self-review of my own code
• I have tested my code and ensured it meets the acceptance criteria of the story
• I have tested that my code works with both the brapi-java-server and BreedBase
• I have create/modified unit tests to cover this change
• I have commented my code, particularly in hard-to-understand areas
• I have made corresponding changes to documentation
• I have run TAF: <please include a link to TAF run>