admin - delete a keyword

[TanyaStere42]

Context

admins should be able to clear up the database and remove a keyword, including all instances of it currently in use

user story

DELETE /api/v1/keywords/GUID

• admin only
• removes keyword from all annotations
• deletes keyword from database

resources

[TanyaStere42]

needed for WildMeOrg/codex-frontend#529

[naknomum]

the code to do the api with keyword delete already exists, however it does not work as expected

• right now, when you do DELETE /api/keywords/GUID you get an error, unless the keyword is not being used. this is due to the fact the db removal of the database (rightly) errors, since it is being referenced ("in use")
• i think the solution might be to enable cascade delete on the join table which combine: Assets and Keywords, as well as the one which combine Annotation and Keywords
• here is an example of the code to define a cascade delete

i think it would be best to first just create a keyword (aka "tag") on an image (Asset). then do the API to delete it. you should see the error, which would look like below. then modify the table definition to allow the delete, and you should see the error go away and the keyword allowed to be deleted.

ERROR:  update or delete on table "keyword" violates foreign key constraint "fk_annotation_keywords_keyword_guid_keyword" on table "annotation_keywords"
DETAIL:  Key (guid)=(50e98d54-76e0-48c2-8899-53946b7c5b81) is still referenced from table "annotation_keywords".