You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Per the Desired Behavior section of the Jira story, I added a migration to remove the "Somoclone" breeding method from the system preset breeding methods.
This bi-web PR takes care of updating the import template.
Dependencies
bi-web branch: feature/BI-1680.
Testing
Checkout this branch, git checkout feature/BI-1680.
Run bi-api.
Ensure that the new migration ran (V1.20.0) by checking the bidb database, SELECT * FROM flyway_schema_history;.
Ensure that the "Somoclone" breeding method is not listed in the DeltaBreed UI, under Program Administration > Breeding Methods.
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>
when the migration was run, the following error was generated...
[ERROR] Failed to execute goal org.flywaydb:flyway-maven-plugin:7.7.3:migrate (default-cli) on project bi-api: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
[ERROR] Migration V1.21.0__remove_breeding_method.sql failed
[ERROR] ----------------------------------------------------
[ERROR] SQL State : 23503
[ERROR] Error Code : 0
[ERROR] Message : ERROR: update or delete on table "breeding_method" violates foreign key constraint "program_enabled_breeding_methods_breeding_method_id_fkey" on table "program_enabled_breeding_methods"
[ERROR] Detail: Key (id)=(20811b55-6080-459f-aca4-261fb1c95c60) is still referenced from table "program_enabled_breeding_methods".
[ERROR] Where: SQL statement "DELETE FROM breeding_method
[ERROR] WHERE abbreviation = 'SOC' AND name = 'Somoclone'"
[ERROR] PL/pgSQL function inline_code_block line 4 at SQL statement
[ERROR] Location : /Users/drp227/source/bi-api/src/main/resources/db/migration/V1.21.0__remove_breeding_method.sql (/Users/drp227/source/bi-api/src/main/resources/db/migration/V1.21.0__remove_breeding_method.sql)
[ERROR] Line : 18
[ERROR] Statement : /*
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
davedrp
left a comment
Description
Story: BI-1680
Per the Desired Behavior section of the Jira story, I added a migration to remove the "Somoclone" breeding method from the system preset breeding methods.
This bi-web PR takes care of updating the import template.
Dependencies
bi-web branch:
feature/BI-1680.Testing
git checkout feature/BI-1680.SELECT * FROM flyway_schema_history;.Checklist: