kehh / biolink

Automatically exported from code.google.com/p/biolink
0 stars 0 forks source link

No warning is given when deleting taxa that material or associates may be orphaned. #225

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
Delete a taxa that has material associated with it, and no warning is given, 
only a generic "are you sure" warning

Original issue reported on code.google.com by david.ba...@gmail.com on 27 Nov 2014 at 11:00

GoogleCodeExporter commented 9 years ago
The original stored procedure 'spOkToDeleteTaxa' is broken as it was not 
updated to reflect the changes to the associates model. This means that it 
would have always returned false in Biolink 2.x, and a warning would have been 
generated regardless of whether there was associated material.

Rather than fix the stored procedure that would require a database script 
update, the solution is run the query directly from the client.

Original comment by david.ba...@gmail.com on 27 Nov 2014 at 11:39