Skip to content

Instantly share code, notes, and snippets.

@kaicode

kaicode/traceability-branch-deletion.sql

Last active April 4, 2016 13:28
Show Gist options
  • Save kaicode/f86b1d6a36ea051e66b0357e4462434c to your computer and use it in GitHub Desktop.
Save kaicode/f86b1d6a36ea051e66b0357e4462434c to your computer and use it in GitHub Desktop.
Download ZIP
Delete branch traceability data (Updated to use variable)
Raw
traceability-branch-deletion.sql
set @branch='MAIN/WRPTEST/WRPTEST-336'
delete from component_change where concept_change_id in (select id from concept_change where activity_id in (select id from activity where branch = (select id from branch where branch_path=@branch)));
delete from concept_change where activity_id in (select id from activity where branch = (select id from branch where branch_path=@branch));
delete from activity where branch = (select id from branch where branch_path=@branch);
delete from branch where branch_path=@branch;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment